作者e04313224200 (阳光!音乐!海!)
看板PHP
标题[请益] 如图删除中间选项，结果却都删到最後一项 !!
时间Sun Jun 12 14:59:43 2011
画面执行第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
1F：推 dylan29341:<script>的部分 '?action=del&c_id=' . $row['c_id']; 06/12 15:51
2F：→ dylan29341:你可以检视该页的source code 就会明白了 06/12 15:51
3F：→ e04313224200:所以我该怎麽改~请求!! 谢谢 !! 06/12 16:22
4F：推 dylan29341:你现在抓的是最後一个id呀 06/12 16:33
5F：→ dylan29341:也就是说你不管按哪个按钮 转向的页面都是删最後一笔 06/12 16:33
6F：→ yanli2:期末作业? 06/12 21:37