How to query by name in thinkphp

In thinkphp, you can query by name by fuzzy querying the LIKE keyword. The implementation code is such as "$data['name']=array('LIKE','%Cheng Huan%');$ arr= $m->where($data)->select();var_dump($arr);", this statement means to query the information of people whose names contain "Cheng Huan".

#The operating environment of this tutorial: Windows 10 system, thinkphp version 5, Dell G3 computer.

How to query by name in thinkphp?

表达式查询方式 GT--大于 LT---小于 EQ---等于 EGT---大于等于 ELT----小于等于 NEQ---不等于 //不区分大小写 LIKE---模糊查询 ONTLIKE---查询不匹配的

Fuzzy query LIKE keyword

• Query information about people whose names contain "Cheng Huan"

$data['name']=array( 'LIKE','%程欢%'); $arr= $m->where($data)->select(); var_dump($arr);

• Query information about people whose names do not contain "Cheng Huan"

$data['name']=array( 'NOTLIKE','%程欢%'); // N OTLIKE中间不能有空格 $arr= $m->where($data)->select(); var_dump($arr);

• Multi-condition fuzzy matching

Query the information of persons whose names contain "Cheng Huan" or whose names contain "王" //The default is or relationship

$data['name']=array( 'LIKE',array('%程欢%','%王%')); $arr= $m->where($data)->select(); var_dump($arr);

Query the names whose names contain "Cheng Huan" And the information of the person whose name contains "王"

$data['name']=array( 'LIKE',array('%程欢%','%王%'),'and'); $arr= $m->where($data)->select(); var_dump($arr);

Recommended study: "thinkPHP Video Tutorial"

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