php 批量插入记录

php 批量插入记录

<div style="font-size: 14px">
<form method="post" action="index.php?mod=<?=MOD?>&act=<?=ACT?>&code=<?=$code?>"><input name="p[]" value="<?=$quanzhanye?>" size="10" /><input type="submit"  value="采集页数" /><input name="s[]" value="<?=$quanzhanzongye?>" size="10" /><input type="submit"  value="采集总页数" />
<?php 
for ($ye=1; $ye<=5; $ye++) {
$url='http://api.***page='.$ye.'';/**网站专用API接口**/
$caijishuju=file_get_contents($url);
$caijishuju=json_decode($caijishuju,true);
$caijishu=$caijishuju['data'];
if($caijishu['total_num']<>0){
echo $ye.'，记录数'.$caijishu['total_num'].'，';}}
?></form></div>

<?php 
if(!defined('ADMIN')){
exit('Access Denied');
}
include(ADMINTPL.'/header.tpl.php');
if ($_POST['p'][0]==''){
$quanzhanye=1;}
else{$quanzhanye = $_POST['p'][0];}
if ($_POST['s'][0]==''){
$quanzhanzongye=1;}
if ($_POST['p'][0]<>''){
$quanzhanzongye=$quanzhanye;}
else{$quanzhanzongye = $_POST['s'][0];}
for ($yeshu=$quanzhanye; $yeshu<=$quanzhanzongye; $yeshu++) {//ceil($caijishu['total_num']/200)
$url='http://api.***page='.$yeshu.'';//网站专用API接口
$data=file_get_contents($url);
$data=json_decode($data,true);
$shuju=$data['data']['result'];
$i=0; 
foreach($shuju as $val){
$i++;
if ($val['IsTmall'] == 1){
  $shitmall="天猫";
  $laiyuan_type="2";
  $yuanurl='https://detail.tmall.com/item.htm?id=';
} else {
  $shitmall="淘宝";
  $laiyuan_type="1";
  $yuanurl='https://item.taobao.com/item.htm?id=';
}
if ($val['Cid'] == 1){
  $fenlei="10001";
} 
if ($val['Cid'] == 2){
  $fenlei="10005";
}
if ($val['Cid'] == 3){
  $fenlei="10003";
}
if ($val['Cid'] == 4){
  $fenlei="10006";
}
if ($val['Cid'] == 5){
  $fenlei="10002";
}
if ($val['Cid'] == 6){
  $fenlei="10004";
}
if ($val['Cid'] == 7){
  $fenlei="10011";
}
if ($val['Cid'] == 8){
  $fenlei="10007";
}
$result = mysql_query('select * from duoduo_goods where data_id = '.$val['GoodsID'].'');
$row = mysql_fetch_assoc($result);
if($row){
echo '<div style="background-color: #FCF;  margin: 1px; width: 140px; height: 20px; float: left;">'.$yeshu.'-'.$i.','.$val['GoodsID'].'<a href="'.$val['ali_click'].'" target="_blank"></a>重复</div>';
}else{

$val['yuan_url']=$yuanurl.$val['GoodsID'];
 if ($val['yuan_url'] <> $val['ali_click']){
  $sql = "INSERT INTO duoduo_goods(url,laiyuan,laiyuan_type,code,cid,title,img,data_id,discount_price,price,content,starttime,endtime,addtime,fanli_bl,price_man,price_jian,lq_url,tg_url,sell) values('".$val['ali_click']."','".$shitmall."','".$laiyuan_type."','tjb','".$fenlei."','".$val['Title']."','".$val['Pic']."','".$val['GoodsID']."','".$val['Price']."','".$val['Org_Price']."','".$val['Introduce']."','".strtotime(date('Y-m-d H:i:s'))."','".strtotime('+1 day',strtotime($val['Quan_time']))."','".strtotime(date('Y-m-d H:i:s'))."','".$val['Commission_jihua']."','".$val['Org_Price']."','".$val['Quan_price']."','".$val['Quan_link']."','".$val['ali_click']."','".$val['Sales_num']."');"; //REPLACE INTO 替换插入
mysql_query($sql);
$cg=0;
$cg++;
echo '<div style="background-color: #3CF;  margin: 1px; width: 140px; height: 20px; float: left;">'.$yeshu.'-'.$i.','.$val['GoodsID'].'<a href="'.$val['ali_click'].'" target="_blank"></a>成功</div>'; 
} else {
  echo '<div style="background-color: #FC3;  margin: 1px; width: 140px; height: 20px; float: left;">'.$yeshu.'-'.$i.','.$val['GoodsID'].'<a href="'.$val['ali_click'].'" target="_blank"></a>未转</div>';
}}
}}
?>
<?php include(ADMINTPL.'/footer.tpl.php');?>