
php学生管理系统源码,供大家参考,具体内容如下
功能:
1.添加/删除/修改
2.数据存储.
界面分布:
index.php
--->主界面
add.php --->stu添加
action ---> sql中add/del/update
(处理html表单-->mysql的数据存储 && 页面跳转)
edit.php --->stu修改
menu.php
-->首页
1. index.php
学生信息管理
include ("menu.php");?>浏览学生信息ID姓名性别年龄班级操作// 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 "";echo "{$row['id']} ";echo "{$row['name']}";echo "{$row['sex']} ";echo "{$row['age']} ";echo "{$row['classid']}
include ("menu.php");
?>
浏览学生信息
ID
姓名
性别
年龄
班级
操作
// 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 "";echo "{$row['id']} ";echo "{$row['name']}";echo "{$row['sex']} ";echo "{$row['age']} ";echo "{$row['classid']}
// 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 "";
echo "{$row['id']} ";
echo "{$row['name']}";
echo "{$row['sex']} ";
echo "{$row['age']} ";
echo "{$row['classid']}
