作者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