1.查詢：
資料的顯示，這裡就可以嵌入php來進行資料的輸出
<!DOCTYPE html><html><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>無標題文檔</title></head><body><table width="100%" border="1" cellpadding="0" cellspacing="0"> <tr> <td>代號</td> <td>名稱</td> <td>性別</td> <td>生日</td> <td>班級</td> <td>操作</td> </tr><?php$db = new MySQLi("localhost","root","12345678","heiheihei");//串連資料庫$sql = "select * from student ";//寫sql語句$r = $db->query($sql);//執行sql語句返回給rif($r)//條件{ while ($attr = $r->fetch_row()) { $ssex = ""; if($attr[2]) { $ssex = "男"; } else { $ssex = "女"; } echo " <tr> <td>{$attr[0]}</td> <td>{$attr[1]}</td> <td>{$ssex}</td> <td>{$attr[3]}</td> <td>{$attr[4]}</td>//添加一個單擊事件，防止不小心刪掉<td><a onclick=\"return confirm('確定要刪除嗎？？？')" href='shanchu.php?sno={$attr[0]}'>刪除</a> <a href='xiugai.php?sno={$attr[0]}'>修改</a> </td> </tr>"; } } ?> </table><a href="tianjia.php" rel="external nofollow" >添加頁面</a></body></html>
2.刪除的處理頁面
刪除時是連結到刪除處理頁面的，所以還要寫一個刪除處理頁面：
<?php$aaa = $_GET ["sno"]; //刪除方式使用的get，照舊$db = new mysqli("localhost","root","12345678","heiheihei");//串連...$sql = "delete from student WHERE sno='{$aaa}'";//寫sql語句，sno主鍵if($db->query($sql)) //執行sql語句{ header("location:text.php");//刪完回去表頁面}else{ echo "刪除失敗";}?>
來張：
3.添加資料：
點擊即可進入添加頁面
添加頁面：
<body><h1>添加</h1><form action="add.php" method="post" > <p>代號:<input type="text" name="sno"/></p> <p>名字:<input type="text" name="sname"/></p> <p>性別: <input type="radio" value="1" name="sex" />男 <input type="radio" value="0" name="sex"/>女</p> <p>日期:<input type="text" name="sbirthday"/></p>//建立表時性別是用的1或2來表示的，要是進行修改不知道1或2代表了什麼，所以就要進行處理，處理成使用者能夠明白的男和女 <p>班級: <select name="class"> <?php $db= new MYSQLi("localhost","root","12345678","heiheihei");//串連... $sql = " select * from class ";//寫sql... $r = $db->query($sql);//執行...返回... while($arr = $r->fetch_row()) { echo "<option value='{$arr[0]}'>{$arr[1]}</option>"; //添上以後回表頁面 } ?> </select> </p> <p><input type="submit" value="添加"/></p></form></body>
添加也需要一個處理頁面來判斷添加：
<?php$sno = $_POST["sno"];//$_POST 變數用於收集來自 method="post" 的表單中的值。$sname = $_POST["sname"];$ssex = $_POST["ssex"];$sbirthday = $_POST["sbirthday"];$class = $_POST["class"];$db = new mysqli("localhost","root","12345678","heiheihei");$sql = "insert into student VALUES ('{$sno}','{$sname}','{$ssex}','{$sbirthday}','{$class}')";//向資料庫中添加寫的資料 if($db->query($sql)){ header("location:text.php"); //header() 函數向用戶端發送原始的 HTTP 前序。}else { echo "添加失敗";}?>
：
4.修改資料：主鍵不可修改！！
<html xmlns="http://www.w3.org/1999/xhtml"><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>無標題文檔</title></head><body><h1>修改</h1><?php$sno = $_GET{"sno"};$db = new mysqli("localhost","root","12345678","heiheihei");$sql = "select * from student WHERE sno='{$sno}'";$r = $db->query($sql);$arr = $r->fetch_row();?> <form action="update.php" method="post"> <p>代號：<input readonly="readonly" type="text" name="sno" value="<?phpecho $arr[0];?>"/></p>//readonly只可讀 <p>名稱：<input type="text" name="sname" value="<?php echo $arr[1]; ?>"/></p> <p>性別： <input type="radio" name="ssex" value="1" <?php echo $arr[2]?"checked='checked'":""; ?>/>男 <!-- 三元運算子，如果性別=ture，預設值就在男上面，否則空--> <input type="radio" name="ssex" value="0" <?php echo $arr[2]?"":"checked='checked'"; ?>/>女 </p> <p>日期：<input type="text" name="sbirthday" value="<?php echo $arr[3]; ?>"/></p> <p>班級：<select name="class">//value取預設值 <?php $sclass = "select * from class"; $rclass = $db->query($sclass); while($attr = $rclass->fetch_row()) //取到的班級資訊 { //判斷將要輸出的班級是不是和該人員的是否相同 if($arr[4]==$attr[0])//arr是班級名，attr是班級的代號，倆表 { echo "<option value = '{$attr[0]}' selected='selected'>{$attr[1]}</option>"; } else{ echo "<option value = '{$attr[0]}'>{$attr[1]}</option>"; } } ?> </select></p> <p><input type="submit" value="修改完畢"/></p></form></body></html>
]
修改的處理頁面：
<?php$sno = $_POST["sno"];$sname = $_POST["sname"];$ssex = $_POST["ssex"];$sbirthday = $_POST["sbirthday"];$class = $_POST["class"];$db = new mysqli("localhost","root","12345678","heiheihei");$sql = "update student set sname='{$sname}',ssex='{$ssex}',sbirthday='{$sbirthday}',class='{$class}' WHERE sno='{$sno}'";//看一下是不是傳遞過來的sno值；if($db->query($sql)){ header("location:text.php");}else{ echo "修改失敗";}?>
修改的：
以上就是本文的全部內容，希望對大家的學習有所協助。
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
