[請益] 如圖刪除中間選項，結果卻都刪到最後一項 !!

看板PHP作者e04313224200 (陽光!音樂!海!)時間14年前 (2011/06/12 14:59)推噓2(2推 0噓 4→)

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

畫面執行第1個畫面 http://ppt.cc/2kQC 畫面執行第2個畫面 http://ppt.cc/iQ9U 程式碼: <?php include_once('db_conn.php'); include_once('db_func.php'); header('Content-Type: text/html; charset=utf-8'); if ($action == 'add') { $SQLStr = "INSERT INTO class (c_name) VALUES('$c_name')"; db_query($SQLStr); } else if ($action == 'del') { $SQLStr = "SELECT * FROM product WHERE c_id = $c_id"; $res = db_query($SQLStr); if(db_num_rows($res) == 0) { $SQLStr = "DELETE FROM class WHERE c_id= $c_id"; db_query($SQLStr); } else echo '<script>alert("此類別仍在使用中, 無法刪除！");</script>'; } $SQLStr = "SELECT * FROM class"; $res = db_query($SQLStr); ?> <form name="form1" method="post" action="class_add.php?action=add"> <table width="750" border="1" cellpadding="0" cellspacing="0" align="center" bordercolor="#0000FF"> <tr> <td bgcolor="#FFFFCC"> <table width="400" border="0" align="center"> <tr> <td width="60%" bgcolor="#9933FF" align="center"> <font color="#FFFFFF">新增類別</font> </td> <td width="25%" bgcolor="#9966FF"> </td> <td width="10%" bgcolor="#9999FF"> </td> <td width="3%" bgcolor="#9999FF"> </td> <td width="2%" bgcolor="#99CCFF"> </td> </tr> </table> </td> </tr> <tr><td> <table width="750" border="1" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td bgcolor="#CCCCCC" align="center">現有類別</td> </tr> <?php $num = db_num_rows($res); for ($i=0;$i<$num;$i++) { $row = db_fetch_array($res); echo "<tr><td align='center'>" . htmlspecialchars($row['c_name']); echo '<span style="font-size:smaller"> (<a href="#" ' . 'onClick="delete_class(' . $row['c_id'] . ",'" . htmlspecialchars($row['c_name']) . "')\">刪除</a>)</td></tr>"; } ?> <script> function delete_class(c_id,c_name) { if(confirm("確定刪除" + c_name + "類別?")) document.URL = "<?php echo $_SERVER['PHP_SELF'] . '?action=del&c_id=' . $row['c_id']; ?>"; } </script> <tr> <td bgcolor="#99CCFF" align="center">新增類別： <input type="text" name="c_name"> <input type="submit" name="Submit" value="新增"> </td> </tr> </table> </td></tr> </table> </form> 很長一篇~謝謝你有奈耐心看完 !! -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 140.128.72.6