#逻辑层
public function batchInsert() {
//接收到数组数据 $data
$values_arr = [];
foreach($data as $value) {
$key = array_keys($value);
$value = array_values($value);
$keys = implode($key,',');
$values_arr[] = implode("','", $value);
}
$res = Customer_InfoModel::batchInsert($keys,$values_arr);
return $res;
}
#Model数据处理
public function batchInsert($keys,$values_arr){
//拼接SQL
$sql = "INSERT INTO Customer ($keys) VALUES ('".implode("'),('", $values_arr)."') ";
$res = $this->_db()->query($sql);
return $res;
}
PHP批量插入实例
最新推荐文章于 2023-04-26 12:29:40 发布