很多站长朋友们都不太清楚php学生信息代码，今天小编就来给大家整理php学生信息代码，希望对各位有所帮助，具体内容如下：
本文目录一览： 1、 php 学生信息管理系统 修改怎么写 2、 学生管理系统php源码谁有 3、 PHP select条件查找代码，按照学号查询，即从后台舒服学生学号即可查询到该学号学生的表中信息 php 学生信息管理系统 修改怎么写都是很简单的东西，新手用得着、、、
省略部分前端代码、、、
首先是登录的校验：
<?php
session_start();
$user = $_POST['userName'];
$pass = $_POST['passWord'];
$_SESSION['user'] = $user;
/*$Enter = $_POST['Login_undo'];
管理员登录的校验*/
$flag = false;
if($user == "Admin" $pass == "root")
{
setcookie("userName",$user,time()+1200);
setcookie("userName",$pass,time()+1200);
$flag = true;
header('location:adminPage.php?user=' . $user);
}
else
header('location:Login.php?login=relog');
/*
// 学生登录免校验
if($Enter)
header('location:StuPage.php');
*/
然后是注册的校验：
<?php
session_start();
$s_ID = $_POST['s_ID'];
$Name = $_POST['Name'];
$IDcard = $_POST['IDcard'];
$Major = $_POST['Major'];
$sex = $_POST['sex'];
$_SESSION['student'][$s_ID]['s_ID'] = $s_ID;
$_SESSION['student'][$s_ID]['Name'] = $Name;
$_SESSION['student'][$s_ID]['IDcard'] = $IDcard;
$_SESSION['student'][$s_ID]['Major'] = $Major;
$_SESSION['student'][$s_ID]['sex'] = $sex;
header('location:tisi.html');
/*foreach($_SESSION['student'] as $v)
{
if($v == $s_ID)
{
header("location:stu_reg.php?action=lookmsg=更新user=employeeempno=" . $empno . "idcard=" . $idcard);
}
else
header("location:stu_reg.php?action=lookmsg=增加user=employeeempno=" . $empno . "idcard=" . $idcard);
}*/
毕业操作及加入历史校验：
<?php
session_start();
$s_ID=$_GET['s_ID'];
$_SESSION['history'][$s_ID]['s_ID']=$s_ID;
$_SESSION['history'][$s_ID]['Name']=$_SESSION['student'][$s_ID]['Name'];
$_SESSION['history'][$s_ID]['IDcard']=$_SESSION['student'][$s_ID]['IDcard'];
$_SESSION['history'][$s_ID]['sex']=$_SESSION['student'][$s_ID]['sex'];
$_SESSION['history'][$s_ID]['Major']=$_SESSION['student'][$s_ID]['Major'];
unset($_SESSION['student'][$s_ID]);
header('location:graduate.php?user=Adminaction=delete');
任意关键词查询：
<?php
session_start();
$search=$_POST['search'];
unset($_SESSION['search']);
/*echo '<pre>';
var_dump($_POST['search']);
return ;*/
foreach ($_SESSION['student'] as $k1 => $value) {
# code...
if($search==$_SESSION['student'][$k1]['s_ID']||$search==$_SESSION['student'][$k1]['IDcard']||$search==$_SESSION['student'][$k1]['Name']||$search==$_SESSION['student'][$k1]['sex']||$search==$_SESSION['student'][$k1]['Major']){
$i = 1;
$stu = $_SESSION['student'][$k1]['s_ID'];
$_SESSION['search'][$stu] = $stu;
}
}
if(isset($i))
header("location:stu_Query.php?user=Adminaction=search");
else
header("location:stu_Query.php?user=Adminaction=q_error");
遍历学生信息：
<!DOCTYPE HTML>
<html>
<head>
<link href="file/Style.Css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="100%" border="0" cellpadding="1" cellspacing="1" class="css_table" bgcolor='#E1E1E1'>
<?php
session_start();
$user = isset($_SESSION['user'])?$_SESSION['user']:'';
if($user =='Admin'){
if(isset($_SESSION['student'])){
foreach($_SESSION['student'] as $k1) {
echo "<tr>";
foreach($k1 as $k2=>$k3) {
echo "<td>" ;
if($k2=='s_ID') {echo "学号:" ;} else if($k2=='IDcard'){echo "身份证号:";}else if($k2=='sex'){echo "性别:";}else if($k2=='Name'){echo "姓名:";}else if($k2 =='Major'){echo "专业:";};
echo "</td>";
echo "<td>";
if($k2=='s_ID') $s_ID=$k3; echo "$k3";
echo "</td>";
}
}
}
}
?>
</table>
</body>
</html>
更新数据的页面及校验：
<!DOCTYPE HTML>
<!-- 使用HTML5规范，省略多余部分 -->
<html>
<head>
<?php
session_start();
$user = isset($_SESSION['user'])?$_SESSION['user']:'';
$action = isset($_GET['action'])?$_GET['action']:'';
?>
<link href="file/Style.Css" rel="stylesheet" type="text/css" />
</head>
<body>
<?php if($user =='Admin'$action==''){ ?>
<table width="100%" border="0" cellpadding="3" cellspacing="1" class="css_table" bgcolor='#E1E1E1'>
<tr class="css_menu">
<td colspan="3">
<table width="100%" border="0" cellpadding="4" cellspacing="0" class="css_main_table">
<tr>
<td class="css_main">注意</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="css_col11"><strong><font color=#50691B>一旦确定不可更改</font></strong></td>
</tr>
<form name = "check_stu" method="post" action="check_stu.php">
<td><lable>请输入修改学生的学号:
<input name = "c_ID" type="text" >
<input name = "submit" type="submit" value="确定">
</lable></td>
</form>
</table>
<?php }else if ($action == 'change') {?>
<form name="login_f" method="post" action="update_check.php">
<div class = "login" align="center">
<lable>可以修改的项目：</lable>
<input name = "c_ID" type="hidden" value = "<?php echo $_GET['c_ID'];?>">
<li><p>学生姓名：
<input name = "Name" type = "text" id = "Name"></p></li>
<li><p>专业：
<input name = "Major" type = "text" id = "Major"></p></li>
<li>
<p>性别：
<!-- <input name = "sex" type = "text" id = "sex"></p></li> -->
<input type="radio" name="sex" value="男"/>男
<input type="radio" name="sex" value="女"/>女 </br>
</li>
<li><p>确定修改：
<input name = "submit" type = "submit" value = "确定" >
<input class="Renew" value="重写" type="reset" /> </p></li>
</form>
</div>
<?php }else if ($action == 'enchange') {
# code...
echo "<h1>已经改变</h1>";
}?>
</body>
</html>
<?php
session_start();
$s_ID = $_POST['c_ID'];
$Name = $_POST['Name'];
$Major = $_POST['Major'];
$sex = $_POST['sex'];
$_SESSION['student'][$s_ID]['s_ID'] = $s_ID;
$_SESSION['student'][$s_ID]['Name'] = $Name;
$_SESSION['student'][$s_ID]['Major'] = $Major;
$_SESSION['student'][$s_ID]['sex'] = $sex;
header("location:stu_Update.php?action=enchange");
学生管理系统php源码谁有php学生管理系统源码，供大家参考，具体内容如下
功能：
1.添加／删除／修改
2.数据存储.
界面分布：
index.php
--->主界面
add.php --->stu添加
action ---> sql中add/del/update
(处理html表单-->mysql的数据存储 ＆＆ 页面跳转)
edit.php --->stu修改
menu.php
-->首页
1. index.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>学生信息管理</title>
<script>
function doDel(id) {
if(confirm('确认删除?')) {
window.location='action.php?action=delid='+id;
}
}
</script>
</head>
<body>
<center>
<?php
include ("menu.php");
?>
<h3>浏览学生信息</h3>
<table width="500" border="1">
<tr>
<th>ID</th>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
<th>班级</th>
<th>操作</th>
</tr>
<?php
// 1. 链接数据库
try{
$pdo = new PDO("uri:mysqlPdo.ini","root","1");
}catch (PDOException $e) {
die('connection failed'.$e->getMessage());
}
//2.执行sql
$sql_select = "select * from stu";
//3.data 解析
foreach ( $pdo->query($sql_select) as $row) {
echo "<tr>";
echo "<th>{$row['id']} </th>";
echo "<th>{$row['name']}</th>";
echo "<th>{$row['sex']} </th>";
echo "<th>{$row['age']} </th>";
echo "<th>{$row['classid']}</th>";
echo "<td>
<a href='edit.php?id={$row['id']}'>修改</a>
<a href='javascript:void(0);' onclick='doDel({$row['id']})'>删除</a>
</td>";
echo "</tr>";
}
?>
</table>
</center>
</body>
</html>
2. add.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>学生管理系统</title>
</head>
<body>
<center>
<?php include ('menu.php'); ?>
<h3>增加学生信息</h3>
<form action="action.php?action=add" method="post">
<table>
<tr>
<td>姓名</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>年龄</td>
<td><input type="text" name="age"></td>
</tr>
<tr>
<td>性别</td>
<td><input type="radio" name="sex" value="男">男</td>
<td><input type="radio" name="sex" value="女">女</td>
</tr>
<tr>
<td>班级</td>
<td><input type="text" name="classid"></td>
</tr>
<tr>
<!-- <td> </td>-->
<td><a href="index.php">返回</td>
<td><input type="submit" value="添加"></td>
<td><input type="reset" value="重置"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
3. action.php
<?php
/**
* Created by PhpStorm.
* User: hyh
* Date: 16-7-7
* Time: 下午9:37
*/
//1. 链接数据库
try{
$pdo = new PDO("uri:mysqlPdo.ini","root","1");
}catch (PDOException $e) {
// echo 'Connection failed: ' . $e->getMessage();
die('connection failed'.$e->getMessage());
}
//2.action 的值做对操作
switch ($_GET['action']){
case 'add'://add
$name = $_POST['name'];
$sex = $_POST['sex'];
$age = $_POST['age'];
$classid = $_POST['classid'];
$sql = "insert into stu (name, sex, age, classid) values ('{$name}', '{$sex}','{$age}','{$classid}')";
$rw = $pdo->exec($sql);
if ($rw > 0){
echo "<script>alter('添加成功');</script>";
}else{
echo "<script>alter('添加失败');</script>";
}
header('Location: index.php');
break;
case 'del'://get
$id = $_GET['id'];
$sql = "delete from stu where id={$id}";
$rw = $pdo->exec($sql);
if ($rw > 0){
echo "<script>alter('删除成功');</script>";
}else{
echo "<script>alter('删除失败');</script>";
}
header('Location: index.php');
break;
case 'edit'://post
$id = $_POST['id'];
$name = $_POST['name'];
$age = $_POST['age'];
$classid = $_POST['classid'];
$sex = $_POST['sex'];
// echo $id, $age, $age, $name;
$sql = "update stu set name='{$name}', age={$age},sex='{$sex}',classid={$classid} where id={$id};";
// $sql = "update myapp.stu set name='jike',sex='女', age=24,classid=44 where id=17";
print $sql;
$rw = $pdo->exec($sql);
if ($rw > 0){
echo "<script>alter('更新成功');</script>";
}else{
echo "<script>alter('更新失败');</script>";
}
header('Location: index.php');
break;
default:
header('Location: index.php');
break;
}
4.edit.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>学生管理系统</title>
</head>
<body>
<center>
<?php include ('menu.php');
//1. 链接数据库
try{
$pdo = new PDO("uri:mysqlPdo.ini","root","1");
}catch (PDOException $e) {
die('connection failed'.$e->getMessage());
}
//2.执行sql
$sql_select = "select * from stu where id={$_GET['id']}";
$stmt = $pdo->query($sql_select);
if ($stmt->rowCount() >0) {
$stu = $stmt->fetch(PDO::FETCH_ASSOC); // 解析数据
}else{
die("no have this id:{$_GET['id']}");
}
?>
<h3>修改学生信息</h3>
<form action="action.php?action=edit" method="post">
<input type="hidden" name="id" value="<?php echo $stu['id'];?>">
<table>
<tr>
<td>姓名</td>
<td><input type="text" name="name" value="<?php echo $stu['name'];?>"></td>
</tr>
<tr>
<td>年龄</td>
<td><input type="text" name="age" value="<?php echo $stu['age'];?>"></td>
</tr>
<tr>
<td>性别</td>
<td>
<input type="radio" name="sex" value="男" <?php echo ($stu['sex'] == "男")? "checked":"";?> >男
</td>
<td>
<input type="radio" name="sex" value="女" <?php echo ($stu['sex'] == "女")? "checked":"";?> >女
</td>
</tr>
<tr>
<td>班级</td>
<td><input type="text" name="classid" value="<?php echo $stu['classid']?>"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" value="更新"></td>
<td><input type="reset" value="重置"></td>
</tr>
</table>
</form>
</center>
<?php
?>
</body>
</html>
5. menu.php
<!DOCTYPE html>
<html lang="en">
<body>
<strong>学生管理系统</strong>
<a href="index.php"> 浏览学生</a>
<a href="add.php"> 添加学生</a>
<hr>
</body>
</html>
PHP select条件查找代码，按照学号查询，即从后台舒服学生学号即可查询到该学号学生的表中信息$result=mysql_query("select * from xscjb group by xsxh");
因为你写的就是查全表啊，要是相查某个学号的
你这样写啊 "select * from xscjb where `学号名称`='学号' group by xsxh
关于php学生信息代码的介绍到此就结束了，不知道本篇文章是否对您有帮助呢？如果你还想了解更多此类信息，记得收藏关注本站，我们会不定期更新哦。
查看更多关于php学生信息代码 基于php的学生信息管理系统的详细内容...