<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>信息添加</title>
</head>
<body>
<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="boy">男
<input type="radio" name="sex" value="girl">女</td>
</tr>
<tr>
<td>班级</td>
<td><input type="text" name="class"></td>
</tr>
<tr>
<td><input type="submit" value="添加"></td><td><input type="reset" value="重置"></td>
</tr>
<tr>
<td><a href="index.php">返回</a></td>
</tr>
</table>
</form>
</body>
</html>
<?php
$db=@mysqli_connect('1127.0.0.1','root','root','root','3306');
if($db){
exit("数据库连接错误：".mysqli_connect_error());
}
switch ($_GET['action']){
case 'add':
$name=$_POST['name'];
$sex=$_POST['sex'];
$age=$_POST['age'];
$class=$_POST['class'];
$sql="INSERT INTO `stu`(name,sex,age,class) VALUES('{$name}','{$sex}','{$age}','{$class}');";
$return=mysqli_query($db,$sql);
if($return){
echo "<script>alert('添加成功')</script>";
}else{
echo "<script>alert('添加失败')</script>";
}
header('Location:index.php');
break;
}
