flask render_template mariadb 如何做翻頁(pagination)功能

woff

google查了不少文章

發現mariadb 翻頁(pagination)功能 沒人寫
只好土法煉鋼自己寫一個


展示：

flask render_template mariadb 翻頁功能 pagination

admin_view.py內寫入

1. from app.pagination import pageft
   
2. 
   
3. @app.route("/admin/company",methods=['GET','POST'])
   
4. def admin_company():
   
5. 
   
6. conn = check_db_connection()
   
7. # create a connection cursor
   
8. # execute a SQL statement
   
9. cursor = conn.cursor(dictionary=True)
   
10. 
    
11. count_sql = "select * from net_company"
    
12. cursor.execute(count_sql)
    
13. total = len(cursor.fetchall())
    
14. 
    
15. page_num = request.args.get('page', 1, type=int) #抓取初始頁數
    
16. firstcount = 1 # 初始計數
    
17. displaypg = 3 # 每頁顯示幾筆
    
18. 
    
19. if firstcount < 0 :
    
20. firstcount = 1
    
21. elif page_num==1:
    
22. firstcount = 1
    
23. else:
    
24. firstcount = firstcount*page_num+1
    
25. # pageft(初始計數, 總筆數, 每頁顯示幾筆, url_for(def路徑))
    
26. page_nav = pageft(firstcount, total, displaypg, "admin_company")
    
27. 
    
28. sql = "SELECT * FROM net_company ORDER BY num ASC limit "+str(firstcount)+","+str(displaypg)
    
29. 
    
30. cursor.execute(sql)
    
31. result = cursor.fetchall()
    
32. sm_companys = []
    
33. for rows in result:
    
34. sm_companys.append({"id": rows['id'], "num": rows['num'],"subject": rows['subject']})
    
35. 
    
36. return render_template("admin/company.html", status="show",companys = sm_companys,page_num=page_num, page_nav=page_nav)

複製代碼

建立 pagination.py

1. from flask import request,url_for
   
2. from math import ceil
   
3. 
   
4. def pageft(firstcount,total,displaypg = 20,url=""):
   
5.     if request.args.get('page')== None:
   
6.         page = 1
   
7.     else:
   
8.         page = int(request.args.get('page'))
   
9.     if page<=0:
   
10.         page=1
    
11.     lastpg = ceil(total /displaypg) # 最後頁，也是總頁數
    
12. 
    
13.     if page == 1: # 上一頁
    
14.         prepg=1
    
15.     else :
    
16.         prepg = page - 1
    
17. 
    
18.     if page == lastpg : # 下一頁
    
19.         nextpg = page
    
20.     else:
    
21.         nextpg = page + 1
    
22. 
    
23.     if page==1:
    
24.         firstcount = 1
    
25.         nextcount = 1 * displaypg
    
26.     else:
    
27.         firstcount = (page-1) * displaypg+1
    
28.         nextcount = page * displaypg
    
29. 
    
30.     pagenav = "顯示 <B>"+ str(firstcount)  +"</B>-<B>"+ str(min(nextcount ,total)) +"</B> 筆記錄，共 "+str(total)+" 筆"
    
31. 
    
32.     if lastpg <= 1:
    
33.         return False
    
34. 
    
35.     pagenav += " <a href='"+ url_for(url) +"?page=1'>頁首</a> "
    
36.     if prepg:
    
37.         pagenav += " <a href='"+url_for(url)+"?page="+str(prepg)+"'>上一頁</a> "
    
38.     else:
    
39.         pagenav += " <a href='"+url_for(url)+"?page="+str(prepg)+"'>上一頁</a> "
    
40.     if nextpg :
    
41.         pagenav += " <a href='"+url_for(url)+"?page="+ str(nextpg)+"'>下一頁</a>"
    
42.     else:
    
43.         pagenav += " <a href='"+url_for(url)+"?page="+ str(nextpg)+"'>下一頁</a>"
    
44.     pagenav +=" <a href='"+url_for(url)+"?page="+str(lastpg)+"'>頁尾</a> "
    
45.     print("pagenav:",pagenav)
    
46. 
    
47.     pagenav += "　到第 <select onchange = "window.location.href=this.value" >\n"
    
48.     for i in range(lastpg):
    
49.         if i+1 == page:
    
50.             pagenav +="<option value='"+url_for(url)+"?page="+str(i+1)+"' selected>"+str(i+1)+"</option>\n"
    
51.         else:
    
52.             pagenav +="<option value='"+url_for(url)+"?page="+str(i+1)+"'>"+str(i+1)+"</option>\n"
    
53. 
    
54.     pagenav += "</select> 頁，共 "+str(lastpg)+" 頁";
    
55.     return pagenav

複製代碼

company.html 加入

1. {% if page_nav %}
   
2.     <div style="ruby-align: center">{{page_nav | safe}}</div>
   
3.     {% endif %}

複製代碼

完成

文章出處： NetYea 網頁設計, 慧晟數位科技, 網站架設

參考文章
https://stackoverflow.com/questi ... rts-to-first-option