这是数据库循环取出来的ID
<TD><input type="checkbox" name="check" value="<?php echo $row['adm_id'] ?>"/></TD>
这是几个button
<TR><TD align="right" height="25">
<input type="button" id="batch_del" value="批量删除" />
<input type="button" id="checkedAll" value="全选" />
<input type="button" id="checkedRev" value="反转" /></TD></TR>
这是全选与反转代码
$(function(){
$("#checkedAll").click(function(){
$("[name=check]:checkbox").attr('checked',true);
});
$("#checkedRev").click(function(){
$("[name=check]:checkbox").each(function(){
this.checked=!this.checked;
});
});
});
但怎样实现批量删除？？求高手指教！！ 先谢啦！！
------解决方案--------------------
<input type="checkbox" name="check[]" value="<?php echo $row['adm_id'] ?>"/></TD>
------解决方案--------------------
- PHP code
<?phpif($_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 } ?>