Developement/PHP
체크박스로 체크된 목록의 db값을 삭제하는 방법
highheat
2006. 6. 27. 18:29
a.htm
<form name="frm" method="post" action="b.php">
<input type="checkbox" name="ck[]" value="1">
<input type="checkbox" name="ck[]" value="2">
<input type="checkbox" name="ck[]" value="3">
</form>
서브밋 하면 b페이지로 날라오겠져.
b.php
$ck = &$_POST['ck'];
$cnt = count($ck);
$subqry='';
for($i=0;$i<$cnt;$i++) {
if($subqry) $subqry .= ',';
$subqry .= $ck[$i];
}
if($subqry) {
mysql_query('delete from table where col in ('.$subqry.')');
}
<form name="frm" method="post" action="b.php">
<input type="checkbox" name="ck[]" value="1">
<input type="checkbox" name="ck[]" value="2">
<input type="checkbox" name="ck[]" value="3">
</form>
서브밋 하면 b페이지로 날라오겠져.
b.php
$ck = &$_POST['ck'];
$cnt = count($ck);
$subqry='';
for($i=0;$i<$cnt;$i++) {
if($subqry) $subqry .= ',';
$subqry .= $ck[$i];
}
if($subqry) {
mysql_query('delete from table where col in ('.$subqry.')');
}