批量添加

格式: 
        insert into 表(字段1,字段2) values(1,a),

        (2,b),
        (3,c);
 下面是我根据shopnc 商城给的方法写的代码:
        $result = $goods_model->save($params);
        $getId = $result;

$attr_name = '';
for($i = 0;$i<count($_POST['attrname']);$i++){
$attr_name .= "(".$getId.",".$_POST['attrid'][$i].","."'".$_POST['attrname'][$i]."'"."),";
}
$attr_name = trim($attr_name,",");
if($_POST['attrname']){
$insert = Model()->execute("INSERT INTO qqjc_goods_attr(`goods_id`,`attr_id`,`attr_value`) VALUES $attr_name");
}
posted @ 2017-03-17 10:05  杨广伟9527  阅读(151)  评论(0编辑  收藏  举报