Er moet een record gewijzigd worden maar ja... dat gebeurt dus niet ;-)
UPDATE assets SET regnumber,device,brand,model,type,snnumber,pnnumber,specification,status WHERE id=4
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'device,brand,model,type,snnumber,pnnumber,specification,status WHERE id=4' at line 1
<?php
if(isset($_POST['update']))
{
try
{
$id = $_POST['id'];
$update_asset = array(
"regnumber" => $_POST['regnumber'],
"device" => $_POST['device'],
"brand" => $_POST['brand'],
"model" => $_POST['model'],
"type" => $_POST['type'],
"snnumber" => $_POST['snnumber'],
"pnnumber" => $_POST['pnnumber'],
"specification" => $_POST['specification'],
"status" => $_POST['status']
);
$sql=sprintf("UPDATE assets SET %s WHERE id=$id",implode(",",array_keys($update_asset)),":".implode(",:",array_keys($update_asset)));
$statement = $conn->prepare($sql);
$statement->execute($update_asset);
}
catch(PDOException $error)
{
echo $sql . "<br>" . $error->getMessage();
}
}
?>
Wellicht ziet iemand hier het gelijk?
