Table of Contents
回复内容:
Home Backend Development PHP Tutorial php、mysql怎么对特别大的数据量进行分页

php、mysql怎么对特别大的数据量进行分页

Jun 06, 2016 pm 08:22 PM
mysql php

php怎么对特别大的数据量进行分页

回复内容:

php怎么对特别大的数据量进行分页

一般分页写法是:

1

2

<code>SELECT * FROM posts ORDER BY id DESC LIMIT $page_size OFFSET $offset

</code>

Copy after login

不过当$offset很大时,速度会比较慢.

这时可以尝试使用"上一页"和"下一页"进行分页,比如:
60-41(上一页) 40-21(当前页) 20-01(下一页)
下一页(旧文章20篇):

1

2

<code>//page.php?id=-21 负数表示下一页旧文章 这里的21表示当前页最下面的文章的ID.

SELECT * FROM posts WHERE id </code>

Copy after login

上一页(新文章20篇):

1

2

3

<code>//page.php?id=40  正数表示上一页新文章 这里的40表示当前页最上面的文章的ID.

SELECT * FROM posts WHERE id &gt; 40 ORDER BY id ASC  LIMIT 20;

</code>

Copy after login

得到的是升序ID序列,PHP使用array_reverse反转数组实现降序输出.

觉得负数不好看的话,可以额外加一个参数,比如:
page.php?action=next&id=21
page.php?action=prev&id=40

上面说了一个解决方案,我再说一个 延迟关联查询。

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian Dec 24, 2024 pm 04:42 PM

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian

CakePHP Date and Time CakePHP Date and Time Sep 10, 2024 pm 05:27 PM

CakePHP Date and Time

CakePHP Project Configuration CakePHP Project Configuration Sep 10, 2024 pm 05:25 PM

CakePHP Project Configuration

CakePHP File upload CakePHP File upload Sep 10, 2024 pm 05:27 PM

CakePHP File upload

CakePHP Routing CakePHP Routing Sep 10, 2024 pm 05:25 PM

CakePHP Routing

Discuss CakePHP Discuss CakePHP Sep 10, 2024 pm 05:28 PM

Discuss CakePHP

How to fix mysql_native_password not loaded errors on MySQL 8.4 How to fix mysql_native_password not loaded errors on MySQL 8.4 Dec 09, 2024 am 11:42 AM

How to fix mysql_native_password not loaded errors on MySQL 8.4

CakePHP Quick Guide CakePHP Quick Guide Sep 10, 2024 pm 05:27 PM

CakePHP Quick Guide

See all articles