Đã hoàn thành

328183 address to longitude latitude

we have a mysql table named "contacts" that contain the following fields:

address1

address2

city

state

zip

latitude

longitude

The longitude & latitude fields are currently blank and newly created address each day will have blank longitude & latitude fields too. We need a php script written that will query each row where longitude & latitude is empty, obtain longitude & latitude using the address, city, state, zipcode for that row and insert the longitude & latitude info into the respective field for that row. We will run this script frequently (maybe a few time a day) to populate the missing longitude & latitude fields.

Kĩ năng: Bất kì công việc gì, MySQL, PHP

Xem nhiều hơn: php mysql longitude, named query, mysql longitude latitude, no address to, longitude, latitude, zipcode city, mysql populate table, latitude longitude table, insert mysql table, populate table using, missing table, latitude longitude script, script latitude, state zipcode address, address state, address zip, state city mysql, php address table, mysql php insert script

Về Bên Thuê:
( 31 nhận xét ) Phoenix, United States

ID dự án: #2073991

Được trao cho:

uhjk

Let's get it done.

$50 USD trong 0 ngày
(508 Đánh Giá)
7.3