摘要:<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>信息添加</title>
<!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;
}
批改老师:查无此人批改时间:2019-05-08 09:03:57
老师总结:完成的不错。$db=@mysqli_connect('1127.0.0.1','root','root','root','3306'); ip多了个1,继续加油