Shulou(Shulou.com)06/03 Report--

This article mainly explains "the specific usage of limit method in ThinkPHP". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "the specific usage of limit method in ThinkPHP".

The limit method of the ThinkPHP CURD method is also one of the coherent operation methods of the model class, which is mainly used to specify the number of queries and operations, especially in paging queries. And ThinkPHP's limit method is compatible with all database-driven classes.

Its specific usage is as follows:

1. Limit the number of results:

For example, you can obtain 10 users who meet the requirements, such as calling:

$User = M ('User'); $User- > where (' status=1')-> field ('id,name')-> limit (10)-> select ()

The limit method can also be used for write operations, such as updating 3 pieces of data that meet the requirements:

$User = M ('User'); $User- > where (' score=100')-> limit (3)-> save (array ('level'= > A'))

two。 Paging query:

Paging queries for articles are commonly used in limit methods, such as:

$Article = M ('Article'); $Article- > limit (' 102.25')-> select ()

Represents query article data, 25 pieces of data starting at line 10 (which may also depend on where conditions and the impact of order sorting, not to mention).

After version 3.1, you can also use it like this:

$Article = M ('Article'); $Article- > limit (102.25)-> select ()

In addition, for large data tables, try to use limit to limit the query results, otherwise it will cause great memory overhead and performance problems.

Thank you for your reading, the above is the content of "specific usage of limit method in ThinkPHP". After the study of this article, I believe you have a deeper understanding of the specific usage of limit method in ThinkPHP, and the specific use needs to be verified by practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.