批量添加
格式:
insert into 表(字段1,字段2) values(1,a),
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");
}
Try