This question already has an answer here:
- PHP generate dynamic PDO insert 4 answers
- update table using dynamic prepared statements 2 answers
- Insert/update helper function using PDO 11 answers
I am making a really small script, that allows you to make an insert query, based on an array.
So the only thing that you need to do is define the $table and add an array to the function.
public function makeRecord($table, $array){
$array_keys = array_keys($array);
$array_values = array_values($array);
$keys = implode(',', $array_keys);
$values = implode(',', $array_values);
$this->DB->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "INSERT INTO $table ($keys)
VALUES ($values)";
return $this->DB->exec($sql);
}
The next code will generate an SQL query like this.
INSERT INTO Users (UserName,Password) VALUES (daan,welkom01).
But it needs to be
INSERT INTO Users ('UserName', 'Password') VALUES ('daan','welkom01')
What is the best way to fix this :)?
</div>
