flask paginate在一个页面上显示所有结果

a1o7rhls 于 2021-06-19 发布在 Mysql

关注(0)|答案(1)|浏览(500)

我正在尝试为产品页面设置分页，如下所示

from flask_paginate import Pagination, get_page_parameter

...

page = request.args.get(get_page_parameter(), type=int, default=1)

per_page = 4
offset = (page) * 10

search = False
q = request.args.get('q')
if q:
    search = True

pagination = Pagination(page=page, per_page=per_page, offset=offset, total=len(products), 
search=search, record_name='products')

return render_template('products.html', form=form, products=products, 
subcategories=subcategories, pagination=pagination)

而“产品”是从代码中的前一个请求获取的

cur.execute("SELECT * FROM products")
products = cur.fetchall()

然而，在我的产品页面上，我得到了数据库中的所有产品（目前有20个），而我可以看到 {{ pagination.info }} 显示“显示1-4个产品，共20个”。
也 {{ pagination.links }} 工作正常，因为它显示了功能分页链接，但所有产品仍在页面上可见。你有什么线索可以解决这个问题吗？
谢谢

sql mysql python flask pagination

来源：https://stackoverflow.com/questions/52935516/flask-paginate-is-showing-all-results-on-one-page

1条答案

按热度按时间

6rqinv9w1#

我找到了解决这个问题的办法。也许不是最好的，如果你知道更好的方法，请告诉我。目前，我已经通过以下方式解决了这个问题：


# Creating a cursor

cur = conn.cursor()

# Setting page, limit and offset variables

per_page = 4
page = request.args.get(get_page_parameter(), type=int, default=1)
offset = (page - 1) * per_page

# Executing a query to get the total number of products

cur.execute("SELECT * FROM products")
total = cur.fetchall()

# Executing a query with LIMIT and OFFSET provided by the variables above

cur.execute("SELECT * FROM products ORDER BY added_on DESC LIMIT %s OFFSET %s", (per_page, offset))
products = cur.fetchall()

# Closing cursor

cur.close()

...

# Setting up the pagination variable, where you are using len(total) to set the total number of

# items available

pagination = Pagination(page=page, per_page=per_page, offset=offset, total=len(total), 
record_name='products')

# Render template, where you pass "products" variable

# for the prepared query with LIMIT and OFFSET, and passing "pagination" variable as well.

return render_template('products.html', form=form, products=products, pagination=pagination)

赞(0）回复(0）举报 2021-06-19

我来回答

flask paginate在一个页面上显示所有结果

1条答案

相关问题

热门标签

最新问答