Sedang Disiapkan

2 Simple PHP/MySql projects....

Project 1....Bottom line….We want to know which location is closest to the city and state we provide and what that number set. This should not be a lot of work, as we have provided all the data, and have provided examples of the code. I need this done within 12 hours of awarding the job. If you cannot do that, then do not bid!

Table zipData

Contains Location_id for some primary locations

Zip Code

Latitude

Longitude

City

And State

Table tmp_job_data is to contain data that is loaded from an Excel spreadsheet. 2 of the fields on this sheet are city and state.

You are to create a data loader using MYSQL and PHP that will take the File

1. Load it into tmp_job_data

2. Query the ZipData table for the Latitude and Longitude of the City and State Located in the tmp_job_data

3. Compare results of #2 with the closest Latitude and longitude in zipData where the Location_id field is not Null using the method described in [url removed, login to view] and insert the closest location_id from zipData into the tmp_job_data

4. Load tmp_job_data into job_data

Project 2. (these sites are not related)

Cut in a new template into an old site.

Old site....[url removed, login to view]

The Template is at [url removed, login to view]

Both projects are very simple, we just do not have the time to get them done! Get the Data loader done first!

Kemahiran:

Lihat lebih lanjut: droddy messageboards, simple spreadsheet examples, projects line, primary job, php create table, line projects, new line php, get php projects work, get php projects, do projects, create table php, bid examples, get php, simple data insert, spreadsheet 2, simple , simple query, projects c, primary, null, new projects, need projects, mysql, mysql query, longitude

Tentang Majikan:
( 6 ulasan ) San Mateo, United States

ID Projek: #10831