$developerkey,
"websiteId" => $websiteIdx,
"advertiserIds" => $AdvertiserIDs,
"keywords" => $Keywords,
"serviceableArea" => "",
"upcOrIsbnOrEan" => "",
"manufacturerName" => "",
"advertiserSku" => "",
"lowPrice" => $LowPrice,
"highPrice" => $HighPrice,
"currency" => "",
"sortBy" => "",
"orderIn" => "",
"startAt" => 0,
"maxResults" => 150
);
$proxy = $soapclient->getProxy();
$result = $proxy->search($params);
$count = $result['searchReturn']['count'];
if($count > 0){ // you could increase this amount to 5 or 10 to ensure that you're getting a good product list.
$sql = "DELETE FROM tblProducts;
if(!mysql_query($sql,$connect)){
echo "DB error - 1.0";
exit();
}
for($i = 0; $i < $count; $i++){
$advertiser_id = $result['searchReturn']['products']['products'][$i]['advertiserId'];
$advertiser_name = $result['searchReturn']['products']['products'][$i]['advertiserName'];
$click_url = $result['searchReturn']['products']['products'][$i]['clickUrl'];
$currency = $result['searchReturn']['products']['products'][$i]['currency'];
$description = $result['searchReturn']['products']['products'][$i]['description'];
$image_url = $result['searchReturn']['products']['products'][$i]['imageUrl'];
$name = $result['searchReturn']['products']['products'][$i]['name'];
$price = $result['searchReturn']['products']['products'][$i]['price'];
$sku = $result['searchReturn']['products']['products'][$i]['sku'];
$upc = $result['searchReturn']['products']['products'][$i]['upc'];
echo $name."
";// debug
$sql = "INSERT INTO tblProducts(ID, AdvertiserID, AdvertiserName, ClickURL,
Currency, Description, ImageURL, Name, Price, SKU, UPC)
VALUES('".substr(md5(uniqid(rand(),1)),0,8)."',
'".mysql_real_escape_string($advertiser_id)."',
'".mysql_real_escape_string($advertiser_name)."',
'".mysql_real_escape_string($click_url)."',
'".mysql_real_escape_string($currency)."',
'".mysql_real_escape_string($description)."',
'".mysql_real_escape_string($image_url)."',
'".mysql_real_escape_string($name)."',
'".mysql_real_escape_string($price)."',
'".mysql_real_escape_string($sku)."',
'".mysql_real_escape_string($upc)."')";
if(!mysql_query($sql,$connect)){
echo "DB error 1.1";
exit();
//echo mysql_error()."
";
//echo $sql."
";
}
}
}
unset($count);
unset($result);
unset($proxy);
unset($params);
$sql = "OPTIMIZE TABLE `tblProducts`";
if(!mysql_query($sql,$connect)){
echo "Database Error";
exit();
}
?>