List页面显示学生信息
<?php
//包含连接数据库的公共文件[一次]先包含再运行
require_once ("conn.php") ;
//执行查询的SQL语句
$sql = "SELECT id,name,sex,age,edu,salary,bonus,city FROM student " ;
$result = mysqli_query($link,$sql) ;
//获取所有行数据
$arrs = mysqli_fetch_all($result,MYSQLI_ASSOC) ;
//获取学生人数
$records = mysqli_num_rows($result) ;
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>学生信息管理中心</title>
<script type="text/javascript">
//定义一个js的提示函数
function confirmdel(id) {
//询问是否要删除?
if (window.confirm("您真的要删除吗?")){
//如果单击确定按钮,跳转到delete.php页面
location.href = "delete.php?id="+id ;
}
}
</script>
</head>
<body>
<div style="text-align: center;padding-bottom: 10px">
<h2>学生信息管理中心</h2>
<a href="add.php">添加学生</a>
共有<font color="red"><?php echo $records?></font>个学生信息
</div>
<table width="600" border="1" align="center" rules="all" cellpadding="5">
<tr bgcolor="#ccc">
<th>编号</th>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
<th>学历</th>
<th>工资</th>
<th>奖金</th>
<th>籍贯</th>
<th>操作选项</th>
</tr>
<?php
//循环二维数组
foreach ($arrs as $arr){
?>
<tr align="center">
<td><?php echo $arr['id'] ?></td>
<td><?php echo $arr['name'] ?></td>
<td><?php echo $arr['sex'] ?></td>
<td><?php echo $arr['age'] ?></td>
<td><?php echo $arr['edu'] ?></td>
<td><?php echo $arr['salary'] ?></td>
<td><?php echo $arr['bonus'] ?></td>
<td><?php echo $arr['city'] ?></td>
<td>
<a href="edit.php?id=<?php echo $arr['id']?>">修改</a>|
<a href="#" onclick="confirmdel(<?php echo $arr['id'] ?>)">删除</a>
</td>
</tr>
<?php } ?>
</table>
</body>
</html>
conn数据库连接公共页面
<?php
//1.配置数据库信息
$db_host = "localhost" ;
$db_user = "root" ;
$db_pass = "123456" ;
$db_name = "demo" ;
$charset = "utf8" ;
//2.php连接sql服务器
$link = @mysqli_connect($db_host , $db_user , $db_pass) ;
//判断是否连接上
if ($link==false) {
echo "系统错误信息:" . mysqli_connect_error();//返回错误信息
die("连接失败!!!");//终止下面的程序
}
//3.选择当前数据库
if (!mysqli_select_db($link,$db_name)){
echo "<h5 style='color: red'>选择数据库失败!!!</h5>" ;
die();
}
//4.设置数据库返回数据字符集
mysqli_set_charset($link,"utf8") ;
add增加学生信息页面
<?php
//包含连接数据库的公共代码、
require_once ("conn.php") ;
//判断表单是否提交(防止黑客攻击)
if (isset($_POST['token'])&&$_POST['token']=="add"){
//获取表单提交数据
$name = $_POST['name'] ;
$sex = $_POST['sex'];
$age = $_POST['age'];
$edu = $_POST['edu'];
$salary = $_POST['salary'];
$bonus = $_POST['bonus'];
$city = $_POST['city'];
//构建插入的SQL语句
$sql = "INSERT INTO student VALUES(null,'$name','$sex',$age,'$edu',$salary,$bonus,'$city')";
//判断SQL语句是否执行成功
if(mysqli_query($link,$sql))
{
echo "<h2>记录添加成功!</h2>";
//告诉浏览器执行代码:等待3秒,并跳转到list.php文件
header("refresh:3;url=./list.php");
die(); //中止程序向下运行
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>学生信息管理中心</title>
</head>
<body>
<div style="text-align: center;padding-bottom: 10px">
<h2>学生信息管理中心---添加学生信息</h2>
<a href="list.php">返回</a>
</div>
<form method="post" action="">
<table width="400" bordercolor="#ccc" border="1" rules="all" align="center"cellpadding="5">
<tr>
<td width="80" align="right">姓名:</td>
<td><input type="text" name="name" ></td>
</tr>
<tr>
<td width="80" align="right">性别:</td>
<td>
<input type="radio" name="sex" value="男" checked>男
<input type="radio" name="sex" value="女">女
</td>
</tr>
<tr>
<td width="80" align="right">年龄:</td>
<td><input type="text" name="age"></td>
</tr>
<tr>
<td width="80" align="right">学历:</td>
<td>
<select name="edu">
<option value="1">初中</option>
<option value="2">高中</option>
<option value="3" selected="selected">大专</option>
<option value="4">本科</option>
<option value="5">研究生</option>
</select>
</td>
</tr>
<tr>
<td width="80" align="right">工资:</td>
<td><input type="text" name="salary"></td>
</tr>
<tr>
<td width="80" align="right">奖金:</td>
<td><input type="text" name="bonus"></td>
</tr>
<tr>
<td width="80" align="right">籍贯:</td>
<td><input type="text" name="city"></td>
</tr>
<tr>
<td> </td>
<td>
<input type="submit" value="提交">
<input type="hidden" name="token" value="add">
<input type="reset" value="重置">
</td>
</tr>
</table>
</form>
</body>
</html>
delete删除学生信息页面
<?php
//包含连接数据库的公共代码、
require_once ("conn.php") ;
//获取地址栏传递的ID
$id = $_GET['id'] ;
//构建删除的SQL语句
$sql = "DELETE FROM student WHERE id = $id ;" ;
//执行SQL语句
if (mysqli_query($link,$sql)){
echo "<h2>id = {$id} 的记录删除成功!</h2>" ;
//告诉浏览器执行代码,等待3秒并跳转到list.php页面
header("refresh:3;url=list.php");
die();//中止程序向下运行
}else{
echo "<h2>id = {$id} 的记录删除失败!</h2>" ;
//告诉浏览器执行代码,等待3秒并跳转到list.php页面
header("refresh:3;url=list.php");
die();//中止程序向下运行
}
edit修改学生信息页面
<?php
//包含连接数据库的公共文件
require_once ("conn.php") ;
//判断表单是否提交
if (isset($_POST['ac']) && $_POST['ac']=='edit'){
//获取表单提交值
$id = $_POST['id'];
$name = $_POST['name'];
$sex = $_POST['sex'];
$age = $_POST['age'];
$edu = $_POST['edu'];
$salary = $_POST['salary'];
$bonus = $_POST['bonus'];
$city = $_POST['city'];
//构建更新的SQL语句
$sql = "UPDATE student SET name='$name',sex='$sex',age=$age,edu='$edu',
salary=$salary,bonus=$bonus,city='$city' WHERE id={$id}";
//判断记录是否更新成功
if (mysqli_query($link,$sql)){
echo "<h2>id={$id}的记录更新成功!</h2>";
header("refresh:3;url=./list.php");
die(); //中止程序向下运行
}
}else{
//获取地址栏传递的id
$id = $_GET['id'];
//构建查询的SQL语句
$sql = "SELECT * FROM student WHERE id=$id";
//执行SQL语句,并返回结果集
$result = mysqli_query($link,$sql) ;
$arr = mysqli_fetch_array($result,MYSQLI_ASSOC) ;
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>学生信息管理中心</title>
</head>
<body>
<div style="text-align:center;margin-bottom:10px;">
<h2>修改学生信息</h2>
<a href="javascript:history.go(-1)">返回首页</a>
</div>
<form method="post" action="">
<table width='400' border="1" bordercolor="#ccc" align="center" rules="all" cellpadding="5">
<tr>
<td width="80" align="right">姓名:</td>
<td><input type="text" name="name" value="<?php echo $arr['name']?>"></td>
</tr>
<tr>
<td width="80" align="right">性别:</td>
<td>
<input type="radio" name="sex" value="1"<?php if($arr['sex']=='男') echo ' checked';?>>男
<input type="radio" name="sex" value="2"<?php if($arr['sex']=='女') echo ' checked';?>>女
</td>
</tr>
<tr>
<td width="80" align="right">年龄:</td>
<td><input type="text" name="age" value="<?php echo $arr['age']?>" size="2" maxlength="2"></td>
</tr>
<tr>
<td width="80" align="right">学历:</td>
<td>
<select name="edu">
<option value="1"<?php if($arr['edu']=='初中') echo ' selected';?>>初中</option>
<option value="2"<?php if($arr['edu']=='高中') echo ' selected';?>>高中</option>
<option value="3"<?php if($arr['edu']=='大专') echo ' selected';?>>大专</option>
<option value="4"<?php if($arr['edu']=='大本') echo ' selected';?>>大本</option>
<option value="5"<?php if($arr['edu']=='研究生') echo ' selected';?>>研究生</option>
</select>
</td>
</tr>
<tr>
<td width="80" align="right">工资:</td>
<td><input type="text" name="salary" value="<?php echo $arr['salary']?>"></td>
</tr>
<tr>
<td width="80" align="right">奖金:</td>
<td><input type="text" name="bonus" value="<?php echo $arr['bonus']?>"></td>
</tr>
<tr>
<td width="80" align="right">籍贯:</td>
<td><input type="text" name="city" value="<?php echo $arr['city']?>"></td>
</tr>
<tr>
<td></td>
<td>
<input type="submit" value="提交">
<input type="hidden" name="ac" value="edit">
<input type="hidden" name="id" value="<?php echo $id?>">
<input type="reset" value="重置">
</td>
</tr>
</table>
</form>
</body>
</html>
SQL数据库语句
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(12) CHARACTER SET utf8 COLLATE utf8_croatian_ci NULL DEFAULT NULL COMMENT '名字',
`sex` char(5) CHARACTER SET utf8 COLLATE utf8_croatian_ci NULL DEFAULT NULL COMMENT '性别',
`age` int(4) NULL DEFAULT NULL COMMENT '年龄',
`edu` varchar(10) CHARACTER SET utf8 COLLATE utf8_croatian_ci NULL DEFAULT NULL COMMENT '学历',
`salary` decimal(10, 2) NULL DEFAULT NULL COMMENT '工资',
`bonus` decimal(10, 2) NULL DEFAULT NULL COMMENT '奖金',
`city` varchar(32) CHARACTER SET utf8 COLLATE utf8_croatian_ci NULL DEFAULT NULL COMMENT '籍贯',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_croatian_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;