php_script/youxuan_upda...

<?php

require_once 'DB_PDO.class.php';
require_once 'TBK.class.php';
require_once 'conf.class.php';

define("GROUPID",2283);//优选商品
define("KEYURL","https://item.taobao.com/item.htm?id=");
/**
 * 更新优选商品剩余数量数据
 */
#设置时区
date_default_timezone_set('PRC');

$_PDO=DB_PDO::getInstance( conf::$DB_CONF );

$sql = " select gg.goods_id from `group_goods` gg left join `group` g on gg.group_id=g.id where g.parent_id = :group_id ";
$stmt = $_PDO->prepare($sql);
$stmt->execute(array(':group_id'=>GROUPID));
$goods = $stmt->fetchAll(PDO::FETCH_ASSOC);
$total_num = 0;
$update_num = 0;
foreach( $goods as $k=>$v ){
	$total_num++;
	$keyword = KEYURL.$v['goods_id'];	
	$result = TBK::search( $keyword );
	if( !isset($result->coupon_remain_count )) continue;
	$coupon_surplus = $result->coupon_remain_count;
	$sql = " update goods set coupon_surplus = :coupon_surplus where goods_id = :goods_id ";
	$stmt = $_PDO->prepare($sql);
	$stmt->execute(array(':coupon_surplus'=>$coupon_surplus,':goods_id'=>$v['goods_id']));
	$res = $stmt->rowCount();
	if($res){
		$update_num++;
		echo "\n\n更新成功:".$res;
		var_dump($v['goods_id']);
	}
	//if($total_num == 3) break;
}
echo "\n总共".$total_num."条数据";
echo "\n成功更新".$update_num."条数据";