php - 简单的 SQL 记录删除 - 不起作用

Question

我想做的只是让简单的文本形式从 sql 数据库中删除记录。
它返回记录已被删除，但它从未真正删除记录。

变量remove.php：

html表单图片：

删除.php：

删除.php：

require('variablesremove.php');

$user = "#"; 
$password = "#"; 
$host = "localhost"; 
$database= "#";

$connection= mysqli_connect ($host, $user, $password);
if (!$connection) {
    die ('Could not connect:' . mysql_error());
}

mysqli_select_db($database, $connection);

$deleterow = "DELETE FROM licenses WHERE serialNumber='$serialNumber'";

if($deleterow !== FALSE) {
    echo("The row has been deleted.");
} else {
    echo("The row has not been deleted.");
}

标签： phpsql

Answer 1

您需要使用mysqli_query()来执行您的删除命令。

$deleteRow = "DELETE FROM licenses WHERE serialNumber='$id'";

if (mysqli_query($connection, $deleteRow)) {
  echo "Record deleted successfully";
} else {
  echo "Error deleting record: " . mysqli_error($conn);
}

mysqli_close($conn);