作者yangsty (koizumi)
看板PHP
标题[请益] checkbox 送出更新问题
时间Tue Dec 14 16:33:34 2010
各位好，目前遇到的问题是:
这页面目的是让 admission=0 的资料用批次 checkbox 送出後，
经由checkstu.php处理变成 admission=1 ，批次的部分都能正常被选取，
但submit後还是和更新前的资料相同，
debug 和找资料後都无法解决问题，
烦请达人指点解惑，感谢。
以下为程式码
----- admission.php -----------------------------------------
(略)
<form id="form1" name="form1" method="POST" action="checkstu.php">
<table>
<tr>
<td>学号</td>
<td>学生姓名</td>
<td><input type="checkbox" name="checkall" id="checkall" onclick
="selAll();"/><label for="checkall"></label> 批次核准</td>
<td>修课状态</td>
<td></td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset_admission['StuNo']; ?></td>
<td><?php echo $row_Recordset_admission['StuName']; ?></td>
<td><input name="admission[]" type="checkbox" value="1" /> 修课核准</td>
<td></td>
</tr>
<?php } while ($row_Recordset_admission =
mysql_fetch_assoc($Recordset_admission)); ?>
<tr>
<td>
<br />
<input name="classNo" type="hidden" id="classNo" value=<?php echo
$row_Recordset_admission['classNo']; ?>/>
<input name="StuNo" type="hidden" id="StuNo" value=<?php echo
$row_Recordset_admission['StuNo']; ?>/>
<input name="admission" type="hidden" id="admission" value=<?php echo
$row_Recordset_admission['admission']; ?>/>
<input type="submit" name="Submit" value="同意修课"/>
<input type="reset" value="重设表单" />
</td>
</tr>
</table>
</form>
--------------------------------------------------------------
----- checkstu.php -------------------------------------------
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>update</title>
</head>
<body>
<?php
mysql_select_db('vote');
foreach ($_POST['admission'] as $checkasmis){
$checkadmis = implode(",",$_POST['admission']);
$updateSQL = "UPDATE admission SET admission='1' FROM admission WHERE classNo
IN (".$checkadmis.")" ;
mysql_query($updateSQL, $flower) or die ( mysql_error() );
}
header("location:check_list.php");
?>
</body>
</html>
-------------------------------------------------------------
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 218.173.60.32
1F：→ arrack:cache的问题吧? 12/15 00:30
2F：→ lazyhome:$checkadmis = 1,1,1,1..... 而且还做好多次 ... 12/15 12:51
3F：→ lazyhome:建议用print_r($_POST) 来debug 12/15 12:53
4F：→ lazyhome:你会发觉你的前端跟後端有问题 .... 12/15 12:55
5F：→ gaekeamql:input name=admission 还是 要 admission[] 12/25 01:53
6F：→ gaekeamql:POST 会错乱吧!!! 12/25 01:53