php - MYSQL delete where value = multiple POST 值

Question

我试着把这个，

check_box=147&check_box=148&check_box=146 etc..

进入

$delete_selected = $connection->real_escape_string($_POST['check_box'])

$sql = "DELETE FROM categories WHERE cat_id = '$delete_selected'";

但它只会删除第一个 check_box 值。有没有办法遍历所有值？

Answer 1

您需要将您的帖子变量更改为具有 []，即 checkbox[]=。一旦修复，到后端......

考虑到您需要转义每个值，请执行以下操作:

$clean_values = array();
foreach($_POST['check_box'] as $value){
    $clean_values[] = $connection->real_escape_string($value);
}

$sql = 'DELETE FROM categories WHERE cat_id in ('.implode(',',$clean_values).')';

奖励 PHP5.3 答案:

array_walk($_POST['check_box'],function(&item) use($connection){
    $item = $connection->real_escape_string($item);
});
$sql = 'DELETE FROM categories WHERE cat_id in ('.implode(',',$_POST['check_box']).')';