1.直接上代碼,關鍵是會用
2.代碼如下:
<?php #添加推薦到英文站 $file = fopen('code.csv','r'); while ($data = fgetcsv($file)) { //每次讀取CSV里面的一行內容 //print_r($data); //此為一個數組,要獲得每一個數據,訪問數組下標即可 $goods[] = $data;}//var_dump($goods);foreach($goods as $key =>$value){$id=$value['0'];// echo $id;exit();$code=$value['1'];$area=$value['2'];$time=time();echo $id;echo $code;$area1="array ('title' => '$code','inputtime' => '$time','style' => '', )"; echo $area1;$db_connect=mysql_connect('localhost','root','root') or die("Unable to connect to the MySQL!"); //選擇一個需要操作的數據庫mysql_select_db('huamei',$db_connect);mysql_query("SET NAMES gbk");echo $sql1="insert into v9_position_data(id,catid,posid,module,modelid,thumb,data,siteid,listorder,expiration,extention,synedit)values('$id','11','18','content','13','0',\"$area1\",'1','".$id."','0','','0')";// exit();/* $rs1=mysql_query($sql1);if($rs1>0){echo "執行成功";echo "<br/>";}else{echo "執行失敗";echo "<br/>";} */if(mysql_query($sql1))//插入成功后返回true,失敗返回falseecho "添加成功"; else echo "添加失敗";}fclose($file); ?>
?