Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function insertManyRows(string $table, array $data)
- {
- $columnsName = $this->getColumnName($table);
- $columns = array_column($columnsName, 'COLUMN_NAME');
- $columnKeys = array_flip($columns);
- $insertString = function ($dataRow) use ($columnKeys) {
- return array_intersect_key($dataRow, $columnKeys);
- };
- $inserts = array_map($insertString, $data);
- $keys=array_keys($inserts[0]);
- $i=0;
- foreach ($inserts as $value){
- if($i==0){
- $values="('" . implode("', '", $value) . "')";
- }else{
- $values=$values.",('" . implode("', '", $value) . "')";
- }
- $i+=1;
- }
- $fieldNames = implode(', ', $keys);
- $sql = "INSERT INTO `$table` ($fieldNames) VALUES :values ";
- //TODO log
- return $this->exec($sql,array('values'=>$values),true);
- }
Advertisement
Add Comment
Please, Sign In to add comment