def add(): user = request.args.get('user') pwd = request.args.get('pwd') sql_comm = 'select username from userinfo where username ="******"' %(user) user_exist = conn_db.mysql_select(sql_comm) if not user or not pwd: return '<p>need user and pwd</p>'+redirect(url_for('index')) elif user_exist: return '<p>user exist</p>'+redirect(url_for('index')) else: sql_comm = 'insert into userinfo(username,password) values("%s","%s")' %(user,pwd) conn_db.mysql_select(sql_comm) return redirect(url_for('index'))
def add(): user = request.args.get("user") pwd = request.args.get("pwd") sql_comm = 'select username from userinfo where username ="******"' % (user) user_exist = conn_db.mysql_select(sql_comm) if not user or not pwd: # <p>需要改到index中显示 return "<p>need user and pwd</p>" + redirect(url_for("index")) elif user_exist: return "<p>user exist</p>" + redirect(url_for("index")) else: sql_comm = 'insert into userinfo(username,password) values("%s","%s")' % (user, pwd) conn_db.mysql_select(sql_comm) return redirect(url_for("index"))
def add(): user = request.args.get('user') pwd = request.args.get('pwd') sql_comm = 'select username from userinfo where username ="******"' % (user) user_exist = conn_db.mysql_select(sql_comm) if not user or not pwd: return '<p>need user and pwd</p>' + redirect(url_for('index')) elif user_exist: return '<p>user exist</p>' + redirect(url_for('index')) else: sql_comm = 'insert into userinfo(username,password) values("%s","%s")' % ( user, pwd) conn_db.mysql_select(sql_comm) return redirect(url_for('index'))
def add(): user = request.args.get('user') pwd = request.args.get('pwd') sql_comm = 'select username from userinfo where username ="******"' %(user) user_exist = conn_db.mysql_select(sql_comm) if not user or not pwd: sql_comm = 'select * from userinfo' return '<p>need user and pwd</p>'+render_template("index.html",data=conn_db.mysql_select(sql_comm)) elif user_exist: sql_comm = 'select * from userinfo' return '<p>user exist</p>'+render_template("index.html",data=conn_db.mysql_select(sql_comm)) else: sql_comm = 'insert into userinfo(username,password) values("%s","%s")' %(user,pwd) conn_db.mysql_select(sql_comm) sql_comm = 'select * from userinfo' return render_template("index.html",data=conn_db.mysql_select(sql_comm))
def index(): sql_comm = "select uername,password from userinfo" return json.dumps(conn_db.mysql_select(sql_comm))
def delete(): user = request.args.get("user") sql_comm = 'delete from userinfo where username="******"' % (user) conn_db.mysql_select(sql_comm) return redirect(url_for("index"))
def index(): sql_comm = 'select * from userinfo' return render_template("index.html", data=conn_db.mysql_select(sql_comm))
def delete(): user = request.args.get('user') sql_comm = 'delete from userinfo where username="******"' % (user) conn_db.mysql_select(sql_comm) return redirect(url_for('index'))
def index(): sql_comm = 'select * from userinfo' return render_template("index.html",data=conn_db.mysql_select(sql_comm))
def delete(): user = request.args.get('user') sql_comm='delete from userinfo where username="******"' %(user) conn_db.mysql_select(sql_comm) sql_comm = 'select * from userinfo' return render_template("index.html",data=conn_db.mysql_select(sql_comm))
def index(): sql_comm = 'select uername,password from userinfo' return json.dumps(conn_db.mysql_select(sql_comm))