21,886
社区成员
发帖
与我相关
我的任务
分享
index.php 获取用户信息的表单
<!DOCTYPE html>
<html>
<head>
<title>学生管理系统</title>
<meta charset="utf-8"/>
</head>
<body>
<center>
<h2>学生管理系统</h2>
<a href='index.php'>添加信息</a> |
<a href='show.php'>查看信息</a>
<hr/>
<h3>添加信息表单</h3>
<form action="doAction.php?a=insert" method="post">
姓名:<input type="text" name="uname" value=""/><br/><br/>
性别:<input type="radio" name="usex" value="w"/> 女
<input type="radio" name="usex" value="m"/> 男<br/><br/>
年龄:<input type="text" name="uage" value=""/><br/><br/>
手机:<input type="text" name="uphone" value=""/><br/><br/>
邮箱:<input type="email" name="uemail" value=""/><br/><br/>
婚否:<input type="radio" name="uhunfou" value="y"/> 已婚
<input type="radio" name="uhunfou" value="n"/> 未婚<br/><br/>
Q Q:<input type="text" name="uqq" value=""/><br/><br/>
小组:<input type="text" name="uteam" value=""/><br/><br/>
<input type="submit" value="提交"/>
<input type="reset" value="重置"/>
</form>
</center>
</body>
</html>
doAction.php 将用户信息存储到数据库中
<?php
//根据用户的动作,执行相应的操作
//1. 连接服务器,并判断是否成功
$link = mysqli_connect("localhost","root","") or die("连接数据库失败!");
//2. 设置字符集
mysqli_set_charset($link,"utf8");
//3. 选择数据库
mysqli_select_db($link,"lamp165");
switch($_GET['a']){
case "insert": //用户添加操作
//4. 定义sql语句,并发送执行
//获取用户提交的信息
$uname = $_POST['uname'];
$usex = $_POST['usex'];
$uage = $_POST['uage'];
$uphone = $_POST['uphone'];
$uemail = $_POST['uemail'];
$uhunfou = $_POST['uhunfou'];
$uqq = $_POST['uqq'];
$uteam = $_POST['uteam'];
$sql = "insert into stu (name,sex,age,phone,email,hunfou,qq,team) values
('{$uname}','{$usex}',{$uage},'{$uphone}','{$uemail}','{$uhunfou}','{$uqq}','{$uteam}')";
$boolean = mysqli_query($link,$sql);
//5. 判断是否执行成功
if($boolean!=false && mysqli_affected_rows($link)>0){
//告诉用户添加成功
echo "<script>alert('恭喜你,添加成功!');window.location.href='show.php'</script>";
}else{
//告诉用户添加失败
echo "<script>alert('很抱歉,添加失败!');window.location.href='index.php'</script>";
die;
}
//6. 关闭数据库
mysqli_close($link);
break;
case "update": //执行学生信息修改
//获取要修改信息的学生的id号
$id = $_GET['id'];
//获取用户修改后的数据
$uname = $_POST['uname'];
$usex = $_POST['usex'];
$uage = $_POST['uage'];
$uphone = $_POST['uphone'];
$uemail = $_POST['uemail'];
$uhunfou = $_POST['uhunfou'];
$uqq = $_POST['uqq'];
$uteam = $_POST['uteam'];
//定义sql语句,并发送执行
$sql = "update stu set name='{$uname}',sex='{$usex}',age={$uage},phone='{$uphone}',email='{$uemail}',hunfou='{$uhunfou}',qq='{$uqq}',team='{$uteam}' where id={$id}";
$boolean = mysqli_query($link,$sql);
//判断是否修改成功
if($boolean!=false && mysqli_affected_rows($link)>0){
//告知用户,修改成功
echo "<script>alert('恭喜,修改成功!');window.location.href='{$_SERVER['HTTP_REFERER']}'</script>";
}else{
//告知用户,修改失败!
echo "<script>alert('恭喜,修改失败!');window.location.href='{$_SERVER['HTTP_REFERER']}'</script>";
}
break;
case "delete": //执行用户删除的动作
//获取要删除的用户的id
$id = $_GET['id'];
//定义sql语句,并发送执行
$sql = "delete from stu where id={$id}";
$boolean = mysqli_query($link,$sql);
//判断是否删除成功
if($boolean!=false && mysqli_affected_rows($link)>0){
//告知用户,删除成功
echo "<script>alert('恭喜,删除成功!');window.location.href='{$_SERVER['HTTP_REFERER']}'</script>";
}else{
//告知用户,删除失败
echo "<script>alert('恭喜,删除失败!');window.location.href='{$_SERVER['HTTP_REFERER']}'</script>";
}
break;
}
?>