<h1>刪除記錄</h1>?
<?php?
??? //連接數據庫的參數?
??? $host = "localhost";?
??? $user = "root";?
??? $pass = "zq19890319";?
??? $db = "phpdev";?
??? //創建mysqli對象?
??? //打開一個數據庫連接?
??? $mysqli = new mysqli($host, $user, $pass, $db);?
??? //檢查連接錯誤?
??? if(mysqli_connect_errno()){?
??????? die("Unable to connect!");?
??? }?
??? //如果記錄ID存在,則執行刪除操作?
??? if(isset($_GET['id'])){?
??????? //構造刪除記錄的SQL?
??????? $query = "DELETE FROM symbols WHEREid = ".$_GET['id'];?
?????????
??????? //執行SQL查詢?
??????? if($mysqli->query($query)){?
??????????? //顯示刪除后影響的記錄數?
??????????? echo $mysqli->affected_rows. "row(s) affected";?
??????? }?
??????? else?
??????? {?
??????????? //如果沒有匹配的記錄,顯示數據庫返回的錯誤信息?
??????????? echo "Error in query : $query. ".$mysqli->error;?
??????? }?
??? }?
??? //構造顯示刪除后的記錄?
??? $query = "SELECT * FROM symbols";?
??? //執行該查詢?
??? if($result=$mysqli->query($query)){?
??????? //顯示返回的記錄集行數?
??????? if($result->num_rows>0){?
??????????? //如果有記錄?
??????????? //顯示記錄集中列的內容?
??????????? echo "<table cellpadding=10 border=1>";?
??????????? while($row=$result->fetch_array()){?
??????????????? echo "<tr>";?
??????????????? echo "<td>".$row[0]."</td>";?
??????????????? echo "<td>".$row[1]."</td>";?
??????????????? echo "<td>".$row[2]."</td>";?
??????????????? echo "<td><a href=".$_SERVER['PHP_SELF']." mce_href=".$_SERVER['PHP_SELF']."?id=".$row[0].">刪除</a></td>";?
??????????????? echo "</tr>";?
??????????? }?
??????? }?
??????? //釋放對象所占用的內存?
??????? $result->close();?
??? }?
??? else?
??? {?
??????? //輸出數據庫錯誤的信息?
??????? echo "Error in query: $query. ".$mysqli->error;?
??? }?
??? //關閉數據庫?
??? $mysqli->close();?
?>