simple ebay php api

language - php 5.3 mysql 5 I need a script which will be run on a cronjob from the command, to retrieve a current list of all my ebay listings. I have some similar script for another function that should be copied. Do not use the ebay php framework. The function called should be GetMyeBaySelling. You have to handle pagination since there will be more than 10,000 records returned. Here is an example to follow: $authToken = 'xx'; $url = '[login to view URL]'; $header = array( 'Accept: application/json', 'Authorization: TOKEN '.$authToken, 'Content-Type: application/json', 'X-EBAY-C-MARKETPLACE-ID: EBAY-US' ); $ch = curl_init(); curl_setopt($ch, CURLOPT_VERBOSE, false); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $response = curl_exec($ch); if(curl_errno($ch)){ echo "ERROR:".curl_error($ch); } curl_close($ch); $data = json_decode($response,true); #retrieve total $total = $data['total']; $i=0; while ($i < $total) { $i++; #insert with INSERT IGNORE INTO table all available columns into mysql } There should be 2 tables in mysql called "listings_running" with approx 46 columns and another table called "listings_shippingserviceoptions" with approx 4 columns with the "ItemID" column to link them together, with the following columns logged. This is just a list of the fields returned from the api. These can be the mysql field names. BestOfferCount int BuyItNowPrice (double) ClassifiedAdPayPerLeadFee (double) CurrencyCodeType varchar eBayNotes varchar HideFromSearch boolean ItemIDType varchar LeadCount int ConvertedBuyItNowPrice (double) StartTime dateTime ListingDuration varchar ListingType varchar NewLeadCount int PictureDetails PictureDetailsType PrivateNotes varchar Quantity int QuantityAvailable int QuestionCount long ReasonHideFromSearch varchar ReservePrice (double) PaymentProfileID long PaymentProfileName string ReturnProfileID long ReturnProfileName varchar ShippingProfileID long ShippingProfileName varchar BidCount int BidderCount long ConvertedCurrentPrice (double) CurrentPrice (double) FeedbackRatingStar varchar FeedbackScore int UserID varchar promotion_EndTime dateTime promotion_OriginalPrice (double) promotion_StartTime dateTime QuantitySold int ReserveMet boolean GlobalShipping boolean SKUType varchar StartPrice double TimeLeft varchar Title varchar WatchCount long *listings_shippingserviceoption_ID *auto increment on a new table called listings_shippingserviceoptions *LocalPickup boolean *ShippingServiceCost double **skip the variation related data