Python mysql_select Examples

Example #1

File: rebuildw06-v2.py Project: 51reboot/actual_06_homework

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'))

Example #2

File: rebuildw07.py Project: 51reboot/actual_06_homework

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"))

Example #3

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'))

Example #4

File: rebuildw06.py Project: 1401062808/actual_06_homework

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))

Example #5

File: rebuildw07.py Project: 51reboot/actual_06_homework

def index():
    sql_comm = "select uername,password from userinfo"
    return json.dumps(conn_db.mysql_select(sql_comm))

Example #6

File: rebuildw07.py Project: 51reboot/actual_06_homework

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"))

Example #7

def index():
    sql_comm = 'select * from userinfo'
    return render_template("index.html", data=conn_db.mysql_select(sql_comm))

Example #8

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'))

Example #9

File: rebuildw06.py Project: 51reboot/actual_06_homework

def index():
    sql_comm = 'select * from userinfo'
    return render_template("index.html",data=conn_db.mysql_select(sql_comm))

Example #10

File: rebuildw06.py Project: 1401062808/actual_06_homework

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))

Example #11

File: rebuildw07.py Project: 1401062808/actual_06_homework

def index():
    sql_comm = 'select uername,password from userinfo'
    return json.dumps(conn_db.mysql_select(sql_comm))