Database: 表的結構 CREATE TABLE ( tinyint(1) NOT NULL, varchar(25) NOT NULL, varchar(50) NOT NULL, tinyint(1) NOT NULL, tinyint(1) NOT NULL ) ENGINE=InnoD ...
-- Database: test
-- 表的結構 message
CREATE TABLE `message` (
`id` tinyint(1) NOT NULL,
`name` varchar(25) NOT NULL,
`sex` varchar(50) NOT NULL,
`age` tinyint(1) NOT NULL,
`classid` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;index.php
<!DOCTYPE html>
<head>
<meta charset="UTF-8">
<title>學生信息管理</title>
<script>
function doDel(id) {
if (confirm("確定要刪除麽？")) {
window.location = 'action.php?action=del&id=' + id;
}
}
</script>
</head>
<body>
<center>
<?php
include_once "menu.php";
?>
<h3>瀏覽學生信息</h3>
<table width="600" border="1">
<tr>
<th>ID</th>
<th>姓名</th>
<th>性別</th>
<th>年齡</th>
<th>班級</th>
<th>操作</th>
</tr>
<?php
//1.連接資料庫
try {
$pdo = new PDO("mysql:host=localhost;dbname=test;", "root", "");
} catch (PDOException $e) {
die("資料庫連接失敗" . $e->getMessage());
}
//2.解決中文亂碼問題
$pdo->query("SET NAMES 'UTF8'");
//3.執行sql語句，並實現解析和遍歷
$sql = "SELECT * FROM message ";
foreach ($pdo->query($sql) as $row) {
echo "<tr>";
echo "<td>{$row['id']}</td>";
echo "<td>{$row['name']}</td>";
echo "<td>{$row['sex']}</td>";
echo "<td>{$row['age']}</td>";
echo "<td>{$row['classid']}</td>";
echo "<td>
<a href='javascript:doDel({$row['id']})'>刪除</a>
<a href='edit.php?id=({$row['id']})'>修改</a>
</td>";
echo "</tr>";
}
?>
</table>
</center>
</body>
</html>menu.php
<!DOCTYPE html>
<html lang="en">
<body>
<h2>學生管理系統</h2>
<a href="index.php"> 瀏覽學生</a>
<a href="add.php"> 添加學生</a>
<hr>
</body>
</html>add.php
edit.php
<html>
<head>
<meta charset="UTF-8">
<title>學生信息管理</title>
</head>
<body>
<center>
<?php
include_once "menu.php";
//1.連接資料庫
try {
$pdo = new PDO("mysql:host=localhost;dbname=test;", "root", "");
} catch (PDOException $e) {
die("資料庫連接失敗" . $e->getMessage());
}
//2.防止中文亂碼
$pdo->query("SET NAMES 'UTF8'");
//3.拼接sql語句，取出信息
$sql = "SELECT * FROM message WHERE id =" . $_GET['id'];
$stmt = $pdo->query($sql);//返回預處理對象
if ($stmt->rowCount() > 0) {
$stu = $stmt->fetch(PDO::FETCH_ASSOC);//按照關聯數組進行解析
} else {
die("沒有要修改的數據！");
}
?>
<form id="addstu" name="editstu" method="get" action="action.php">
<input type="hidden" name="action" value="edit">
<input type="hidden" name="id" id="id" value="<?php echo $stu['id']; ?>"/>
<table>
<tr>
<td>姓名</td>
<td><input id="name" name="name" type="text" value="<?php echo $stu['name'] ?>"/></td>
</tr>
<tr>
<td>性別</td>
<td><input type="radio" name="sex" value="男" <?php echo ($stu['sex'] == "男") ? "checked" : "" ?>/> 男
<input type="radio" name="sex" value="女" <?php echo ($stu['sex'] == "女") ? "checked" : "" ?>/> 女
</td>
</tr>
<tr>
<td>年齡</td>
<td><input type="text" name="age" id="age" value="<?php echo $stu['age'] ?>"/></td>
</tr>
<tr>
<td>班級</td>
<td><input id="classid" name="classid" type="text" value="<?php echo $stu['classid'] ?>"/></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" value="修改"/>
<input type="reset" value="重置"/>
</td>
</tr>
</table>
</form>
</center>
</body>
</html>action.php
<?php
//1.連接資料庫
try {
$pdo = new PDO("mysql:host=127.0.0.1;dbname=test;", "root", "");
} catch (PDOException $e) {
die("資料庫連接失敗" . $e->getMessage());
}
//2.防止中文亂碼
$pdo->query("SET NAMES 'UTF8'");
//3.通過action的值進行對應操作
switch ($_GET['action']) {
case 'add':{ //增加操作
$name = $_GET['name'];
$sex = $_GET['sex'];
$age = $_GET['age'];
$classid = $_GET['classid'];
//寫sql語句
$sql = "INSERT INTO `message` (`id`, `name`, `sex`, `age`, `classid`) VALUES (NULL, '{$name}', '{$sex}', '{$age}', '{$classid}');
";
$rw = $pdo->exec($sql);
if ($rw > 0) {
echo "<script> alert('增加成功');
window.location='index.php'; //跳轉到首頁
</script>";
} else {
echo "<script> alert('增加失敗');
window.history.back(); //返回上一頁
</script>";
}
break;
}
case "del": { //1.獲取表單信息
$id = $_GET['id'];
$sql = "DELETE FROM message WHERE id={$id}";
$pdo->exec($sql);
header("Location:index.php");//跳轉到首頁
break;
}
case "edit" :{ //1.獲取表單信息
$id = $_GET['id'];
$name = $_GET['name'];
$sex = $_GET['sex'];
$classid = $_GET['classid'];
$age = $_GET['age'];
$sql = "UPDATE message SET name='{$name}',sex='{$sex}',age='{$age}',classid='{$classid}' WHERE id='{$id}'";
$rw=$pdo->exec($sql);
if($rw>0){
echo "<script>alert('修改成功');window.location='index.php'</script>";
}else{
echo "<script>alert('修改失敗');window.history.back()</script>";
}
break;
}
}
