用php+mysql写一个完成的登录注册界面代码
时间: 2024-05-01 17:21:16 浏览: 10
以下是一个简单的登录注册界面的PHP+MySQL代码,包含了基本的注册和登录功能,可以根据自己的需要进行修改和添加。
index.php:
```php
<!DOCTYPE html>
<html>
<head>
<title>Login & Registration System</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="style.css">
</head>
<body>
<div class="container">
<div class="header">
<h2>Login & Registration System</h2>
</div>
<<div class="content">
<form method="post" action="login.php">
<h2>Login</h2>
<?php if(isset($_GET['login_error'])) { ?>
<p class="error">Invalid username or password!</p>
<?php } ?>
<div class="input-group">
<label>Username:</label>
<input type="text" name="username">
</div>
<div class="input-group">
<label>Password:</label>
<input type="password" name="password">
</div>
<div class="input-group">
<button type="submit" class="btn" name="login_user">Login</button>
</div>
</form>
<form method="post" action="register.php">
<h2>Register</h2>
<?php if(isset($_GET['reg_error'])) { ?>
<p class="error">Username already exists!</p>
<?php } ?>
<div class="input-group">
<label>Username:</label>
<input type="text" name="username">
</div>
<div class="input-group">
<label>Email:</label>
<input type="email" name="email">
</div>
<div class="input-group">
<label>Password:</label>
<input type="password" name="password_1">
</div>
<div class="input-group">
<label>Confirm Password:</label>
<input type="password" name="password_2">
</div>
<div class="input-group">
<button type="submit" class="btn" name="reg_user">Register</button>
</div>
</form>
</div>
</div>
</body>
</html>
```
login.php:
```php
<?php
session_start();
include('db.php');
if(isset($_POST['login_user'])) {
$username = mysqli_real_escape_string($conn, $_POST['username']);
$password = mysqli_real_escape_string($conn, $_POST['password']);
$password = md5($password);
$query = "SELECT * FROM users WHERE username='$username' AND password='$password'";
$result = mysqli_query($conn, $query);
if(mysqli_num_rows($result) == 1) {
$_SESSION['username'] = $username;
header('location: welcome.php');
} else {
header('location: index.php?login_error=1');
}
}
?>
```
register.php:
```php
<?php
session_start();
include('db.php');
if(isset($_POST['reg_user'])) {
$username = mysqli_real_escape_string($conn, $_POST['username']);
$email = mysqli_real_escape_string($conn, $_POST['email']);
$password_1 = mysqli_real_escape_string($conn, $_POST['password_1']);
$password_2 = mysqli_real_escape_string($conn, $_POST['password_2']);
$query = "SELECT * FROM users WHERE username='$username'";
$result = mysqli_query($conn, $query);
if(mysqli_num_rows($result) == 0) {
if($password_1 == $password_2) {
$password_1 = md5($password_1);
$query = "INSERT INTO users (username, email, password) VALUES ('$username', '$email', '$password_1')";
mysqli_query($conn, $query);
$_SESSION['username'] = $username;
header('location: welcome.php');
} else {
header('location: index.php?reg_error=1');
}
} else {
header('location: index.php?reg_error=1');
}
}
?>
```
db.php:
```php
<?php
$conn = mysqli_connect('localhost', 'username', 'password', 'database_name');
if(!$conn) {
die('Error connecting to database: ' . mysqli_connect_error());
}
?>
```
style.css:
```css
body {
font-family: Arial, sans-serif;
background-color: #f1f1f1;
}
.container {
margin: 100px auto;
width: 500px;
background-color: #fff;
padding: 20px;
border-radius: 10px;
box-shadow: 0px 0px 10px rgba(0,0,0,0.5);
}
.header {
text-align: center;
margin-bottom: 20px;
}
h2 {
margin-bottom: 10px;
}
.content {
display: flex;
justify-content: space-between;
}
form {
width: 45%;
}
.input-group {
margin: 10px 0px;
}
label {
display: block;
margin-bottom: 5px;
}
input[type="text"], input[type="email"], input[type="password"] {
width: 100%;
padding: 5px;
border: none;
border-radius: 5px;
background-color: #f1f1f1;
}
.btn {
display: block;
padding: 10px;
background-color: #4CAF50;
color: #fff;
border: none;
border-radius: 5px;
cursor: pointer;
}
.btn:hover {
background-color: #3e8e41;
}
.error {
color: red;
margin: 10px 0px;
}
```