PHP ?????? ??: ??? ?? ? ?? ??
?? 13.3 "??? ?? ?? ?? ???"? ????. ?? ??? ?? ?? ??? ??? ?? ?? ??? ??? ????.
?? ?? ?? ?? ?? ???? ??
1. ??? ?? delete.php ??? ? ?? ?????. ????? ?????. ?? ID? ? ?????.
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 '刪除失敗';
}
?>
