系统环境变量path=C:php 5. 使 php.ini 文件在 Windows下被 PHP 所用 系统环... phpMyAdmin并不是必需的,只是为了方便管理MySQL数据库,本身是用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=del&id='+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
//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>
<h2>学生管理系统</h2>
<a href="index.php">浏览学生</a>
<a href="add.php">添加学生</a>
<hr>
</body>
</html>
前几天刚实现了一个,难点主要有3块:
1:http头部模拟
2:在使用curl做POST的时候, 当要POST的数据大于1024字节的时候, curl并不会直接就发起POST请求, 而是会分为俩步,
http://www.laruence.com/2011/01/20/1840.html
3:post的数据,有几个字段是用js计算出的,需要用php模拟出
附:curl_setopt($ch,CURLOPT_POSTFIELDS, http_build_query($data))
以上就是关于如何运行php教材管理系统源码全部的内容,如果了解更多相关内容,可以关注,你们的支持是我们更新的动力!
版权声明:我们致力于保护作者版权,注重分享,被刊用文章【php教务管理系统源码】因无法核实真实出处,未能及时与作者取得联系,或有版权异议的,请联系管理员,我们会立即处理! 部分文章是来自自研大数据AI进行生成,内容摘自(百度百科,百度知道,头条百科,中国民法典,刑法,牛津词典,新华词典,汉语词典,国家院校,科普平台)等数据,内容仅供学习参考,不准确地方联系删除处理!;
工作时间:8:00-18:00
客服电话
电子邮件
beimuxi@protonmail.com
扫码二维码
获取最新动态