功能：
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
/**
* 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>
<h2>学生管理系统</h2>
<a href="index.php">浏览学生</a>
<a href="add.php">添加学生</a>
<hr>
</body>
</html>
学生社团管理系统摘要设计一个基于 PHP + MYSQL + windows 7 下的 Apache 服务器搭建而成 的学生社团管理系统,采用 B/W/S(Browser/Web/Server)结构。http://wenku.baidu.com/link?url=lrw7kZXkHkgBSIrlLEFN5nnvBAkDoqbvZBHLcC_XGvqL6Y-F_9c5Y_-74nHy9HoN-N8weuHW3j_o-bJ8ISvWmXxwaAt0cEv6s0QnTRPaGOO
这个不是一两句话能说清楚的，也不清楚你现在水平在什么位置。不过我说一下，需要的技术和方法步骤。
首先，你要会html css 最好还会javascript
然后是php mysql
这五种最基本的技术。
然后：
1.先用html+css写好你程序用到的网站界面。
2.设计数据库，比如 学生表，课程表，班级表，教师表等等
3.用php写后台，如登陆后台，之后就是对数据库增删改查。
欢迎分享，转载请注明来源：内存溢出
微信扫一扫
支付宝扫一扫
评论列表（0条）