锐客网

  1. 首页 > 睿知 > it技术 > >

php学生管理数据库 php学生管理数据库是什么

IT技术数据库

学生管理系统php源码谁有php学生管理系统源码php学生管理数据库 ， 供大家参考 ， 具体内容如下
功能php学生管理数据库：
1.添加／删除／修改
2.数据存储.
界面分布php学生管理数据库：
index.php
---主界面
add.php ---stu添加
action --- sql中add/del/update
(处理html表单--mysqlphp学生管理数据库的数据存储 ＆＆ 页面跳转)
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
thID/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='https://www.04ip.com/post/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
tdinput type="text" name="name"/td
/tr
tr
td年龄/td
tdinput type="text" name="age"/td
/tr
tr
td性别/td
tdinput type="radio" name="sex" value="https://www.04ip.com/post/男"男/td
tdinput type="radio" name="sex" value="https://www.04ip.com/post/女"女/td
/tr
tr
td班级/td
tdinput type="text" name="classid"/td
/tr
tr
!--td /td--
tda href="https://www.04ip.com/post/index.php"返回/td
tdinput type="submit" value="https://www.04ip.com/post/添加"/td
tdinput type="reset" value="https://www.04ip.com/post/重置"/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 ($rw0){
echo "scriptalter('添加成功');/script";
}else{
echo "scriptalter('添加失败');/script";
}
header('Location: index.php');
break;
case 'del'://get
$id = $_GET['id'];
$sql = "delete from stu where id={$id}";
$rw = $pdo-exec($sql);

推荐阅读


上一篇：vivo手机u盘怎么清理，vivo手机u盘怎么安全移除

下一篇：切割模拟器3游戏下载，切割模拟器怎么重新开始