PHP Script for Google Maps API

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]