[請益] checkbox 送出更新問題

看板PHP作者yangsty (koizumi)時間15年前 (2010/12/14 16:33)推噓0(0推 0噓 6→)

留言6則, 3人參與討論串1/1

各位好，目前遇到的問題是: 這頁面目的是讓 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