这是我所有的PHP代码。
define('DB_SERVER', "mysql.com");
define('DB_USER', "");
define('DB_PASSWORD', "!");
define('DB_DATABASE', "");
$conn = mysqli_connect(DB_SERVER, DB_USER, DB_PASSWORD, DB_DATABASE);
$query = "SELECT * FROM `accountsToDo` ORDER BY id LIMIT 1";
$result = $conn->query($query);
while($row = $result->fetch_assoc()) {
$percentageOfMessages =($row["percentageOfMessages"]);
$RemoveDeletedAccounts =($row["RemoveDeletedAccounts"]);
$blacklistUsernames =($row["blacklistUsernames"]);
$userEmail =($row["userEmail"]);
$CUse =($row["CUse"]);
$CPa =($row["CPa"]);
}
$conn->close();
?>
<ul>
<li id="percentageOfMessages"><?php echo $percentageOfMessages; ?></li>
<li id="RemoveDeletedAccounts"><?php echo $RemoveDeletedAccounts; ?></li>
<li id="blacklistUsernames"><?php echo $blacklistUsernames; ?></li>
<li id="userEmail"><?php echo $userEmail; ?></li>
<li id="CUse"><?php echo $CUse; ?></li>
<li id="CPa"><?php echo $CPa; ?></li>
</ul>
我的问题是，在我得到那一行的值之后。我想继续删除那一行。
$CUse =($row["CUse"]);
$CPa =($row["CPa"]);
}
$conn = mysqli_connect(DB_SERVER, DB_USER, DB_PASSWORD, DB_DATABASE);
$query = "DELETE FROM `accountsToDo` WHERE 1 ORDER BY id LIMIT 1";
$conn->query($query);
$conn->close();
?>
但当我把这个放在那里时，我会得到一个错误，说。。。。
调用空上的成员函数close（）
如何修复此错误？
这就是它应该是的：
当你删除某些内容时也是如此。请确保定义要删除的内容，否则将不删除任何内容/全部内容！！请参阅下面的调整。
define('DB_SERVER', "mysql.com");
define('DB_USER', "");
define('DB_PASSWORD', "!");
define('DB_DATABASE', "");
$conn = mysqli_connect(DB_SERVER, DB_USER, DB_PASSWORD, DB_DATABASE);
$query = "SELECT * FROM `accountsToDo` ORDER BY id LIMIT 1";
$result = $conn->query($query);
$row = $result->fetch_assoc();
?>
<ul>
<li id="percentageOfMessages"><?php echo $row["percentageOfMessages"]; ?></li>
<li id="RemoveDeletedAccounts"><?php echo $row["RemoveDeletedAccounts"]; ?></li>
<li id="blacklistUsernames"><?php echo $row["blacklistUsernames"]; ?></li>
<li id="userEmail"><?php echo $row["userEmail"]; ?></li>
<li id="CUse"><?php echo $row["CUse"]; ?></li>
<li id="CPa"><?php echo $row["CPa"]; ?></li>
</ul>
$query = "DELETE FROM `accountsToDo` WHERE `id` = {$row['id']}";
$conn->query($query);
$conn->close();
?>