How to use where method in thinkphp

In thinkphp, the where method is used to filter the results of database operations. It is one of the coherent operation methods of the model class. It can complete ordinary queries, expression queries, quick queries, interval queries, and combined queries. For query operations, the syntax is "instantiate object->where('condition');".

The operating environment of this article: Windows 10 system, ThinkPHP version 6, Dell G3 computer.

How to use the where method in thinkphp

The where method can be used to filter the results of database operations. That is, the where clause in the SQL query statement.

Today I will tell you about the most commonly used but also the most complex where method for querying. The where method is also one of the coherent operation methods of the model class and is mainly used for querying and setting operating conditions.

The usage of the where method is the essence of the ThinkPHP query language and an important part and highlight of the ThinkPHP ORM. It can complete queries including ordinary queries, expression queries, quick queries, interval queries, and combined queries. operate. The parameters of the where method support strings and arrays. Although objects can also be used, it is not recommended.

String conditions

Use string conditions to directly query and operate, for example:

$User = M("User"); // 实例化User对象
$User->where('type=1 AND status=1')->select();

The final generated SQL statement is

SELECT * FROM think_user WHERE type=1 AND status=1

If you use version 3.1 or above, when using string conditions, it is recommended to cooperate with the preprocessing mechanism to ensure more security, for example:

$Model->where("id=%d and username='%s' and
xx='%f'",array($id,$username,$xx))->select();

or use:

$Model->where("id=%d and username='%s' and xx='%f'",$id,$username,$xx)->select();

If the $id variable comes from If the user submits or URL address, if the input is a non-numeric type, it will be forcibly formatted into a numeric format before querying.

The string preprocessing format type supports specifying numbers, strings, etc. For details, please refer to the parameter description of the vsprintf method.

Array condition

The where usage of array condition is the usage recommended by ThinkPHP.

Normal query

The simplest array query method is as follows:

$User = M("User"); // 实例化User对象
$map['name'] = 'thinkphp';
$map['status'] = 1;
// 把查询条件传入查询方法
$User->where($map)->select();

The final generated SQL statement is

SELECT * FROM think_user WHERE `name`='thinkphp' AND status=1

Recommended learning: "PHP Video tutorial》

The above is the detailed content of How to use where method in thinkphp. For more information, please follow other related articles on the PHP Chinese website!