PHP çoklu veri ekleme
2
●124
- 18-02-2023, 23:39:59
function insert($table, $data) { $connect = new PDO("mysql:host=localhost;dbname=testing", 'root', ''); $keys = array_keys($data[0]); $columns = implode(',', $keys); $values = array(); foreach ($data as $rowValues) { $rowValues = array_map(function($value) use ($connect) { return $connect->quote($value); }, $rowValues); $values[] = '(' . implode(',', $rowValues) . ')'; } $values = implode(',', $values); $query = " INSERT INTO $table ($columns) VALUES $values "; $statement = $connect->prepare($query); if($statement->execute()){ return true; } else{ return false; } } $data = array( array('ad' => "Kemal", 'soyad' => "Sunal"), array('ad' => "Şener", 'soyad' => "Şen"), array('ad' => "Sadri", 'soyad' => "Alışık"), ); insert('oyuncular', $data);