综合实验
实验内容
内蒙古大学电子信息工程学院主页师资队伍管理模块开发
(1)新建数据表（名字自定），包含如下字段，①姓名，②出生年月，③电话，④ 电子邮箱，⑤职称，⑥研究方向，用于存放教师信息。
(2)在内蒙古大学电子信息工程学院主页的基础之上，将菜单栏的“师资队伍”设计为超链接，点击“师资队伍”，进入教师介绍页面，从数据表中读取教师信息，介绍内容包括①姓名；②出生年月；③电话；④电子邮箱；⑤职称；⑥研究方向。（显示格式不限，要求尽量美观）
(3)在教师介绍页面任意位置（自定）添加“教师管理”超链接，点击“教师管理”进入教师管理页面。
(4)在教师管理页面，使用iframe框架，框架中包含两部分内容①添加教师信息；②教师信息管理。在“①添加教师信息”页面中设计表单，添加1中的教师信息，在“②教师信息管理”中显示所有数据表中的教师信息，显示格式如下表所示：
| 姓名 | 电话 | 修改 | 删除 |
| 张三 | 130xxxx0000 | 修改(超链接) | 删除(超链接) |
(6)在表1中，点击“删除”，则从数据表中删除相应的教师信息。
实验过程
内蒙古大学电子信息工程学院主页师资队伍管理模块开发
源代码
mysql_conn.php
<?php
//定义数据库的地址，用户名，密码，数据库名常量
define("sql_servername","localhost");
define("sql_username","数据库用户名");
define("sql_password","数据库密码");
define("sql_dbname","数据库名");
$sql_table="teacher";
//连接数据库函数
function sql_conn()
{
// 创建连接
$conn = mysqli_connect(sql_servername, sql_username, sql_password, sql_dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "连接成功";
}
//数据库数据查询函数
function sql_search_all()
{
$conn = mysqli_connect(sql_servername, sql_username, sql_password, sql_dbname);
// Check connection
if (!$conn) {
die("连接失败: " . mysqli_connect_error());
}
global $sql_table;
$sql = "SELECT * FROM $sql_table";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0)
{
// 输出数据
while($row = mysqli_fetch_assoc($result))
{
echo "<tr align='center'>
<td>".$row["name"]."</td>
<td>".$row["birth"]."</td>
<td>".$row["phone_number"]."</td>
<td>".$row["email"]."</td>
<td>".$row["competent"]."</td>
<td>".$row["direction"]."</td>
</tr>";
}
}
else
{
echo "0 结果";
}
//断开数据库连接
mysqli_close($conn);
}
//数据库更新数据查询函数
function sql_search_update()
{
$conn = mysqli_connect(sql_servername, sql_username, sql_password, sql_dbname);
// Check connection
if (!$conn) {
die("连接失败: " . mysqli_connect_error());
}
global $sql_table;
$sql = "SELECT name,phone_number FROM $sql_table";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0)
{
// 输出数据
while($row = mysqli_fetch_assoc($result))
{
echo "<tr>
<td>".$row["name"]."</td>
<td>".$row["phone_number"]."</td>
<td><a href='teacher_update.php?name=".$row["name"]."&phone_number=".$row["phone_number"]."'><button>更新</button></a></td>
<td><a href='teacher_delete.php?name=".$row["name"]."&phone_number=".$row["phone_number"]."'><button>删除</button></a></td>
</tr>";
}
}
else
{
echo "0 结果";
}
mysqli_close($conn);
}
//数据库数据插入函数
function sql_insert($name,$value)
{
global $sql_table;
$conn = mysqli_connect(sql_servername, sql_username, sql_password, sql_dbname);
// Check connection
if (!$conn) {
die("连接失败: " . mysqli_connect_error());
}
$sql = "INSERT INTO $sql_table ($name)
VALUES ($value)";
if (mysqli_query($conn, $sql)) {
echo "新记录插入成功";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
}
//数据库数据删除函数
function sql_delete($name)
{
global $sql_table;
$conn = mysqli_connect(sql_servername, sql_username, sql_password, sql_dbname);
// Check connection
if (!$conn) {
die("连接失败: " . mysqli_connect_error());
}
mysqli_query($conn,"DELETE FROM $sql_table WHERE $name");
mysqli_close($conn);
}
//数据库数据更新函数
function sql_update($name,$value)
{
global $sql_table;
$conn = mysqli_connect(sql_servername, sql_username, sql_password, sql_dbname);
// Check connection
if (!$conn) {
die("连接失败: " . mysqli_connect_error());
}
mysqli_query($conn,"UPDATE $sql_table SET $value
WHERE $name");
mysqli_close($conn);
return 0;
}
?>teacher_main.php
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="UTF-8">
<title>师资队伍</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div class="tea_out">
<div class="tea">
<div class="butt">
</div>
</div>
<div class="tea">
<h1>
教师信息<br>
<a href="teacher_admin.html"><button>教师管理</button></a>
<a href="index.html"><button>返回首页</button></a>
</h1>
<table border="1" align="center" width="90%">
<tr align="center">
<td width="10%">姓名</td>
<td width="15%">出生年月</td>
<td width="15%">手机号码</td>
<td width="20%">Email</td>
<td width="10%">职称</td>
<td width="30%">研究方向</td>
</tr>
<?php
include 'mysql_conn.php';
sql_search_all();
?>
</table>
</div>
</div>
</body>
</html>teacher_admin.html
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="UTF-8">
<title>教师管理</title>
</head>
<body>
<div>
<div align="center">
<h1>教师管理<br><a href="index.html"><button>返回首页</button></a></h1>
</div>
<div align="center" style="margin:0 auto;">
<div style="width:900px;height:600px;overflow:hidden;border:0px">
<div style="width:900px;height:450px;margin:-153px 0px 0px -10px;">
<iFrame src="teacher_admin.php" width="900px" height="850px" scrolling="yes"></iFrame>
</div>
</div>
</div>
</div>
</body>
</html>teacher_admin.php
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="UTF-8">
<title>教师管理</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div class="tea_out">
<div class="tea_in">
<div class="tea">
<a href="teacher_insert.html"><button><b>添加新的教师</b></button></a>
<a href="teacher_search.php"><button><b>查看教师信息</b></button></a>
</div>
<div class="tea">
<table border="1" width="90%" align="center">
<tr align="center">
<td width="25%">姓名</td>
<td width="25%">手机号码</td>
<td width="25%">更新</td>
<td width="25%">删除</td>
</tr>
<?php
include 'mysql_conn.php';
sql_search_update();
?>
</table>
</div>
</div>
</div>
</body>
</html>teacher_delete.php
<link href="style.css" rel="stylesheet" type="text/css">
<div class="outside" align="center">
<div class="inside">
<h1>确认删除<?php $_GET["name"] ?></h1>
</div>
<div class="inside">
<?php
echo "<a href='teacher_delete_do.php?name=".$_GET["name"]."&phone_number=".$_GET["phone_number"]."'><button><b>确认</b></button></a>"
?>
<a href="teacher_admin.php"><button><b>取消</b></button></a>
</div>
</div>teacher_delete_do.php
<link href="style.css" rel="stylesheet" type="text/css">
<div class="outside" align="center">
<div class="inside">
<?php
include "mysql_conn.php";
$name = "name='".$_GET['name']."' AND phone_number='".$_GET['phone_number']."'";
sql_delete($name);
echo "教师".$_GET['name']."已经删除成功";
?>
</div>
<div class="inside">
<br><a href="teacher_admin.php"><button><b>返回教师管理</b></button></a>
</div>
</div>teacher_insert.html
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="UTF-8">
<title>教师添加</title>
<link href="style.css" rel="stylesheet" type="text/css">
<script type="text/javascript">
function tijiao()
{
var name = document.getElementById("name").value;
var birth = document.getElementById("birth").value;
var phone_number = document.getElementById("phone_number").value;
var email = document.getElementById("email").value;
var competent = document.getElementById("competent").value;
var direction = document.getElementById("direction").value;
if(name == ""){alert("姓名为空！！！");return false;}
else if(birth == ""){alert("出生年月为空！！！");return false;}
else if(phone_number == ""){alert("手机号为空！！！");return false;}
else if(email == ""){alert("电子邮箱为空！！！");return false;}
else if(competent == ""){alert("职称为空！！！");return false;}
else if(direction == ""){alert("研究方向为空！！！");return false;}
else
{
alert("提交正常！！！");
return true;
}
}
function fanhui(){window.location.href = 'teacher_main.php'}
</script>
</head>
<body>
<form name="forml_tea" action="teacher_insert.php" method="post" onsubmit="return tijiao()" enctype="multipart/form-data">
<div align="center" class="TInsertOut">
<div class="TInsertIn">
<h1>教师录入</h1>
</div>
<div class="TInsertIn">
<div class="TeaText"><span><b>姓 名：</b><input type="text" name="name" id="name" width="100px" placeholder="张三"/></span></div>
<div class="TeaText"><span><b>出生年月：</b><input type="date" name="birth" id="birth" width="100px"/></span> </div>
<div class="TeaText"><span><b>手机号码：</b><input type="text" name="phone_number" id="phone_number" width="100px" placeholder="10010001000"/></span></div>
<div class="TeaText"><span><b>电子邮箱：</b><input type="email" name="email" id="email" width="100px" placeholder="123@xx.com"/></span></div>
<div class="TeaText"><span><b>职 称：</b><input type="text" name="competent" id="competent" width="100px" placeholder="博士"/></span></div>
<div class="TeaText"><span><b>研究方向：</b><input type="text" name="direction" id="direction" width="100px" placeholder="通信"/></span></div>
</div>
<div class="TInsertIn">
<div class="TeaButton">
<input type="submit" name="btn_submit" value="提交"id="TInsertButton1"/>
<input type="reset" name="btn_reset" value="重填"id="TInsertButton2"/>
<br><input type="reset" name="btn_reset" value="返回" onclick="fanhui()"/>
</div>
</div>
</div>
</form>
</body>
</html>teacher_insert.php
<link href="style.css" rel="stylesheet" type="text/css">
<div class="outside" align="center">
<div class="inside">
<?php
$name = $_POST['name'];
$birth = $_POST['birth'];
$phone_number = $_POST['phone_number'];
$email = $_POST['email'];
$competent = $_POST['competent'];
$direction = $_POST['direction'];
include "mysql_conn.php";
$value = "'$name','$birth','$phone_number','$email','$competent','$direction'";
sql_insert("",$value);
?>
</div>
<div class="inside">
<br><a href="teacher_admin.php"><button><b>返回教师管理</b></button></a>
</div>
</div>
teacher_search.php
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="UTF-8">
<title>师资队伍</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div class="outside">
<div class="inside">
<h2>教师信息</h2>
<p><a href="teacher_admin.php"><button><b>返回</b></button></a></p>
</div>
<div class="inside">
<table border="1" align="center" width="90%">
<tr align="center">
<td width="10%">姓名</td>
<td width="15%">出生年月</td>
<td width="15%">手机号码</td>
<td width="20%">Email</td>
<td width="10%">职称</td>
<td width="30%">研究方向</td>
</tr>
<?php
include 'mysql_conn.php';
sql_search_all();
?>
</table>
</div>
</div>
</body>
</html>teacher_update.php
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="UTF-8">
<title>教师修改</title>
<link href="style.css" rel="stylesheet" type="text/css">
<script type="text/javascript">
function tijiao()
{
alert("修改已提交！！！");
return true;
}
function fanhui(){window.location.href = 'teacher_admin.php'}
</script>
</head>
<body>
<?php
$name = $_GET['name'];
$phone_number=$_GET['phone_number'];
echo "<form name=\"forml_tea\" action=\"teacher_update_do.php?name=$name&phone_number=$phone_number\" method=\"post\" onsubmit=\"return tijiao()\" enctype=\"multipart/form-data\">";
?>
<div align="center" class="TInsertOut">
<div class="TInsertIn">
<?php
echo "<h1>$_GET[name]教师信息修改</h1>";
echo "<p>未填写内容为原内容</p>";
?>
</div>
<div class="TInsertIn">
<div class="TeaText"><span><b>姓 名：</b><input type="text" name="name" placeholder="张三"/></span></div>
<div class="TeaText"><span><b>出生年月：</b><input type="date" name="birth" /></span> </div>
<div class="TeaText"><span><b>手机号码：</b><input type="text" name="phone_number" placeholder="10010001000"/></span></div>
<div class="TeaText"><span><b>电子邮箱：</b><input type="email" name="email" placeholder="123@xx.com"/></span></div>
<div class="TeaText"><span><b>职 称：</b><input type="text" name="competent" placeholder="博士"/></span></div>
<div class="TeaText"><span><b>研究方向：</b><input type="text" name="direction" placeholder="通信"/></span></div>
</div>
<div class="TInsertIn">
<div class="TeaButton">
<input type="submit" name="btn_submit" value="提交"id="TUpBut1"/>
<input type="reset" name="btn_reset" value="重填" onclick="chongxie()" id="TUpBut2"/>
<br><input type="reset" name="btn_reset" value="返回" onclick="fanhui()"/>
</div>
</div>
</div>
</form>
</body>
</html>teacher_update_da.php
<link href="style.css" rel="stylesheet" type="text/css">
<div class="outside" align="center">
<div class="inside">
<?php
$name = $_POST['name']??'';
$birth = $_POST['birth']??'';
$phone_number = $_POST['phone_number']??'';
$email = $_POST['email']??'';
$competent = $_POST['competent']??'';
$direction = $_POST['direction']??'';
//str字符串为sql where条件
$str = "name = '".$_GET['name']."' AND phone_number = '".$_GET['phone_number']."'";
//value字符串为sql set修改值
$value = '';
include "mysql_conn.php";
if ($name !='') {$value = "name = '".$name."'";}
if ($birth !='') {$value=$value == ''?"birth = '".$birth."'":$value.",birth = '".$birth."'";}
if ($phone_number !='') {$value=$value == ''?"phone_number = '".$phone_number."'":$value.",phone_number = '".$phone_number."'";}
if ($email !='') {$value=$value == ''?"email = '".$email."'":$value.",email = '".$email."'";}
if ($competent !='') {$value=$value == ''?"competent = '".$competent."'":$value.",competent = '".$competent."'";}
if ($direction !='') {$value=$value == ''?"direction = '".$direction."'":$value.",direction = '".$direction."'";}
//判断信息是否进行了变更
if ($value == '') {echo "信息未进行修改！";}
else {if (sql_update($str,$value) == 0) {echo "<h1>$_GET[name]教师信息修改成功</h1>";}}
echo $str;
echo $value;
?>
</div>
<div class="inside">
<br><a href="teacher_admin.php"><button><b>返回教师管理</b></button></a>
</div>
</div>实验展示
点击查看完整网页