html+php+mysql登陸注冊
时间: 2023-12-23 16:26:12 浏览: 99
以下是一个简单的HTML+PHP+MySQL登录注册的示例:
1. HTML页面代码(login.html):
```html
<!DOCTYPE html>
<html>
<head>
<title>Login Page</title>
</head>
<body>
<h2>Login Form</h2>
<form action="login.php" method="post">
<label>Username:</label><br>
<input type="text" name="username" required><br>
<label>Password:</label><br>
<input type="password" name="password" required><br><br>
<input type="submit" value="Login">
</form>
<br>
<a href="register.html">Register</a>
</body>
</html>
```
2. HTML页面代码(register.html):
```html
<!DOCTYPE html>
<html>
<head>
<title>Registration Page</title>
</head>
<body>
<h2>Registration Form</h2>
<form action="register.php" method="post">
<label>Username:</label><br>
<input type="text" name="username" required><br>
<label>Password:</label><br>
<input type="password" name="password" required><br><br>
<input type="submit" value="Register">
</form>
<br>
<a href="login.html">Login</a>
</body>
</html>
```
3. PHP代码(login.php):
```php
<?php
session_start();
if(isset($_POST['username']) && isset($_POST['password'])){
$username = $_POST['username'];
$password = $_POST['password'];
$conn = mysqli_connect('localhost', 'root', '', 'testdb');
if(!$conn){
die("Connection failed: " . mysqli_connect_error());
}
$sql = "SELECT * FROM users WHERE username='$username' AND password='$password'";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) == 1){
$_SESSION['username'] = $username;
header("Location: home.php");
}else{
echo "Invalid username or password";
}
}
?>
```
4. PHP代码(register.php):
```php
<?php
if(isset($_POST['username']) && isset($_POST['password'])){
$username = $_POST['username'];
$password = $_POST['password'];
$conn = mysqli_connect('localhost', 'root', '', 'testdb');
if(!$conn){
die("Connection failed: " . mysqli_connect_error());
}
$sql = "INSERT INTO users (username, password) VALUES ('$username', '$password')";
if(mysqli_query($conn, $sql)){
header("Location: login.html");
}else{
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
?>
```
5. PHP代码(home.php):
```php
<?php
session_start();
if(isset($_SESSION['username'])){
echo "Welcome " . $_SESSION['username'] . "!<br>";
echo "<a href='logout.php'>Logout</a>";
}else{
header("Location: login.html");
}
?>
```
6. PHP代码(logout.php):
```php
<?php
session_start();
session_unset();
session_destroy();
header("Location: login.html");
?>
```
以上代码实现了一个简单的登录注册系统,用户可以在登录页面输入用户名和密码进行登录,也可以在注册页面进行注册。登录成功后,用户将被重定向到主页(home.php),并显示欢迎消息和注销链接。用户注销后,将被重定向到登录页面。
阅读全文
相关推荐
![-](https://img-home.csdnimg.cn/images/20241231044955.png)
![-](https://img-home.csdnimg.cn/images/20241231044937.png)
![-](https://img-home.csdnimg.cn/images/20241231045053.png)
![application/x-rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![pdf](https://img-home.csdnimg.cn/images/20241231044930.png)
![application/x-rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20241231044955.png)
![rar](https://img-home.csdnimg.cn/images/20241231044955.png)
![rar](https://img-home.csdnimg.cn/images/20241231044955.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![rar](https://img-home.csdnimg.cn/images/20241231044955.png)
![rar](https://img-home.csdnimg.cn/images/20241231044955.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![rar](https://img-home.csdnimg.cn/images/20241231044955.png)
![application/x-rar](https://img-home.csdnimg.cn/images/20210720083606.png)