Flask/python登錄驗證對mysql不起作用，我在搜索google和文檔，我在同一件事上看到了一些關于堆棧溢出的問題，但還沒有得到回答。在from flask import Flask, render_template, flash, request, url_for, redirect, session

from content_management import Content

#form validations

from wtforms import Form, BooleanField, TextField, PasswordField, validators

#to encrypt the password

from passlib.hash import sha256_crypt

#for SQL injection

from MySQLdb import escape_string as thwart

import gc

from functools import wraps

from mysql_connect import connection

app = Flask(__name__)

@app.route('/login/', methods=['GET','POST'])

def login_page():

error = ''

try:

c, conn = connection()

if request.method == "POST":

d = c.execute("SELECT * FROM clients WHERE email = (%s)", (thwart(request.form['email']),))

d = c.fetchone()[2]

if request.form['password'] == d:

email = request.form['email']

c.execute("SELECT * FROM clients WHERE email = (%s)", (thwart(email),))

clients_table = c.fetchall()

clientcid = clients_table[0]

flash(clientcid)

phone = clients_table[1]

rating = clients_table[4]

conn.commit()

c.execute("SELECT * FROM cpersonals WHERE cid = (%s)", (clientcid,))

cpersonals_table = c.fetchall()

first_name = cpersonals_table[1]

last_name = cpersonals_table[2]

address = cpersonals_table[3]

czip = cpersonals_table[4]

reg_date = cpersonals_table[5]

conn.commit()

c.close()

conn.close()

session['logged_in'] = 'client'

session['clientcid'] = clientcid

session['email'] = email

session['phone'] = phone

session['rating'] = rating

session['first_name'] = first_name

session['last_name'] = last_name

session['address'] = address

session['czip'] = czip

session['reg_date'] = reg_date

flash("You are now logged in.")

return redirect(url_for("dashborad"))

else:

error = "Invalid credentials, try again."

return render_template("login.html")

在沒有框架的情況下，有沒有一種簡單的方法可以在MySQL中驗證憑證

總結

以上是生活随笔為你收集整理的mysql 凭证_如何用mysql验证flask/python中的凭证？的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。