sl = 11
fn = ''
ln = ''
dpt = ''
u_id = ''
eml = ''
pwd = ''
rl = ''
# Create your views here.

def signaction(request):
    global fn, ln, dpt, u_id, eml, pwd, rl, sl

    if request.method == "POST":
        m = sql.connect(host="localhost", user="root", passwd="12345", database="maindb")
        cursor = m.cursor()
        d = request.POST
        for key, value in d.items():
            if key == "first_name":
                fn = value
            if key == "last_name":
                ln = value
            if key == "dept":
                dpt = value
            if key == "id_number":
                u_id = value
            if key == "email":
                eml = value
            if key == "password":
                pwd = value
            if key == "role":
                rl = value

        c = "insert into users values('{}','{}','{}','{}','{}','{}','{}','{}')".format(sl, fn, ln, dpt, u_id, eml, pwd, rl)
        sl = sl+1
        cursor.execute(c)
        m.commit()

    return render(request, 'signup_page.html')