En cours

API for geolocalized Point of interests in PHP

Context

SQL db is containing a list of ‘Point of Interests’ POI with name and full postal address. This project is containing 2 parts. First part will be to populate gps (lat,long) inside DB with correct positioning, and second part will be to create a simple RESTful API to access the data.

Technology

• PHP

• RESTful using framework SLIM ([url removed, login to view])

• JSON format

• Google geocoding API ([url removed, login to view])

Part 1: Adding GPS lat, long to existing database

The gps (lat,long) coordinates will need to be added for all entry from table ‘poi’ (see structure here after). For that we will need to have an HTML page contain a button to run the geocoding process each time I want to add new POI inside DB.

You will use google geocoding service to record (lat,long) coordinates for every POI.

Database structure

CREATE TABLE IF NOT EXISTS `poi` (

`id` INT NOT NULL AUTO_INCREMENT ,

`company` VARCHAR(128) NOT NULL ,

`address` VARCHAR(128) NOT NULL ,

`zip` VARCHAR(45) NOT NULL ,

`city` VARCHAR(128) NOT NULL ,

`tel` VARCHAR(45) NULL ,

`category` INT NULL ,

`gps_lat` FLOAT NULL ,

`gps_long` FLOAT NULL ,

PRIMARY KEY (`id`) )

HTML page

HTML page will contain 3 paragraphs as follow

Status summary on current DB:

Total of ‘POI’ inside DB: 300 (300 is just an example)

POI containing a valid GPS coordinate: 0 (before running geocoding, no POI will contain GPS point)

Geocoding process

Max request: 100(textfield to fix a limit on number of request to google api)

Click here to start geocoding (button to launch geocoding process)

Error status

No error encountered (text zone to display if any error occurred)

Part 2: Develop an API to handle 2 web services

1. Provide an access to a particular POI

GET <website>/api/poi/3

List POI object with all fields for poi_id=3

Format

{

"id": "1",

"company":"my company",

"address":"place de la concorde",

"zip":"75000",

"city":"Paris",

"tel":"1234567890",

"category":"1",

"gps_lat": "48.8604",

"gps_long": "2.34232"

}

2. Provide a list of POI around a particular GPS position

GET <website>/api/list?position=48.8&2.3&distance=1

This request should return a list of POI, in JSON format, around the position GPS (48.8 ; 2.3) and at maximum 1 kilometer around this position.

Format

[

{

"id": "1",

"company":"my company",

"address":"place de la concorde",

"zip":"75000",

"city":"Paris",

"tel":"1234567890",

"category":"1",

"gps_lat": "48.8604",

"gps_long": "2.34232"

},

{

"id": "2",

"company":"my other company",

"address":"place de la gare",

"zip":"75000",

"city":"Paris",

"tel":"1234567890",

"category":"1",

"gps_lat": "48.8604",

"gps_long": "2.34232"

}

]

Misc

Credentials (login/password) and website url will be provided only after the deal is close with the selected developer

Compétences : HTML, MySQL, PHP, Architecture Logicielle

Voir plus : www google com web developer, web service for developers, web project documentation format, web developer paris, web de develop, use of data structure, table in web developer, summary of web developer, summary of a web developer, summary for web developer, services php developer, project of website in html, project list in php, php software developers, php developer service, php developer position, php developer paris, php develop company, php create table, object software developer, my sql developers, my correct address, login page create in php, list of php developers, list of data structure

Concernant l'employeur :
( 4 commentaires ) Nice, France

N° du projet : #2389542

Décerné à :

stefanache

Hello, Please consult your PMB. Thanks.

100 $ USD en 5 jours
(16 Commentaires)
4.8

13 freelance ont fait une offre moyenne de 275 $ pour ce travail

kabirchy

Hi, I can help you get this done. I will do both sections. Thanks

250 $ USD en 5 jours
(753 Commentaires)
8.2
khanhhuyna

I'm interesting and happy to work this for you. Thanks.

300 $ USD en 7 jours
(92 Commentaires)
6.5
wsfreelanzer

Hi i'm a PHP Programmer. I reviewed your requirement. I can do this project. Here is my previous work links. [url removed, login to view] [url removed, login to view] [url removed, login to view] check out the links and Plus

120 $ USD en 3 jours
(46 Commentaires)
5.9
stdhtelkom

Hello, Very familiar with what you need. Ready to start. Thanks, Steve

200 $ USD en 4 jours
(15 Commentaires)
5.6
hafeez

Respected Client, Please review private message and provided links for further understanding of expertise. Thank you.

250 $ USD en 8 jours
(14 Commentaires)
5.5
sunlark

Hello, I'm interested in and can complete both parts.

100 $ USD en 7 jours
(9 Commentaires)
5.3
hegazy

i developed many location based apps. Can finish this in 3 weeks.

1250 $ USD en 20 jours
(7 Commentaires)
4.4
firmy24

It's all clear for me. I can start now.

190 $ USD en 7 jours
(5 Commentaires)
4.1
ARBiz

Please check pmb

170 $ USD en 5 jours
(5 Commentaires)
3.7
transwebsolution

Please check your PM for bid details.

230 $ USD en 12 jours
(3 Commentaires)
4.4
soper

Hello, I'm qualified web-programmer with more than 10 years of experience in PHP, MySQL, JavaScript, CSS, HTML. My bid details in PM. Thanks

250 $ USD en 3 jours
(5 Commentaires)
3.1
rakhon

Hi, I am interested.

170 $ USD en 4 jours
(6 Commentaires)
3.0
csabikuc

hello i am interested in your project

200 $ USD en 10 jours
(0 Commentaires)
0.0