$arr = array(
   array('id'=>4,'name'=>'ceshi4'),
   array('id'=>5,'name'=>'ceshi5'),
   array('id'=>6,'name'=>'ceshi6'),
);
foreach($arr as $v){
    $valueStr .= "(".$v['id'].",'".$v['name']."'),";
} 

$valueStr = rtrim($valueStr,',');
$sql = "INSERT into `td_list`(id,name) values $valueStr";

 

posted on 2017-02-28 14:26  晨曦年华  阅读(6644)  评论(0编辑  收藏  举报