user.php
-----------------------------------------------------------------------
<!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 method="POST" action="0.php">
<label for="username">用户名:</label>
<input type="text" id="username" name="username" required><br>
<label for="password">密码:</label>
<input type="password" id="password" name="password" required><br>
<label for="age">年龄:</label>
<input type="number" id="age" name="age" min="18" max="100" required><br>
<label for="education">学历:</label>
<select id="education" name="education" required>
<option value="">请选择学历</option>
<option value="高中及以下">高中及以下</option>
<option value="大专">大专</option>
<option value="本科">本科</option>
<option value="硕士">硕士</option>
<option value="博士及以上">博士及以上</option>
</select><br>
<input type="submit" value="ok">
</form>
<?php
// 创建连接
$con = mysqli_connect("localhost", "root", "root","用户系统");
// 检查连接是否成功
if (!$con) {
die("连接失败: " . mysqli_connect_error());
}
// $username = $_POST['username'];
// $password = $_POST['password'];
// $age = $_POST['age'];
// $education = $_POST['education'];
// // 准备SQL语句
// $sql = "INSERT INTO 用户表 (用户名, 密码,年龄,学历) VALUES ('$username', '$password', '$age', '$education')";
// mysqli_query($conn, $sql);
echo "<h2>显示数据</h2>";
$result = mysqli_query($con, "select * from 用户表");
echo "<table border='1' cellpadding='20' cellspacing='0'>";
// 输出表头
echo "<tr>";
while ($fieldinfo = mysqli_fetch_field($result)) {
echo "<th>" . $fieldinfo->name . "</th>";
}
echo "</tr>";
// 输出每一行数据
while ($row = mysqli_fetch_array($result)) {
echo "<tr>";
for ($i = 0; $i < mysqli_num_fields($result); $i++) {
echo "<td>" . $row[$i] . "</td>";
}
echo "</tr>";
}
echo "</table>";
mysqli_close($con);
?>
</body>
</html>
0.php
-----------------------------------------
<?php
// 创建连接
$con = mysqli_connect("localhost", "root", "root","用户系统");
// 检查连接是否成功
if (!$con) {
die("连接失败: " . mysqli_connect_error());
}
$username = $_POST['username'];
$password = $_POST['password'];
$age = $_POST['age'];
$education = $_POST['education'];
// 准备SQL语句
$sql = "INSERT INTO 用户表 (用户名, 密码,年龄,学历) VALUES ('$username', '$password', '$age', '$education')";
mysqli_query($con, $sql);
mysqli_close($con);
?>