你如何在 PHP 中实现分页?

2022-01-04 00:00:00 php resultset pagination

通常如何在 PHP 中实现分页结果?

How are paged results commonly implemented in PHP?

我想要一个包含 10 个结果的结果页面.在导航中向前翻页会给我下一组和上一组.

I'd like to have a results page with 10 results. Paging forward in the navigation would give me the next and previous sets.

有没有办法做到这一点?有人对入门有什么简单的建议吗?

Is there a way this is commonly done? Does anyone have simple advice on getting started?

推荐答案

您需要对 PHP 有一个初学者的了解,并且可能对关系数据库有一定的了解.

You'll need a beginner's understanding of PHP, and probably some understanding of relational databases.

分页通常使用一些简单的查询参数来实现.

Pagination is often implemented with some simple query parameters.

stackoverflow.com/myResults.php?page=1

页面增加查询参数:

stackoverflow.com/myResults.php?page=2

在后端,页面值通常对应于用于生成结果的查询中的限制和偏移量.

On the back end, the page value usually corresponds to the limits and offsets in the query that is being used to generate the results.

相关问题:

  • 没有 SQL 的 PHP 动态分页
  • 分页查询在 SQL Server 2005 中对不同列进行排序
  • 智能分页算法

相关文章