ThinkPHP is an excellent PHP framework based on the MVC development model. It uses excellent technologies such as ORM and template engines during the development process, which greatly improves development efficiency and code quality. During the development process, we often need to query records in the database. This article will introduce the query code in ThinkPHP.

1. Querying a single record

Querying a single record is a code we often use and can be implemented using the find() method. The find() method returns a model object, which we can directly operate on.

For example, we want to query the record with id 1 in the user table. The code is as follows:

$user?=?UserModel::where('id',?1)->find();

Among them, UserModel is the user model class we defined, where('id', 1)Specifies query conditions, find() means querying only one record.

2. Querying multiple records

It is also very convenient to query multiple records. We can use the select() method to achieve this. The select() method returns a data set object, which can also be operated directly.

For example, we want to query all the records in the user table. The code is as follows:

$users?=?UserModel::select();

Among them, UserModel is the user model class we defined. If we do not specify the query conditions, By default, all records are queried.

We can also specify query conditions, for example, query all records with id greater than 1:

$users?=?UserModel::where('id',?'>',?1)->select();

In addition, we can also call the query method in a chain, for example, query all records with id greater than 1 in the user table 1 record with status 1:

$users?=?UserModel::where('id',?'>',?1)->where('status',?1)->select();

3. Query specified fields

Sometimes we only need the values ??of certain fields when querying, then we can use The field() method specifies the query field.

For example, we only need to query the id and name fields of all users in the user table. The code is as follows:

$users?=?UserModel::field('id,name')->select();

4. Paging query

When the amount of data When it is large, we need to paginate the query results to improve page loading speed and user experience. ThinkPHP provides easySwoole/easySwoole/pagination components, which are convenient and easy to use.

For example, we need to query the data of all users in the user table and use easySwoole/easySwoole/pagination for paging. The code is as follows:

use?think\facade\Db;
use?easySwoole\pagination\Paginator;

//?設(shè)置每頁(yè)顯示的記錄數(shù)
$perPage?=?10;

//?獲取總記錄數(shù)
$total?=?Db::name('user')->count();

//?創(chuàng)建分頁(yè)器對(duì)象
$paginator?=?new?Paginator($total,?$perPage);

//?獲取分頁(yè)數(shù)據(jù)
$users?=?Db::name('user')
????->limit($paginator->getLimit())
????->page($paginator->getCurrentPage())
????->select();

Among them, limit() and page() methods are used to limit the query range and query the data of the specified page. The getLimit() and getCurrentPage() methods are used to obtain the current pager's status information.

5. Aggregation Query

When querying, sometimes you need to aggregate the query results, such as average, maximum, minimum, etc. In ThinkPHP, we can use aggregate functions to achieve this.

For example, query the average age of all users in the user table:

use?think\facade\Db;

$avgAge?=?Db::name('user')->avg('age');?//?返回結(jié)果是一個(gè)浮點(diǎn)數(shù)

You can also use aggregate functions to perform conditional queries, such as querying the maximum value of the age field:

use?think\facade\Db;

$maxAge?=?Db::name('user')->where('status',?1)->max('age');?//?返回結(jié)果是一個(gè)整數(shù)

The above are the query codes commonly used in ThinkPHP. I hope it will be helpful to you.

The above is the detailed content of Let's talk about query code in thinkphp. For more information, please follow other related articles on the PHP Chinese website!