| 12345678910111213141516171819202122232425262728293031323334353637383940414243 |
- import pymysql
- from app import app
- from db_config import mysql
- from flask import jsonify, request, render_template
-
- @app.route('/user_check', methods=['POST'])
- def username_check():
- conn = None
- cursor = None
- try:
- username = request.form['username']
-
- # validate the received values
- if username and request.method == 'POST':
- conn = mysql.connect()
- cursor = conn.cursor(pymysql.cursors.DictCursor)
- cursor.execute("SELECT * FROM user WHERE login_username=%s", username)
- row = cursor.fetchone()
-
- if row:
- resp = jsonify('<span style=\'color:red;\'>Username unavailable</span>')
- resp.status_code = 200
- return resp
- else:
- resp = jsonify('<span style=\'color:green;\'>Username available</span>')
- resp.status_code = 200
- return resp
- else:
- resp = jsonify('<span style=\'color:red;\'>Username is required field.</span>')
- resp.status_code = 200
- return resp
- except Exception as e:
- print(e)
- finally:
- cursor.close()
- conn.close()
-
- @app.route('/')
- def home():
- return render_template('username.html')
-
- if __name__ == "__main__":
- app.run()
|
