html表单复选框隐藏,带复选框的HTML表单元素

最新推荐文章于 2022-09-30 10:23:44 发布

一株绛珠草

最新推荐文章于 2022-09-30 10:23:44 发布

阅读量272

点赞数

文章标签： html表单复选框隐藏

这篇博客讨论了一个PHP开发者遇到的问题，他们在尝试通过HTML表单更新和删除MySQL数据库中的记录时遇到了错误。更新操作成功，但在执行删除操作时出现错误。代码中展示了尝试更新和删除的SQL语句，以及如何从POST请求中获取复选框值。作者请求帮助找出在foreach循环中处理删除操作时的错误，并提到已尝试过多种解决方案但未果。博客内容还包含了表单的HTML结构以及获取当前用户信息的部分。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

我有一些PHP显示如下的HTML表单：然后在按下更新按钮时更新表中的信息。带复选框的HTML表单元素

我的问题是删除选项。任何时候我打的更新按钮，信息更新成功，但我得到了delete语句此错误消息：

下面是代码：// 信息连接到数据库的心愿$ =服务器名“.COM”; $ dbusername =“”; $ password =“”; $ dbname =“”;

try {

// To connect to the database please

$conn = new mysqli($servername, $dbusername, $password, $dbname);

if ($conn->connect_error) {

die('Connect Error (' . $conn->connect_errno . ') '

. $conn->connect_error);

}

echo "Please click here to add creatures to your wishlist.";

if(isset($_POST['submit'])){

$ids = $_POST['ids'];

// Prepare and bind the udpate statement

$sql2 = "UPDATE Wishlists SET Picture = ?, Stage = ?, Gender = ?, Frozen = ?, Notes= ? WHERE ID = ?";

$stmt2 = $conn->prepare($sql2);

$stmt2->bind_param('sssssi', $picture, $stage, $gender, $frozen, $notes, $id);

foreach($ids as $id){

$stagecode = $id . "stage";

$gendercode = $id . "gender";

$frozencode = $id . "frozen";

$notescode = $id . "notes";

$namecode = $id . "creature";

$stage = $_POST[$stagecode];

$Stage = $stage;

$gender = $_POST[$gendercode];

$frozen = $_POST[$frozencode];

$notes = $_POST[$notescode];

$name = $_POST[$namecode];

$sql1 = 'SELECT * FROM Creatures WHERE Name = "' . $name . '"';

$result = mysqli_query($conn, $sql1);

$row = $result->fetch_assoc();

$picture = $row["$stage"];

$stmt2->execute();

}

$theCount = 0;

foreach($_POST['delete'] as $selected){

$sql = "DELETE FROM Wishlists WHERE ID = ?";

$stmt = $conn->prepare($sql);

$stmt->bind_param('i', $selected);

$stmt->execute();

$theCount++;

}

echo "Your wishlist has been updated, and" .$theCount. " creature(s) has/have been removed from your wishlist.
Please click here to return to the edit page.";

} else {

// Get current user's username

$current_user = wp_get_current_user();

$username = $current_user->user_login;

$theDeleteCount = 0;

// Just display the form

$sql = 'SELECT Creature, Picture, Stage, Gender, Frozen, ID FROM Wishlists WHERE Username = "' . $username . '"';

$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {

echo '

' .

Creature' .