5.5(web编程)

最新推荐文章于 2024-06-21 11:30:02 发布

基尼胎没Plus

最新推荐文章于 2024-06-21 11:30:02 发布

阅读量15

点赞数

文章标签： android

本文链接：https://blog.csdn.net/qq_64161784/article/details/133625738

版权

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="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);
?>

基尼胎没Plus

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
1
评论
5.5(web编程)

用户名：</label><label for="password">密码：</label><label for="age">年龄：</label><label for="education">学历：请选择学历</option><option value="高中及以下">高中及以下
复制链接

扫一扫