完成注册功能
- js文件: onclick函数return True时才提交表单,return False时不提交表单。
- html文件:
- <form>中设置 action和method="post"
- <input> 中设置 name
- 主py文件中:
- from flask import request, redirect, url_for
- @app.route('/regist/', methods=['GET', 'POST’])
def regist():
if request.method == 'GET':
return render_template('regist.html')
else:
username = request.form.get(‘username’)#获取form中的数据
判断用户名是否存在:存在报错
不存在,存到数据库中
redirect重定向到登录页
from flask import Flask,request,render_template,redirect,url_for from flask_sqlalchemy import SQLAlchemy import config from functools import wraps from datetime import datetime app = Flask(__name__) app.config.from_object(config) db=SQLAlchemy(app) class User(db.Model): __tablename__='user' id=db.Column(db.Integer,primary_key=True,autoincrement=True) username = db.Column(db.String(20), nullable=False) password = db.Column(db.String(20), nullable=False) nickname = db.Column(db.String(50)) #db.create_all() #增加数据 #user=User(username = 'shanshan1',password = '111111') #db.session.add(user) #db.session.commit() #查询数据 #user=User.query.filter(user.username == 'shanshan1').first() #print(user.id,user.username,user.password) #修改数据 #user=User.query.filter(user.username == 'shanshan3').first() #user.password = '0000' #db.session.commit() #删除数据 #user=User.query.filter(user.username == 'shanshan3').first() #db.session.delete(user) #db.session.commit() @app.route('/') def index(): return render_template('shouye.html') @app.route( '/manhua') def manhua(): return render_template('manhua.html') @app.route('/login') def login(): return render_template('denglu.html') @app.route("/register",methods=['GET','POST']) def register(): if request.method == 'GET': return render_template("zhuce.html") else: name = request.form.get('name') passw = request.form.get('password') user = User.query.filter(User.username == name).first() if user: return "用户名已存在!" else: user = User(username=name, password=passw) db.session.add(user) db.session.commit() return render_template("denglu.html") if __name__ == '__main__': app.run(debug=True)
SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://root:@localhost:3306/mis_db?charset=utf8' SQLALCHEMY_TRACK_MODIFICATIONS = False
{% extends'shouye.html' %} {% block title %} register {% endblock %} {% block head %} <link rel="stylesheet"type="text/css"href="../static/css/zhuce.css"> <script src="../static/js/zhuce.js"></script> {% endblock %} {% block main %} <body> <div class="b1" > <form action="{{ url_for("register") }}" method="post"> <div class="s1" ><h3>注册/ENROLL </h3></div> <div class="b2" > 请输入账号: <input id="name" type="text" placeholder="write down your name" name="name"><br> 请输入密码: <input id="password" type="password" placeholder="write down your PIN" name="password"><br> 再输入密码: <input id="password2" type="password" placeholder="write down your PIN" name="password2"><br> </div> <div id="error_box"><br></div> <div class="s2" > <button onclick="myLogin()">注册</button> <button type="button" onclick=window.alert("是否取消注册")>取消</button> <label for="remember_me" style="padding: 0;">Remember me?</label> <input type="checkbox" id="remember_me" style="position: relative; top: 3px; margin: 0; " name="remember_me"/> <div class="design"> <p>Design by ss</p> </div> </div> </form> </div> </body> {% endblock %}