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

woff

google查了不少文章

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


展示：

flask render_template mariadb 翻頁功能 pagination

admin_view.py內寫入

1. from app.pagination import pageft
   
2. from math import ceil
   
3. 
   
4. # 秀出所有紀錄
   
5.     count_sql = "select * from net_class"
   
6.     cursor.execute(count_sql)
   
7.     total = len(cursor.fetchall())
   
8. 
   
9.     page_num = request.args.get('page', 1, type=int) #抓取初始頁數
   
10.     firstcount = 1 # 初始計數
    
11.     displaypg = 10 # 每頁顯示幾筆
    
12.     lastpg = ceil(total / displaypg)
    
13. 
    
14.     if page_num == 1:
    
15.         firstcount = 0
    
16.     elif page_num == lastpg:
    
17.         firstcount = firstcount * page_num + 1
    
18.         displaypg = total % displaypg
    
19.     else:
    
20.         firstcount = firstcount*page_num+1
    
21.              # pageft(初始計數, 總筆數, 每頁顯示幾筆, url_for(def路徑))
    
22.     page_nav = pageft(firstcount, total, displaypg, "admin_class")
    
23. 
    
24.     sql = "SELECT * FROM net_class ORDER BY num ASC limit "+str(firstcount)+","+str(displaypg)
    
25.     print("sql:",sql)
    
26. 
    
27.     cursor.execute(sql)
    
28.     result = cursor.fetchall()

複製代碼

建立 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.         firstcount = 1
    
16.         nextcount = 1 * displaypg
    
17.         nextpg = page + 1
    
18.     elif page == lastpg:
    
19.         firstcount = (page-1) * displaypg+1
    
20.         nextcount = total
    
21.         nextpg = page
    
22.         prepg = page - 1
    
23.     else:
    
24.         firstcount = (page-1) * displaypg+1
    
25.         nextcount = page * displaypg
    
26.         prepg = page - 1
    
27.         nextpg = page + 1
    
28. 
    
29.     pagenav = "顯示 <B>"+ str(firstcount)  +"</B>-<B>"+ str(min(nextcount ,total)) +"</B> 筆記錄，共 "+str(total)+" 筆"
    
30. 
    
31.     if lastpg <= 1:
    
32.         return False
    
33. 
    
34.     pagenav += " <a href='"+ url_for(url) +"?page=1'>頁首</a> "
    
35.     if prepg:
    
36.         pagenav += " <a href='"+url_for(url)+"?page="+str(prepg)+"'>上一頁</a> "
    
37.     else:
    
38.         pagenav += " <a href='"+url_for(url)+"?page="+str(prepg)+"'>上一頁</a> "
    
39.     if nextpg :
    
40.         pagenav += " <a href='"+url_for(url)+"?page="+ str(nextpg)+"'>下一頁</a>"
    
41.     else:
    
42.         pagenav += " <a href='"+url_for(url)+"?page="+ str(nextpg)+"'>下一頁</a>"
    
43.     pagenav +=" <a href='"+url_for(url)+"?page="+str(lastpg)+"'>頁尾</a> "
    
44.     print("pagenav:",pagenav)
    
45. 
    
46.     pagenav += "　到第 <select onchange = "window.location.href=this.value" >\n"
    
47.     for i in range(lastpg):
    
48.         if i+1 == page:
    
49.             pagenav +="<option value='"+url_for(url)+"?page="+str(i+1)+"' selected>"+str(i+1)+"</option>\n"
    
50.         else:
    
51.             pagenav +="<option value='"+url_for(url)+"?page="+str(i+1)+"'>"+str(i+1)+"</option>\n"
    
52. 
    
53.     pagenav += "</select> 頁，共 "+str(lastpg)+" 頁";
    
54.     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