?? ? ?? ??? ??
?? ?? ?? ?? ?? ???? ??
1. get ????? ?? delete.php ??? ? ?? ?????. ?? ??????.
2. ?? ??? ?? POST? ?? ?? ID? delete.php ???? ?????.
3. ? ? ?? ? ?? ?? ???? ??? ?? ???? ???? ?????.
if (is_array($_POST['id'])) {
$id = join(',', $_POST['id']);
} elseif (is_numeric($_GET['id'])) {
$id = (int) $_GET['id'];
} else {
echo '數(shù)據(jù)不合法';
exit;
}??? SQL ?
??? MySQL ??? ??? ? ?? ?? ??? ? ??? ??????.
????? ????? in ?? ?? ???? ??? ?? ? ????.
join ??? ?? ?? ??? ??? id? 3, 4, 5? ???? ?????. ?? ?? ??? SQL ?? ???? ?? ??? ??? ????.
delete from user where id in(3,4,5,6,8);
?? ?? ?? ?? ??? ??? ????.
delete from user where id in(3)
??? ?? ?? ?? ? ?? ?? ?? ??? ?????.
$sql = "delete from user where id in($id)";
?? ?? ?? ??? ??? ????.
<?php
include 'connection.php';
if (is_array($_POST['id'])) {
$id = join(',', $_POST['id']);
} elseif (is_numeric($_GET['id'])) {
$id = (int) $_GET['id'];
} else {
echo '數(shù)據(jù)不合法';
exit;
}
$sql = "delete from user where id in($id)";
$result = mysqli_query($conn, $sql);
if ($result) {
echo '刪除成功';
} else {
echo '刪除失敗';
}
