_sql := "select tid, bid, cover, title,limit_content,create_time,see,comment from blog where draft = '0' and title like CONCAT('%',?,'%') order by id desc limit ?,? "
// to do
rows, err := stmt.Query(title, (page-1)*FRONT_SIZE, FRONT_SIZE)
limit A, B: A是起始位置,等于(pageNum-1)*SIZE
, B为SIZE
(相当于步长)
实现前端分页API需要返回2个数据:
- 总页数
- 前端给定页数n,返回第n页的数据