How to implement query counting function in thinkphp5

1. Query

In ThinkPHP5, we can query the database through the Db class or the Model class Make an inquiry. Here we take the Model class as an example.

1. Basic query

We can implement basic query operations through the select() method, as follows:

//创建模型对象
$user = new UserModel();
//查询user表中姓名为张三的记录
$result = $user -> where('name','张三') -> select();

In the above code, the where() method is used to specify the query conditions, and its parameter format is where (query field, query value). When the query conditions are multiple fields, we can use chain operations.

is as follows:

$user -> where('name','张三') -> where('age',20) -> select();

This means querying the records in the user table whose name is Zhang San and whose age is 20.

2. Conditional query

We can add where(), whereOr()# to the query statement ##, whereLike() and other conditional query methods to achieve more flexible query operations.

//查询user表中年龄大于20，且性别为男的记录
$result = $user -> where('age','>',20) -> where('gender','男') -> select();
//查询user表中年龄小于20或性别为女的记录
$result = $user -> where(&#39;age&#39;,&#39;<&#39;,20) -> whereOr(&#39;gender&#39;,&#39;女&#39;) -> select();
//查询user表中姓名包含‘张’的记录
$result = $user -> whereLike(&#39;name&#39;,&#39;%张%&#39;) -> select();

where() method and the whereOr() method respectively indicate that the query conditions are "and" and The "or" relationship has the same parameter format; the whereLike() method is used to implement fuzzy query, and its second parameter represents the query matching condition.

order() to sort the query results, as follows:

$result = $user -> where('age','>',20) -> order('age desc') -> select();

3. Paging query

limit() method to implement paging query. limit()The method has two parameters. The first parameter indicates the starting offset, and the second parameter indicates the number of records displayed on each page.

// 每页显示3条记录，查询第2页的数据
$result = $user -> limit(3,3) -> select();

2. Counting

count() method.

//计算user表中记录总数
$count = $user -> count();
//计算user表中年龄大于20的记录数
$count = $user -> where('age','>',20) -> count();

count() method actually performs a query on the database, so in actual applications, errors should be minimized as much as possible. Necessary counting operations to improve application performance.

The above is the detailed content of How to implement query counting function in thinkphp5. For more information, please follow other related articles on the PHP Chinese website!