I get this error once I submit my form. As I have not used PDO too much yet, my code may have obvious mistakes. It is intended to update the table with form data and read it. How can I fix it?
Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE edit SET content=':bodyBackgroundColour' WHERE id='bodyBackgroundColour';' at line 2
try
{
$database = new PDO ('mysql:host=localhost;dbname=youdonotneedtoknow;charset=utf8', 'youdonotneedtoknow', 'youdonotneedtoknow');
$database -> setAttribute (PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$database -> setAttribute (PDO::ATTR_EMULATE_PREPARES, false);
//Update
if (!empty ($_POST))
{
$statement = $database -> prepare ("
UPDATE edit SET content=':windowTitle' WHERE id='windowTitle';
UPDATE edit SET content=':bodyBackgroundColour' WHERE id='bodyBackgroundColour';
UPDATE edit SET content=':divisionBackgroundColour' WHERE id='divisionBackgroundColour';
");
$statement -> execute (array (
':windowTitle' => $_POST ['windowTitle'],
':bodyBackgroundColour' => $_POST ['bodyBackgroundColour'],
':divisionBackgroundColour' => $_POST ['divisionBackgroundColour'],
));
}
}
catch (PDOException $exception)
{
die ('Error: ' . $exception -> getMessage () . '<br><br>' . 'Por favor diríjase a "index.php" en este mismo directorio y contacte a su administrador.');
}