通用分頁函數 pagination(pagecount),輸出類似「首頁 前十頁 1 2 3 ... 10 後十頁 末頁」的導航列,支援 board_id 分類參數保留。
Function pagination(pagecount)
Dim wzpage, wzpagecount, pagenum, boardid
boardid = Request.QueryString("board_id")
If boardid = 0 Then boardid = 1
If Len(Request.QueryString("page")) <> 0 Then
wzpage = CLng(Request.QueryString("page"))
Else
wzpage = 1
End If
If wzpage <= 0 Then wzpage = 1
pagenum = (wzpage \ 10) * 10 + 1
If wzpage Mod 10 = 0 Then pagenum = (wzpage \ 10) * 10 - 9
' 首頁/前十頁
If wzpage > 10 Then
Response.Write ""
Response.Write "9"
Response.Write "7"
Response.Write ""
End If
' 頁碼 10 個一群
For pagenum = pagenum To pagenum + 9
If pagenum = wzpage Then
Response.Write " [" & pagenum & "] "
Else
Response.Write " [" & pagenum & "] "
End If
If pagenum >= pagecount Then Exit For
Next
' 後十頁/末頁
If wzpage < (pagecount - (pagecount Mod 10)) Then
Response.Write ""
Response.Write "8"
Response.Write ":"
Response.Write ""
End If
End Function
Dim wzcount, wzrep, wzpage, wzpagecount
wzrep = 30
wzcount = conn.Execute("SELECT COUNT(id) FROM `table1`")(0)
wzpagecount = Abs(Int(-Abs(wzcount / wzrep))) ' 向上取整
wzpage = CLng(Request.QueryString("page"))
If wzpage = 0 Then wzpage = 1
' 取得當頁資料
rs.Open "SELECT id, aaaa, bbbb, cccc FROM `table1` ORDER BY id DESC", conn, 1, 1
rs.AbsolutePosition = rs.AbsolutePosition + ((wzpage - 1) * wzrep)
' 迴圈輸出 wzrep 筆
For i = 0 To wzrep - 1
If rs.EOF Then Exit For
' ... 輸出欄位 ...
rs.MoveNext
Next
`table1` 為 MySQL 語法,Access/SQL Server 不支援,需依資料庫調整。AbsolutePosition 計算方式有誤,正確寫法:rs.AbsolutePage = wzpage 配合 rs.PageSize = wzrep。Response.Write,難以測試與復用,建議回傳 HTML 字串。LIMIT/OFFSET、ROW_NUMBER、OFFSET FETCH)。