### createBatch **在數據表中批量新增數據** **參數** \* @param $row 數組形式，數組的鍵是數據表中的字段名，鍵對應的值是需要新增的數據。 \* @param $addObjs 數組形式，數組的鍵是數據表中的字段名，鍵對應的值是需要新增的數據。 \* @param $keyword 字符串類型,拼裝SQL時,會檢驗數組中的$val\[$keyword\]中是否有值,沒有則忽略該條數據 ~~~ public function createBatch($rows, $addObjs = null, $keyword = null) { if (! is_array ( $rows ) || count ( $rows ) == 0) return FALSE; $valArr = array (); $cols = array (); $row_frist = reset ( $rows ); // foreach ( $row_frist as $key => $value ) { // $cols [] = $key; // } $cols = array(); foreach ( $rows as $key=>$row ) { $row = $this->__prepera_format ( $row ); $rows[$key]=$row; } foreach ( $rows as $key => $value ) { $keyarr = array_keys($value); $cols=array_merge($cols,$keyarr);//合并所有數據列 } $cols = array_unique($cols); $col = join ( ',', $cols ); //判斷是否有額外增加數組，有則加上 if (! empty ( $addObjs )) { foreach ( $addObjs as $key => $value ) { $col .= ',' . $key; } } foreach ( $rows as $row ) { if (! empty ( $keyword ) && empty ( $row [$keyword] )) { continue; } $vals = array (); //按輸入字段來生成數組,不存在則生成空字符串(主要應對checkbox) foreach ( $cols as $value ) { if (isset ( $row [$value] )) { $vals [] = "'" . $this->__val_escape ( $row [$value] ) . "'"; } else { $vals [] = "''"; } } // foreach ( $row as $key => $value ) { // $vals [] = "'" . $this->__val_escape ( $value ) . "'"; // } //判斷是否有額外數組，有則加上 if (! empty ( $addObjs )) { foreach ( $addObjs as $key => $value ) { $vals [] = "'" . $this->__val_escape ( $value ) . "'"; } } $valArr [] = "(" . join ( ',', $vals ) . ")"; } if (empty ( $valArr )) { return FALSE; } $val = implode ( ",", $valArr ); $sql = "INSERT INTO {$this->tbl_name} ({$col}) VALUES {$val}"; // echo $sql; return $this->_db->query ( $sql ); } ~~~