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);