完成注册功能
- 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重定向到登录页
mis1114.py:
from flask import Flask,render_template,redirect,request,url_for from flask_sqlalchemy import SQLAlchemy import config 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(20)) @app.route('/') def base(): return render_template('base.html') @app.route('/home/') def home(): return render_template('shouye.html') @app.route('/sign_in/') def sign_in(): return render_template('login.html') @app.route('/sign_up/',methods=['GET','POST']) def sign_up(): if request.method == 'GET': return render_template('register.html') else: usern = request.form.get('username') nickn = request.form.get('nickname') passw = request.form.get('password') user = User.query.filter(User.username == usern).first() if user: return '用户名已存在。' else: user1 = User(username=usern, password=passw, nickname=nickn) db.session.add(user1) db.session.commit() return redirect(url_for('login')) @app.route('/question/') def question(): return render_template('question.html') if __name__ == '__main__': app.run(debug=True)
config.py:
SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://root:@127.0.0.1:3306/mis_db?charset=utf8' SQLALCHEMY_TRACK_MODIFICATIONS = False
register.html:
{% extends'base.html' %} {% block title %} register {% endblock %} {% block head %} <link rel="stylesheet" href="{{ url_for('static',filename='css/register css.css')}}"> <script src="{{ url_for('static',filename='js/register js.js') }}"></script> {% endblock %} {% block main %} <body> <div class="login"> <h1>Register</h1> <form action="{{url_for('sign_up')}}" method="post"> <h3>请输入用户名:</h3> <input id="uname" type="text" placeholder="用户名" name="username"> <br> <h3>设置密码:</h3> <input id="upass1" type="password" placeholder="密码" name="password"> <br> <h3>重新输入密码:</h3> <input id="upass2" type="password" placeholder="再次输入密码" required/> <br> <h3>输入手机号码:</h3> <input id="unumber" type="text" placeholder="手机号码" name="phone number"> <p class="submit"><input type="button" name="sent" value="注册" onclick="myLogin()"></p> <div id="error_box"><br></div> </form> </div> <div class="copyright"> <p>Copyright © 2017. Created by <a href="#" target="_blank">071</a></p> </div> </body> {% endblock %}
register js.js:
function myLogin() { var oUname=document.getElementById("uname"); var oPass1=document.getElementById("upass1"); var oPass2=document.getElementById("upass2"); var oError=document.getElementById("error_box"); oError.innerHTML="<br>"; //username if(oUname.value.length<6||oUname.value.length>20){ oError.innerHTML="username must be 6-20."; return false; }else if((oUname.value.charCodeAt(0)>=48)&&(oUname.value.charCodeAt(0)<=57)){ oError.innerHTML="firt name can't numbuter."; return false; }else{ for(var i=0;i<oUname.value.length;i++){ if((oUname.value.charCodeAt(i)<48||oUname.value.charCodeAt(i)>57)&&(oUname.value.charCodeAt(i)<97||oUname.value.charCodeAt(i)>122)){ oError.innerHTML="only number and letter"; return false; } } } //password if(oPass1.value.length<6||oPass2.value.length>20){ oError.innerHTML="password must be 6-20."; return false; }else if(oPass1.value != oPass2.value){ oError.innerHTML="The password input is inconsistent"; return false; } return true; }