We need a php script that would query mysql table (see table structure below) where DistanceText , DistanceValue, DurationText, and DurationValue are null.
CREATE TABLE `EST_DealerZipCodeDistanceTravelTime` (
`OrginZipCode` varchar(5) NOT NULL,
`DestinationZipCode` varchar(5) NOT NULL,
`DistanceText` varchar(255),
`DistanceValue` int(11),
`DurationText` varchar(255),
`DurationValue ` int(11));
The php script should call the Google API URL to generate a return json string with the needed values, an example of that URL is below:
[login to view URL]
The values within the URL should be as follows:
• Units = imperial
• orgins = OrginZipCode (from mysql table)
• destination = DestinationZipCode (from mysql table)
• key = your google developer key, we will use our own once the code is completed
The URL should return a Json response where the returned value for Distance Text, Distance Value,Duration Text and Duration Value should be updated into their corresponding fields in the MySql table where the OrginZipCode and DestinationZipCode were equal to what was originally queried.
For further reference you can view: [login to view URL]
Hello,
i have read your job description and fully understand your requirements.
It looks like I’ll be the perfect candidate for this job because I have hands on experience in this field.
Could you provide us more details about your needs?
I will make all changes which you want until you'll be satisfied.
i have more than 3 years of experience in this. I am sure i can successfully complete your job within short period.
For sample work you can view my portfolio. thanks
Hi,
I have 7yrs+ working experience in software development, I have developed multiple web applications using PHP/Mysql, wordpress, Cakephp, Codeiginator etc.
I have also worked on multiple 3rd party api.
I will happy to work together
Thanks,
Hello,
I am available to discuss the project and ready to get started. I have a team of highly skilled professionals, which consists of Designers, Web and App Developers.
Relevant Skills and Experience
We have enough experiences with WEB development for 10+ years.
Looking forward to your response, Lets discuss more over Chat box.
Hi, I read your requirement very carefully but i need more requirement to start the work. Contact me as soon as possible for best work. I am expert in core php, frameworks like codeignitor , laravel, woo commerce etc. For your task of scripting i will best assist. Contact me for best assistance in low budget
At Texthouse , we combine strong in-house solutions with well-established global technological brands to harness the concerns of over 100 customer relationships in more countries. Today, we are the foremost technology based enterprise-wide business applications and systems solutions provider with the recognition in providing our clientele with a multitude of exceptional solutions.
Texthouse is in many industries currently in Bulk SMS Gateway Company was launched, We provide all marketing solutions for enterprises as well.
Texthouse is as well having a small team in writing and literally programming works. Our Writers provide the articles in marketing process. We have a Special team who will do this well.
If you are not satisfied with our project then yes money back is guarantee.
and these are following skills my team posses ;
Android Asp.
Javascript Php
C# Php
Asp net Android
Angular UI & UX
CSS,Saas
Javascript
C
Java
Python
NET
Ruby
C#
SQL
C++
ReactJS
NodeJS
AngularJS
Android
PHP
iOS
App Develop
Web Scraper
WordPress
Social Networking
HTML
HTML 5
Architecture
Logo Design
Website Designing
Bitcoin
Thank you
Emma k