删除使用复选框选择的值 [英] Delete values selected using checkbox

问题描述

我想删除使用复选框选择的值.我正在使用此脚本，尽管它没有给出任何错误，但不起作用

I want to delete values that has been selected using checkbox. I am using this script though its not giving any error but its not working

请帮忙.

用于复选框

<input name="checkbox[]" type="checkbox" value="<?=$row['s_id']?>">

用于删除按钮

<input type="submit" name="delete" value="Delete">

查询

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

$count=array();
$count=$_POST['checkbox'];
for($i=0;$i<count($count);$i++){
        $del_id = $checkbox['$i'];
        $sql = "DELETE FROM t_s_list WHERE s_id='$del_id'";
        $result = mysql_query($sql);
}
$NEW="Selected records Deleted";
}
var_dump($_POST['checkbox']);
var_dump($count);

推荐答案

检查删除按钮的名称. $_POST['delete']需要名称为删除".

Check the name of your delete button. $_POST['delete'] needs the name to be 'delete'.

还请检查$del_id = $checkbox['$i'];应该是$del_id = $checkbox[$i];

为了安全起见

$sql = "DELETE FROM t_s_list WHERE s_id='".mysql_real_escape_string($del_id)."'";

这篇关于删除使用复选框选择的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！