Let's talk about query code in thinkphp

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;

// 设置每页显示的记录数
$perPage = 10;

// 获取总记录数
$total = Db::name('user')->count();

// 创建分页器对象
$paginator = new Paginator($total, $perPage);

// 获取分页数据
$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'); // 返回结果是一个浮点数

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'); // 返回结果是一个整数

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!