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

我有一些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' .

'

Stage' .

'

Gender' .

'

Frozen' .

'

';

while($row = $result->fetch_assoc()) {

$creature = $row["Creature"];

$id = $row["ID"];

$picture = $row["Picture"];

$stage = $row["Stage"];

echo '' .

'' .

'

' .

'

' .

'

' . $creature . '' .

'

' .

'' . $stage . '' .

'Stage1(Egg)' .

'Stage2' .

'Stage3' .

'Stage4' .

'

' .

'

' .

'' . $row["Gender"] . '' .

'Unspecified' .

'Female' .

'Male' .

'

' .

'

' .

'' . $row["Frozen"] . '' .

'Unspecified' .

'Yes' .

'No' .

'

' .

'

' .

'

' .

'

Notes: ' .

'

' . 'Delete
' . '' .

'

';

}

echo '

';

} else {

echo "
You have no creatures in your wishlist.";

}

}

} catch (mysqli_sql_exception $e) {

throw $e;

}

// Close the connection to the database

$conn->close();

如果你能帮我找到什么是错的，我传递给在foreach()语句的信息：

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

我将永远感激。任何想法都有帮助

我已经尝试了很多东西，其中很多都是在stackoverflow上找到的。我想我可能错过了一些小小的和/或愚蠢的东西。我有另一个页面运行的复选框表单，工作得很好。

谢谢你，祝你有美好的一天！

2016-07-26

TurtleBo

+0

很可能会出现POST阵列的所有表单提交中没有'delete'所以你应该大概在循环之前测试一下 –