deleteData.php 頁面
<html>
<head>
</head>
<body>
<form name="frm" action="processDeleteData.php" method="post">
<table border="1" align="center" cellspacing="0" cellpadding="0">
<caption>學生一覽表</caption>
<th>選項</th>
<th>學號</th>
<th>姓名</th>
<th>年齡</th>
<th>性別</th>
<th>地址</th>
<?php
$link=mysql_connect("localhost","root","root");
mysql_select_db("rorely");
$exec="select * from test";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result)){
$id=$rs->id;
$name=$rs->name;
$age=$rs->age;
$sex=$rs->sex;
$address=$rs->address;
?>
<tr align="center">
<td><input type="radio" name="del" value=<?php echo $id ?> /></td>
<td><?php echo $id ?></td>
<td><?php echo $name ?></td>
<td><?php echo $age ?></td>
<td><?php echo $sex ?></td>
<td><?php echo $address ?></td>
</tr>
<?php
}
mysql_close();
?>
</table>
<center><input type="submit" value="刪除" /></center>
</form>
</body>
</html>
processDeleteData.php處理刪除頁面
<?php
$link=mysql_connect("localhost","root","root");
mysql_select_db("rorely");
$id=$_POST['del'];
$exec="delete from test where id=$id";
$result=mysql_query($exec);
if((mysql_affected_rows()==0)||(mysql_affected_rows()==-1))
echo"沒有找到記錄，或者刪除時產生錯誤！";
else echo"學生已刪除！";
mysql_close();
?>
<a href="deleteData.php">返回刪除頁面</a>
posted on 2009-07-01 15:30
期待明天 閱讀(5631)
評論(5) 編輯 收藏 所屬分類:
PHP