范例
$sql = "INSERT INTO tablename ('username','password') values ('xxx','xxx'),('xxx','xxx'),('xxx','xxx'),('xxx','xxx'),('xxx','xxx'),('xxx','xxx') ......." /** * * @param $id * @param $data * @return mixed */ public function batchInsertBySimId($id, $data) { $sql = "insert into mvno_sim_flow_config (`sim_id`,`region_name`,`flow`) values "; $res_array = []; foreach ($id as $id_key => $id_value) { foreach ($data as $data_key => $data_value) { $str = $data[$data_key][2]; $sql .= '(' . $id_value . ',' . '"' . $str . '"' . ',' . $data[$data_key][1] . '),'; } } $sql = substr($sql, 0, strrpos($sql, ",")); //$sql = substr($sql ,0 ,-1); $result = $this->query($sql);//框架执行原生ｓql if ($result) { return true; } else { return null; } }