php - 简单的更新查询不起作用？

Question

在编写了一大堆更复杂且运行良好的代码之后，这就是给我带来问题的代码。

简单的表格

<form action="res/scripts/editsubscriber.php" method="post">
<label for="name">Name: </label>
<input name="name" type="text" value="<?php echo $name; ?>">
...etc, etc...
</form>

提交到此脚本:

  include('appvars.php');  
  if(isset($_POST['submit'])){
$id = $_POST['id'];
$name = $_POST['name'];
$email = $_POST['email'];
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];
$date =  $_POST['date'];
$time = substr($date, 0, (stripos($date, " ")+1));
$time = str_replace($time, '', $date);
$created = $year.'-'.$month.'-'.$day.' '.$time;
$query = "UPDATE newslettersubscribers SET name = '$name', email = '$email', created = '$created' WHERE id = $id)";
mysqli_query($dbc, $query);
 }

它发布了，我已经回显了所有变量，它们改变得很好，但它仍然不会更新数据库。有人请告诉我我错过了什么......

Answer 1

• 删除更新语句中多余的 )

• 阅读文章以避免SQL注入(inject)

  Best way to prevent SQL injection in PHP?