php使用mysql实现注册登录代码
时间: 2023-10-26 20:07:42 浏览: 69
好的,以下是一个基于PHP和MySQL的简单注册登录代码示例:
注册页面(register.php):
```
<!DOCTYPE html>
<html>
<head>
<title>注册</title>
</head>
<body>
<h1>注册</h1>
<form method="post" action="register.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>
<input type="submit" value="注册">
</form>
</body>
</html>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
// 连接数据库
$db_host = 'localhost';
$db_user = 'root';
$db_password = '';
$db_name = 'mydatabase';
$conn = mysqli_connect($db_host, $db_user, $db_password, $db_name);
if (!$conn) {
die('数据库连接失败:' . mysqli_connect_error());
}
// 获取表单数据
$username = $_POST['username'];
$password = $_POST['password'];
// 检查用户名是否已存在
$sql = "SELECT * FROM users WHERE username='$username'";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
echo '该用户名已被注册,请选择其他用户名!';
exit;
}
// 将用户信息插入数据库
$sql = "INSERT INTO users (username, password) VALUES ('$username', '$password')";
if (mysqli_query($conn, $sql)) {
echo '注册成功!';
} else {
echo '注册失败:' . mysqli_error($conn);
}
mysqli_close($conn);
}
?>
```
登录页面(login.php):
```
<!DOCTYPE html>
<html>
<head>
<title>登录</title>
</head>
<body>
<h1>登录</h1>
<form method="post" action="login.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>
<input type="submit" value="登录">
</form>
</body>
</html>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
// 连接数据库
$db_host = 'localhost';
$db_user = 'root';
$db_password = '';
$db_name = 'mydatabase';
$conn = mysqli_connect($db_host, $db_user, $db_password, $db_name);
if (!$conn) {
die('数据库连接失败:' . mysqli_connect_error());
}
// 获取表单数据
$username = $_POST['username'];
$password = $_POST['password'];
// 检查用户名和密码是否匹配
$sql = "SELECT * FROM users WHERE username='$username' AND password='$password'";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
echo '登录成功!';
} else {
echo '用户名或密码错误,请重新输入!';
}
mysqli_close($conn);
}
?>
```
请注意,这只是一个简单的示例,实际应用中需要更多的安全性和错误处理。