功能：
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>
系统环境变量path=C:\php 5. 使 php.ini 文件在 Windows下被 PHP 所用 系统环... phpMyAdmin并不是必需的,只是为了方便管理MySQL数据库,本身是用PHP编写而成.http://www.skycn.com/soft/13703.html AppServ V2.5.9AppServ 是 PHP 网页架站工具组合包，泰国的作者将一些网路上免费的架站资源重新包装成单一的安装程序，以方便初学者快速完成架站，AppServ 所包含的软件有：Apache、Apache Monitor、PHP、MySQL、PHP-Nuke、phpMyAdmin。 PHP 5.0.1 Apache 1.3.31 MySQL 4.0.20 Zend Optimizer 2.5.3 phpMyAdmin 2.6.0-rc1 Perl 5.8.4 这是本地配置PPHP一键盘安装包
Discuz! 6.1.0下载地址http://www.comsenz.com/downloads/install
Discuz! 6.1.0 拿这个来说把，一般大家购买的空间FTP目录里有个是WWW目录然后下载Discuz! 6.1.0上传/httpdocs目录，何必你的地址是http://www.discuz.net/那就http://www.discuz.net/install直接安装就可以了 PHP需要mysql空间 一定要在空间商那里把mysql账号和密码要来 安装任何一个开源的PHP都需要MYSQL账号和密码的
欢迎分享，转载请注明来源：内存溢出
微信扫一扫
支付宝扫一扫
评论列表（0条）