用python实现一个简单的登录注册页面
时间: 2023-12-28 19:03:30 浏览: 31
好的,以下是一个简单的登录注册页面的实现,使用Python Flask框架和MySQL数据库:
1. 首先,安装Flask和MySQL模块:
```
pip install flask
pip install flask-mysql
```
2. 创建一个名为“app.py”的文件,并添加以下代码:
```python
from flask import Flask, render_template, request, redirect, url_for
from flask_mysqldb import MySQL
app = Flask(__name__)
# MySQL配置
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSWORD'] = 'password'
app.config['MYSQL_DB'] = 'mydatabase'
mysql = MySQL(app)
# 首页
@app.route('/')
def index():
return render_template('index.html')
# 注册页面
@app.route('/register', methods=['GET', 'POST'])
def register():
if request.method == 'POST':
# 获取表单数据
username = request.form['username']
password = request.form['password']
# 检查用户是否已经存在
cur = mysql.connection.cursor()
cur.execute("SELECT * FROM users WHERE username = %s", [username])
user = cur.fetchone()
cur.close()
if user:
return "用户名已经存在!"
else:
# 插入用户信息到数据库
cur = mysql.connection.cursor()
cur.execute("INSERT INTO users(username, password) VALUES(%s, %s)", (username, password))
mysql.connection.commit()
cur.close()
return redirect(url_for('login'))
else:
return render_template('register.html')
# 登录页面
@app.route('/login', methods=['GET', 'POST'])
def login():
if request.method == 'POST':
# 获取表单数据
username = request.form['username']
password = request.form['password']
# 检查用户是否存在
cur = mysql.connection.cursor()
cur.execute("SELECT * FROM users WHERE username = %s AND password = %s", (username, password))
user = cur.fetchone()
cur.close()
if user:
return redirect(url_for('dashboard'))
else:
return "用户名或密码错误!"
else:
return render_template('login.html')
# 用户仪表板页面
@app.route('/dashboard')
def dashboard():
return "欢迎来到用户仪表板!"
if __name__ == '__main__':
app.run(debug=True)
```
3. 在项目文件夹中创建一个名为“templates”的文件夹,并添加以下HTML模板文件:
- index.html
```html
<!DOCTYPE html>
<html>
<head>
<title>登录注册页面</title>
</head>
<body>
<h1>欢迎来到我的登录注册页面</h1>
<a href="/register">注册</a> | <a href="/login">登录</a>
</body>
</html>
```
- register.html
```html
<!DOCTYPE html>
<html>
<head>
<title>注册页面</title>
</head>
<body>
<h1>注册</h1>
<form method="POST" action="/register">
<label>用户名:</label><input type="text" name="username"><br>
<label>密码:</label><input type="password" name="password"><br>
<input type="submit" value="注册">
</form>
</body>
</html>
```
- login.html
```html
<!DOCTYPE html>
<html>
<head>
<title>登录页面</title>
</head>
<body>
<h1>登录</h1>
<form method="POST" action="/login">
<label>用户名:</label><input type="text" name="username"><br>
<label>密码:</label><input type="password" name="password"><br>
<input type="submit" value="登录">
</form>
</body>
</html>
```
4. 创建一个名为“mydatabase”的MySQL数据库,并在其中创建一个名为“users”的表格:
```sql
CREATE DATABASE mydatabase;
USE mydatabase;
CREATE TABLE users (
id INT(11) NOT NULL AUTO_INCREMENT,
username VARCHAR(50) NOT NULL,
password VARCHAR(50) NOT NULL,
PRIMARY KEY (id)
);
```
5. 运行应用程序:
```
python app.py
```
现在你可以在浏览器中访问http://localhost:5000来查看你的登录注册页面。