php实例 简单学生成绩管理系统
学了php的一些基础,包括HTML,php,pdo,mysql操作等,一直都没有将它们有机结合。最近写了一个简单的网页版学生信息管理系统,前台用HTML,脚本用到了JavaScript和PHP,数据库用到了MySQL。麻雀虽小,五脏俱全。算是对这些知识的一次总结吧。
首先通过login_in 进入登录页面 用户输入信息到login.php中 ,login.php 连接数据库判断是否账号密码是否正确。
通过验证转入welcome_mag.html页面用户选择跳入Select_mag.html查看成绩,lnsert.html插入成绩,delete.html删除成绩。
查看成绩 从页面输入信息 select_opt.php获取用户指令,连接数据库,找出相应的数据并显示。
插入成绩 从页面输入信息 mysql_opt.php获取用户指令,连接数据库,在数据库中添加信息并返回welcome页面。
删除成绩 从页面输入要删出的学号delete_opt.phpl获取指令,连接数据库,删除相应信息并返回welcome页面。
注意事项:1获取用户输入信息 2数据库使用转码,从数据库中查找文字尚未解决 只能查找数字 3连接数据库的mysqli语句 4页面跳转
5<?php 和?>的插入位置 login_in.html到login.php页面可以看到方法
数据库需要 SGMsystem库 其中包含login 用户登录表 stu_info 成绩存储表
需要软件phpSrorm wampp
所有需要的文件 02头像 bg背景图index.css样式表
login_in.html文件++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>重新_信息登录系统标题栏显示</title> <link rel="stylesheet" href="css/index.css" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" /> </head> <body> <img src="css/bgImg.jpg" class="bgImg" /> <form class="content" action="login.php" method="post"> <div class="bidTitle">学生信息管理系统</div> <div class="logCon"> <div class="line"><span>账号:</span> <input class="bt_input" placeholder="请输入四位账号" name="no" tabindex="1" type="text" ></div> <div class="line"><span>密码:</span> <input class="bt_input" placeholder="请输入密码" name="password" tabindex="2" type="password" ></div> <button type="submit" class="logingBut" value="提交" >登录</button> </div> </form> </body> login.php文件 <title>用户登录验证</title> <meta charset="utf-8"> <?php function get_str($str){ $val = ($_POST[$str])?$_POST[$str]:null; return $val;} $nom = get_str("no"); $password = get_str("password"); if($nom==null or $password==null){?> <script type="text/javascript"> alert("账号或者密码不能为空"); window.location.href="login_in.html" rel="external nofollow" rel="external nofollow" ; </script> <?php } $con =mysqli_connect("localhost","root",""); if($con){?> <script type="text/javascript" > alert("成功连接数据库"); // window.location.href="login_in" rel="external nofollow" rel="external nofollow" ; </script><?php mysqli_select_db($con,"sgmsystem"); mysqli_query($con,"SET NAMES utf8"); /*转码为utf8 否则会出现乱码*/ $sql = "select * from login where no=$nom"; $info = mysqli_query($con, $sql); $num = mysqli_num_rows($info); if($num){ $row = mysqli_fetch_row($info); if($row[2]==$password){?> <script type="text/javascript"> alert("欢迎登录"); window.location.href="welcome_mag.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ; </script><?php } } else{?> <script type="text/javascript"> alert("账号不存在或者密码错误"); window.location.href="login_in.html" rel="external nofollow" rel="external nofollow" ; </script><?php }} else{?> <script type="text/javascript"> alert("连接数据库发生错误"); window.location.href="login_in" rel="external nofollow" rel="external nofollow" ; </script><?php }
welcome_mag.html文件++++++++++++++++++++++++++++++++++++++++++++
<!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>欢迎界面</title> <style> a{text-decoration: none;font-size:25px;font-family:微软雅黑;color:rgb(98,94,91);} a:link{color:#00FFFF;}/*未访问的颜色 蓝色*/ a:hover{color:#FF00FF;}/*鼠标放上去的颜色(没起作用) 紫色*/ a:visited{color:#00FFFF;}/*访问过的颜色 蓝色*/ a:active{color:#FF00FF;}/*选定的代码 紫色*/ </style> <link rel="stylesheet" href="css/index.css" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" /> </head> <body> <img src="css/bgImg.jpg" class="bgImg" /> <div class="content" style="position: absolute;padding: 10px;top:-60px;left:480px"> <div class="bidTitle">欢迎管理员登录,您可以进行所有操作</div> <div style="height:180px;width:180px;margin:0px auto;" align="right"> <p sytle="text-align:center;"> <img src="css/02.png" width="160" height="160" align="right"/> </p> </div> <div class="bidTitle">请选择您需要的服务</div> <div class="logCon"> <p><a href="insert.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" align="center" >输入学生成绩信息</a></p> <p><a href="select_mag.html" rel="external nofollow" align="center">查询学生成绩信息</a></p> <p><a href="delete.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" align="center">删除学生成绩信息</a></p> </div> </div> </body> </html> select_mag.html文件+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ <!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>信息查询界面</title> <style type = "text/css"> a{text-decoration: none;font-size:25px;font-family:微软雅黑;color:rgb(98,94,91);} a:link{color:#00FFFF;}/*未访问的颜色 蓝色*/ a:hover{color:#FF00FF;}/*鼠标放上去的颜色(没起作用) 紫色*/ a:visited{color:#00FFFF;}/*访问过的颜色 蓝色*/ a:active{color:#FF00FF;}/*选定的代码 紫色*/ </style> <link rel="stylesheet" href="css/index.css" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" /> </head> <body> <img src="css/bgImg.jpg" class="bgImg" /> <div class="content" style="position: absolute;padding: 10px;top:-100px;left:480px"> <div class="bidTitle"> <p>请输入学生的学号进行查询操作</p> <p>如果要查询所有学生信息请输入“all”进行查询</p> </div> <div style="height:180px;width:180px;margin:0px auto;" align="right"> <p sytle="text-align:center;"> <img src="css/02.png" width="160" height="160" align="right"/> </p> </div> <form action="select_opt.php" method="post" class="logCon"> <input type="text" name="check" class="bt_input" placeholder="请输入要查询学生的学号"> <br/> <input type="submit" value="查询" class="logingBut" style="width:330px;margin-left:-20px" > </form> <div style="height:100px;width:240px;margin:0px auto;" align="center"> <br/> <p><a href="welcome_mag.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" align="center" >返回服务选择页面</a></p> </div> </div> </body> </html>
select_opt.php文件++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<html> <head> <title>数据库后台操作</title> <meta charset="utf-8"> </head> <body> <?php //这个页面主要是对插入进行处理 function get_str($str){ $val = ($_POST[$str])?$_POST[$str]:null; return $val; } $num = get_str("id");//接收学号 $name = get_str("name");//接收姓名 $class = get_str("class");//接收班级 $sex = get_str("sex");//接收性别 $chi = get_str("chinese");//接收语文成绩 $mat = get_str("math");//接收数学成绩 $eng = get_str("english");//接收英语成绩 $syn = get_str("science");//接收理综成绩 if($num==0 or $name ==null or $class == null or $sex ==null or $chi ==0 or $mat ==0 or $eng ==0 or $syn ==0){?> <script type="text/javascript"> alert("数据输入有误,请重新输入"); window.location.href="insert.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ; </script> <?php } $sum = $chi + $mat + $eng + $syn;//计算总分 $con = mysqli_connect("localhost","root",""); /* 连接数据库*/ if(!$con){ ?> <script type="text/javascript"> alert("数据库连接失败"); window.location.href="insert.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ; </script> <?php } mysqli_query($con,"SET NAMES utf8"); //将这组数据写进数据库 $sql = "insert into stu_info (id,name,calss,sex,chinese,math,english,science,sum) values($num,'$name','$class','$sex',$chi,$mat,$eng,$syn,$sum)"; mysqli_select_db($con,"sgmsystem"); $info = mysqli_query($con,$sql); if($info){ ?> <script type="text/javascript"> alert("写入成功"); window.location.href="insert.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ; </script> <?php } else{ ?> <script type="text/javascript"> alert("没有找到账号密码"); window.location.href="insert.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ; </script> <?php } ?> </body> </html>
insert.html文件++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<!DOCTYPE html> <html lang="en"> <head> <title>增添学生成绩数据</title> <meta charset="utf-8"> <style type = "text/css"> a{text-decoration: none;font-size:25px;font-family:微软雅黑;color:rgb(98,94,91);} a:link{color:#00FFFF;}/*未访问的颜色 蓝色*/ a:hover{color:#FF00FF;}/*鼠标放上去的颜色(没起作用) 紫色*/ a:visited{color:#00FFFF;}/*访问过的颜色 蓝色*/ a:active{color:#FF00FF;}/*选定的代码 紫色*/ </style> <link rel="stylesheet" href="css/index.css" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" /> </head> <body> <img src="css/bgImg.jpg" class="bgImg" /> <div class="content" style="position: absolute;padding: 10px;top:-185px;left:480px"> <div class="bidTitle">请填写表单以添加数据</div> <div style="height:180px;width:180px;margin:0px auto;" align="right"> <p sytle="text-align:center;"> <img src="css/02.png" width="160" height="160" align="right"/> </p> </div> <form action="mysql_opt.php" method="post" class="logCon" > <ul style="list-style: none"> <li> 学号:<input type="text" name="id" class ="bt_input" style="height:5px" placeholder="请输入学号(唯一)"> </li> <li> 姓名:<input type="text" name="name" class ="bt_input" style="height:5px" placeholder="请输入姓名"> </li> <li> 班级:<input type="text" name="class" class ="bt_input" style="height:5px" placeholder="请输入班级(可全使用字符)"> </li> <li> 性别:<input type="text" name="sex" class ="bt_input" style="height:5px" placeholder="请输入性别"> </li> <li> 语文:<input type="text" name="chinese" class ="bt_input" style="height:5px" placeholder="请输入语文成绩(满分150)"> </li> <li> 数学:<input type="text" name="math" class ="bt_input" style="height:5px" placeholder="请输入数学成绩(满分150)"> </li> <li> 英语:<input type="text" name="english" class ="bt_input" style="height:5px" placeholder="请输入英语成绩(满分150)"> </li> <li> 理综:<input type="text" name="science" class ="bt_input" style=";height:5px" placeholder="请输入英语成绩(满分300)"> </li> </ul> <input type="submit" value="提交" style ="height : 36px;border:1px;background-color:#00bee7;color:#fff;width:72px;border-radius: 3px;"> </form> <div style="height:100px;width:240px;margin:0px auto;" align="center"> <br/> <a href="welcome_mag.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" align="center" style="height:10px" >返回服务选择页面</a></div> </div> </body> </html>
mysql_opt.php文件++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<html> <head> <title>数据库后台操作</title> <meta charset="utf-8"> </head> <body> <?php //这个页面主要是对插入进行处理 function get_str($str){ $val = ($_POST[$str])?$_POST[$str]:null; return $val; } $num = get_str("id");//接收学号 $name = get_str("name");//接收姓名 $class = get_str("class");//接收班级 $sex = get_str("sex");//接收性别 $chi = get_str("chinese");//接收语文成绩 $mat = get_str("math");//接收数学成绩 $eng = get_str("english");//接收英语成绩 $syn = get_str("science");//接收理综成绩 if($num==0 or $name ==null or $class == null or $sex ==null or $chi ==0 or $mat ==0 or $eng ==0 or $syn ==0){?> <script type="text/javascript"> alert("数据输入有误,请重新输入"); window.location.href="insert.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ; </script> <?php } $sum = $chi + $mat + $eng + $syn;//计算总分 $con = mysqli_connect("localhost","root",""); /* 连接数据库*/ if(!$con){ ?> <script type="text/javascript"> alert("数据库连接失败"); window.location.href="insert.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ; </script> <?php } mysqli_query($con,"SET NAMES utf8"); //将这组数据写进数据库 $sql = "insert into stu_info (id,name,calss,sex,chinese,math,english,science,sum) values($num,'$name','$class','$sex',$chi,$mat,$eng,$syn,$sum)"; mysqli_select_db($con,"sgmsystem"); $info = mysqli_query($con,$sql); if($info){ ?> <script type="text/javascript"> alert("写入成功"); window.location.href="insert.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ; </script> <?php } else{ ?> <script type="text/javascript"> alert("没有找到账号密码"); window.location.href="insert.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ; </script> <?php } ?> </body> </html>
delete.html文件+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>删除服务界面</title> <style> a{text-decoration: none;font-size:25px;font-family:微软雅黑;color:rgb(98,94,91);} a:link{color:#00FFFF;}/*未访问的颜色 蓝色*/ a:hover{color:#FF00FF;}/*鼠标放上去的颜色(没起作用) 紫色*/ a:visited{color:#00FFFF;}/*访问过的颜色 蓝色*/ a:active{color:#FF00FF;}/*选定的代码 紫色*/ </style> <link rel="stylesheet" href="css/index.css" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" /> </head> <body> <img src="css/bgImg.jpg" class="bgImg" /> <div class="content" style="position: absolute;padding: 10px;top:-60px;left:480px" > <div class="bidTitle">请输入学生的学号以删除学生信息</div> <br/> <div style="height:180px;width:180px;margin:0px auto;" align="right"> <p sytle="text-align:center;"> <img src="css/02.png" width="160" height="160" align="right"/> </p> </div> <form action="delete_opt.php" method="post" class="logCon" > <input type="text" name="delete" class ="bt_input" placeholder="请输入要删除学生信息的学号"> <br/> <input class="logingBut" type="submit" value="删除" style="width:330px;margin-left:-20px"> </form> <div class="bidTitle"> <p><a href="welcome_mag.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" align="center" >返回服务选择页面</a></p> </div> </div> </body> </html>
delete_opt.php文件++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>删除操作后台执行页面</title> </head> <?php function get_str($str){ $val = ($_POST[$str])?$_POST[$str]:null; return $val; } $number = get_str("delete"); $con = mysqli_connect("localhost","root",""); if(!$con){ ?> <script type="text/javascript"> alert("数据库连接失败"); window.location.href="delete.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ; </script> <?php } $sql = "select * from stu_info where id=$number"; mysqli_select_db($con,"sgmsystem"); $info = mysqli_query($con,$sql); $num = mysqli_num_rows($info); if(!$num){ ?> <script type="text/javascript"> alert("找不到该同学,请重新输入学号"); window.location.href="delete.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ; </script> <?php } else{ //找到了该同学,进行删除操作 $sql = "delete from stu_info where id = $number"; $info = mysqli_query($con,$sql); if($info){ //删除成功 ?> <script type="text/javascript"> alert("删除成功"); window.location.href="delete.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ; </script> <?php } else{ //删除失败 ?> <script type="text/javascript"> alert("删除失败"); window.location.href="delete.html" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ; </script> <?php } } ?>
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持我们。