用准备好的语句插入mysql-不起作用


Insert into mysql with prepared statment - not working

我将php-login.net项目文件用于一个小型Web应用程序。我只是试着连接到mdb并插入一些东西,但我一直收到这个奇怪的错误,我无法理解。这个代码缺少什么

$query = $db->prepare('INSERT INTO cours (category, title, description, places, price) VALUES (:category, :title, :description, :places, :price');
$query->execute(array(':category' => $category, ':title' => $title, ':decription' => $decription, ':places' => $places, ':price' => $price));

您在description中有一个打字错误(原来是decription),在:price 之后也缺少一个)

$query = $db->prepare('INSERT INTO cours (category, title, description, places, price) VALUES (:category, :title, :description, :places, :price)');
$query->execute(array(':category' => $category, ':title' => $title, ':description' => $description, ':places' => $places, ':price' => $price));

你现在可以试着告诉我们它是否有效吗?