20,360
社区成员
发帖
与我相关
我的任务
分享
$(function(){
$("#batch_del").click(function(){
var idStr="";
$("input[name='check']:checked").each(function(){
idStr +=$(this).attr('value')+",";
});
if( idStr !="" ){
if(confirm("确定删除?")){
window.location.href="adm_batch_del.php?adm_id="+idStr; //转到后台处理
}
}else {
alert("请选中一项");
return;
}
});
});
<input type="checkbox" id="check" name="check" value="<?php echo $row['adm_id'] ?>"/>
<input type="button" id="batch_del" value="批量删除" />
foreach($_POST['check'] as $id){
mysql_query("delete from tt where id=$id");
}
if(!$pos === false)
改成
if($pos !== false)
<?php
if($_SERVER['REQUEST_METHOD'] === "POST"){
foreach($_POST as $chk => $post){
$pos = strpos($chk,"check");
if(!$pos === false)
$ids[] = $post;
}
if(count($ids) > 1)
$id = implode(",",$ids);
else
$id = implode($ids);
$sql = "DELETE FROM [table] WHERE id IN (".$id.")";
$result = mysql_query($sql,$conn);
if(!$result)
die("SQL: {$sql} <br>Error: " . mysql_error() );
if(mysql_affected_rows() > 0)
echo "<script>alert('已批量删除');</script>";
else
echo "<script>alert('批量删除失败\nError:".mysql_error()."');</script>";
}
?>
<?php foreach($rows as $row){ ?>
<TD><input type="checkbox" name="check[]" value="<?php echo $row['adm_id'] ?>"/></TD>
<?php } ?>