W jaki sposób mogę sobie przebindować mojego inserta, który ma postać:
INSERT INTO `table_name`(`id`, `id_a`, `id_b`) VALUES ('1', '1', '1'), ('2', '2', '2'), ('3', '3', '3')
[0] => 1, [1] =>2, [2] => 3 )
public function addObjectToUser($id_user, $id_flows) { $query = "INSERT INTO `table_name`(`id_a`, `id_b`, `id_c`) VALUES "; foreach($id_b as $value){ $query .= "('".$id_a."', '".$value."', '1'),"; } $result = $this->pdo->exec($query); }
$query = "INSERT INTO `table_name`(`id_a`, `id_b`, `id_c`) VALUES (:id_a, :id_b, 1)"; $result = $this->pdo->prepare($query); $result->bindValue(':id_a', $id_a, PDO::PARAM_INT); $result->bindValue(':id_b', $id_b, PDO::PARAM_INT); $result->execute();