我正在尝试使用mysql连接使用flask进行简单的登录应用我运行登录功能
这是代码:
from flask import Flask, flash, redirect, render_template, request, session, abort
import os
from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine
from flask_sqlalchemy import SQLAlchemy
from flask_mysqldb import MySQL
from wtforms import Form, StringField, TextAreaField, PasswordField, validators
from passlib.hash import sha256_crypt
from functools import wraps
app = Flask(__name__)
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_DB'] = 'admin'
app.config['MYSQL_PORT'] = 3306
app.config['MYSQL_CURSORCLASS'] = 'DictCursor'
# init MYSQL
mysql = MySQL(app)
@app.route('/')
def home():
if not session.get('logged_in'):
return render_template('login.html')
else:
return "Hello Boss!"
@app.route('/login', methods=['POST'])
def do_admin_login():
cur = mysql.connection.cursor()
POST_USERNAME = str(request.form['username'])
POST_PASSWORD = str(request.form['password'])
result = cur.execute("SELECT * FROM users WHERE username = %s", [POST_USERNAME])
if result:
session['logged_in'] = True
cur.close()
else:
flash('wrong password!')
return home()
@app.route('/logout')
def logout():
session['logged_in']=False
return home()
if __name__ == "__main__":
app.secret_key = os.urandom(12)
app.run(debug=True)
图像中的错误
我已经解决了它。在我使用错误的端口号时,我从xampp向导窗口中检查了正确的端口。其次,我有一个错误的表名称