def showbooks():
'''
list_books = [{'bookid':id,'bookname':'<bookname>','nums':'1','remark':''}]
'''
page = int(request.args.get('page',1))
num = 10
pages = int(mydb.mysql('select count(*) from bookinfo;')[0][0])
total = pages
if total % num == 0:
pages = total / num
else:
pages = total / num +1
start_position = (page - 1)*num
res = mydb.mysql('select * from bookinfo limit %s,%s'%(start_position,num))
# res = mydb.mysql('select * from bookinfo;')
list_books = []
dict_books = {}
for i in res:
dict_books['bookid'] = i[0]
dict_books['bookname'] = i[1]
dict_books['nums'] = i[2]
dict_books['remark'] = i[3]
list_books.append(dict_books.copy())
return render_template("showbooks.html",list_books = list_books,pages=pages)
def showbooks():
'''
list_books = [{'bookid':id,'bookname':'<bookname>','nums':'1','remark':''}]
'''
page = int(request.args.get('page', 1))
num = 10
pages = int(mydb.mysql('select count(*) from bookinfo;')[0][0])
total = pages
if total % num == 0:
pages = total / num
else:
pages = total / num + 1
start_position = (page - 1) * num
res = mydb.mysql('select * from bookinfo limit %s,%s' %
(start_position, num))
# res = mydb.mysql('select * from bookinfo;')
list_books = []
dict_books = {}
for i in res:
dict_books['bookid'] = i[0]
dict_books['bookname'] = i[1]
dict_books['nums'] = i[2]
dict_books['remark'] = i[3]
list_books.append(dict_books.copy())
return render_template("showbooks.html",
list_books=list_books,
pages=pages)
def addbooks():
dict_del = request.args.items()
list_delbooks = zip(*dict_del)[0]
for i in list_delbooks:
old_nums = mydb.mysql("select * from bookinfo where id='%s'"%(i))[0][2]
old_nums = int(old_nums)
new_nums = old_nums + 1
new_nums = str(new_nums)
mydb.mysql("update bookinfo set nums='%s' where id='%s'"%(new_nums,i))
return redirect('/showbooks')
def addbooks():
dict_del = request.args.items()
list_delbooks = zip(*dict_del)[0]
for i in list_delbooks:
old_nums = mydb.mysql("select * from bookinfo where id='%s'" %
(i))[0][2]
old_nums = int(old_nums)
new_nums = old_nums + 1
new_nums = str(new_nums)
mydb.mysql("update bookinfo set nums='%s' where id='%s'" %
(new_nums, i))
return redirect('/showbooks')
def showbooks():
'''
list_books = [{'bookname':'<bookname>','nums':'1','remark':''}]
'''
res = mydb.mysql('select * from bookinfo;')
list_books = []
dict_books = {}
for i in res:
dict_books['bookname'] = i[0]
dict_books['nums'] = i[1]
dict_books['remark'] = i[2]
list_books.append(dict_books.copy())
return render_template("showbooks.html",list_books = list_books)
def loginin():
user = request.form.get('username')
passwd = request.form.get('password')
res = mydb.mysql("select * from user where username='******'" % (user))
if len(res) == 0:
str_alert = 'you are not in'
return render_template("login0.html")
else:
if passwd == str(res[0][1]):
return redirect('/showbooks')
else:
str_alert = 'wrong password!'
return render_template("login1.html")
def loginin():
user = request.form.get('username')
passwd = request.form.get('password')
res = mydb.mysql("select * from user where username='******'"%(user))
if len(res) == 0:
str_alert = 'you are not in'
return render_template("login0.html")
else:
if passwd == str(res[0][1]):
return redirect('/showbooks')
else:
str_alert = 'wrong password!'
return render_template("login1.html")
def showbooks():
'''
list_books = [{'bookname':'<bookname>','nums':'1','remark':''}]
'''
res = mydb.mysql('select * from bookinfo;')
list_books = []
dict_books = {}
for i in res:
dict_books['bookname'] = i[0]
dict_books['nums'] = i[1]
dict_books['remark'] = i[2]
list_books.append(dict_books.copy())
return render_template("showbooks.html", list_books=list_books)
def loginin():
user = request.args.get('username')
passwd = request.args.get('password')
# dict_user = {}
# with open("userdata","r") as f:
# for line in f:
# dict_user[line.split()[0]] = line.split()[1]
# if user in dict_user and dict_user[user] == passwd:
# return 'yes you are in!'
# if user not in dict_user:
# return 'You have not been signed!'
# if user in dict_user and dict_user[user] != passwd:
# return 'wrong password'
res = mydb.mysql("select * from user where username='******'"%(user))
if len(res) == 0:
str_alert = 'you are not in'
return render_template("login0.html")
else:
if passwd == str(res[0][1]):
return redirect('/showbooks')
else:
str_alert = 'wrong password!'
return render_template("login1.html")
def loginin():
user = request.args.get('username')
passwd = request.args.get('password')
# dict_user = {}
# with open("userdata","r") as f:
# for line in f:
# dict_user[line.split()[0]] = line.split()[1]
# if user in dict_user and dict_user[user] == passwd:
# return 'yes you are in!'
# if user not in dict_user:
# return 'You have not been signed!'
# if user in dict_user and dict_user[user] != passwd:
# return 'wrong password'
res = mydb.mysql("select * from user where username='******'" % (user))
if len(res) == 0:
str_alert = 'you are not in'
return render_template("login0.html")
else:
if passwd == str(res[0][1]):
return redirect('/showbooks')
else:
str_alert = 'wrong password!'
return render_template("login1.html")
