PhP 在提交时从数据库中删除行

Question

这个问题已经有答案了:

Delete query not working in mysql (4 个回答)

What to do with mysqli problems? Errors like mysqli_fetch_array(): Argument #1 must be of type mysqli_result and such (1 个回答)

Reference - What does this error mean in PHP? (38 个回答)

已关闭 5 年前。

单击提交输入后，我试图从数据库中删除一行数据。

if (isset($_POST['submit'])) {
   // sql to delete a record
$query = "DELETE * FROM wishList
     WHERE userID_FK = {$_SESSION['user_id']}
     AND itemName = {$row['itemName']}";

$result = mysqli_query($dbc, $query);

if($result)
{
    echo 'Data Deleted';
}else{
    echo 'Data Not Deleted';
}

}

Answer 1

请从删除查询中删除 *。如果您遇到任何其他问题，请告诉我。

$query = "DELETE  FROM wishList
     WHERE userID_FK = {$_SESSION['user_id']}
     AND itemName = {$row['itemName']}";