????:<!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("數(shù)據(jù)庫連接錯(cuò)誤:".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
???? ??:完成的不錯(cuò)。$db=@mysqli_connect('1127.0.0.1','root','root','root','3306'); ip多了個(gè)1,繼續(xù)加油