用 PHP和html做一个简单的注册页面
index.html的设计
<!DOCTYPE html>
<html lang="en">
<head><meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1.0"><title>Document</title>
</head>
<body><form action="./in.php" method="post" style="width:220px; margin:300px auto;">用户名：<input type="text" name="username" id="" ><br>密 码：<input type="password" name="password" id=""><br>年 龄：<input type="number" name="age" id=""><br>性 别：<select name="gender" id=""><option value="0">女</option><option value="1">男</option></select><br><input type="submit" name="" id=""></form>
</body>
</html>
in.php
<?php
header('content-type:text/html;charset=utf-8');
$host = "localhost";
$user = "root";
$pass = "";
$db = "mydb";
$mysqli = mysqli_connect($host, $user, $pass, $db);
if (mysqli_connect_errno()) {echo "连接失败" . mysqli_connect_error();
}
$mysqli->set_charset("utf8");//执行读取用户列表
select($mysqli);//注册
insert($mysqli);$mysqli->close();//自定义函数function
function insert($mysqli)
{$sql = "INSERT INTO demo(username,password,age,gender)VALUES(?,?,?,?)";$mysqli_stmt = $mysqli->prepare($sql);$username = $_POST["username"];$password = $_POST["password"];$age = $_POST["age"];$gender = $_POST["gender"];//ssii代表四个字符串，sii代表三个字符串$mysqli_stmt->bind_param("ssii", $username, $password, $age, $gender);if ($mysqli_stmt->execute()) {echo "编号".$mysqli_stmt->insert_id."注册成功";echo PHP_EOL;} else {echo "失败" . $mysqli_stmt->errno;}//释放结果集$mysqli_stmt->free_result();$mysqli_stmt->close();
};//自定义函数function
function select($mysqli)
{$sql = "SELECT uid,username,password,age,gender FROM demo";$mysqli_stmt = $mysqli->prepare($sql);$uid=null;$username = null;$password = null;$age = null;$gender = null;if ($mysqli_stmt->execute()) {$mysqli_stmt->bind_result($uid,$username, $password, $age, $gender);while ($mysqli_stmt->fetch()) {echo "编号" . $uid . "<br>";echo "姓名" . $username . "<br>";echo "密码" . $password . "<br>";echo "年龄" . $age . "<br>";$gender = $gender == 1 ? "男" : "女";echo "性别" . $gender . "<br>";}}else{echo"查询失败";}//释放结果集$mysqli_stmt->free_result();$mysqli_stmt->close();
};?>数据库的设计
DROP TABLE IF EXISTS `demo`;
CREATE TABLE IF NOT EXISTS `demo` (`uid` int NOT NULL AUTO_INCREMENT COMMENT '用户编号',`username` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '用户姓名',`password` varchar(18) COLLATE utf8mb4_bin NOT NULL COMMENT '用户密码',`age` int NOT NULL COMMENT '用户年龄',`gender` int NOT NULL COMMENT '用户性别',PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
效果
