thinkphp implements like fuzzy query example
This article mainly introduces the implementation of like fuzzy query in thinkphp. It uses examples to describe the implementation method of like fuzzy query in string form and array form as query conditions. It is a very practical skill. Friends who need it can refer to it.
The example in this article describes how thinkphp implements like fuzzy query, and shares it with you for your reference. The specific implementation method is as follows:
Currently, more and more people are using the thinkphp framework for project development. Due to its good encapsulation, many parts of pure PHP development are not easy to get started. The examples in this article are blurred with like Query is an example to illustrate this.
Here we mainly use examples to illustrate usage:
ThinkPHP can support the direct use of strings as query conditions, but in most cases it is recommended to use index arrays or objects as query conditions, because it will be safer .
1. Use strings as query conditions
This is the most traditional method, but it is not very safe.
For example:
Copy code The code is as follows:
$User = M("User"); // 实例化User对象
$User->where('type=1 AND status=1')->select();The final generated SQL statement is
Copy code The code is as follows:
SELECT * FROM think_user WHERE type=1 AND status=1
If you perform a multi-field query, then the fields The default logical relationship between them is logical AND AND, but the default logical judgment can be changed using the following rules, by using _logic to define query logic:
Copy code The code is as follows:
$User = M("User"); // 实例化User对象
$condition['name'] = 'thinkphp';
$condition['account'] = 'thinkphp';
$condition['_logic'] = 'OR';
// 把查询条件传入查询方法
$User->where($condition)->select();The final generated SQL statement is
Copy code The code is as follows:
SELECT * FROM think_user WHERE `name`='thinkphp' OR `account`='thinkphp'
2. Array mode as query condition
As mentioned How to implement so many like queries? Let’s see below
Copy code The code is as follows:
$userForm=M('user'); $where['name']=array('like','php%'); $userForm->where($where)->select();
The like query here is:
Copy code The code is as follows:
name like 'php%'
Query statement:
Copy code The code is as follows:
$where['name']=array('like',array('%php%','%.com'),'OR');
The like query here is:
Copy code The code is as follows:
name like '%php%' or name like '%.com'
Query statement:
Copy code The code is as follows:
$where['name']=array(array('like','%a%'),array('like','%b%'),array('like','%c%'),'php','or');
The like query here is:
Copy code The code is as follows:
(`name` LIKE '%a%') OR (`name` LIKE '%b%') OR (`name` LIKE '%c%') OR (`name` = 'php')
Query statement:
Copy code Code As follows:
$where['_string']='(name like "%php%") OR (title like "%php")';
The like query here is:
Copy code The code is as follows:
name like '%jb51%' or title like '%php'
Related recommendations:
thinkphp implements 163, QQ mailbox method of sending and receiving emails_php skills
ThinkPHP basic add, delete, check and modify operation example tutorial
The above is the detailed content of thinkphp implements like fuzzy query example. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to run thinkphp project
Apr 09, 2024 pm 05:33 PM
To run the ThinkPHP project, you need to: install Composer; use Composer to create the project; enter the project directory and execute php bin/console serve; visit http://localhost:8000 to view the welcome page.
There are several versions of thinkphp
Apr 09, 2024 pm 06:09 PM
ThinkPHP has multiple versions designed for different PHP versions. Major versions include 3.2, 5.0, 5.1, and 6.0, while minor versions are used to fix bugs and provide new features. The latest stable version is ThinkPHP 6.0.16. When choosing a version, consider the PHP version, feature requirements, and community support. It is recommended to use the latest stable version for best performance and support.
12306 How to check historical ticket purchase records How to check historical ticket purchase records
Mar 28, 2024 pm 03:11 PM
Download the latest version of 12306 ticket booking app. It is a travel ticket purchasing software that everyone is very satisfied with. It is very convenient to go wherever you want. There are many ticket sources provided in the software. You only need to pass real-name authentication to purchase tickets online. All users You can easily buy travel tickets and air tickets and enjoy different discounts. You can also start booking reservations in advance to grab tickets. You can book hotels or special car transfers. With it, you can go where you want to go and buy tickets with one click. Traveling is simpler and more convenient, making everyone's travel experience more comfortable. Now the editor details it online Provides 12306 users with a way to view historical ticket purchase records. 1. Open Railway 12306, click My in the lower right corner, and click My Order 2. Click Paid on the order page. 3. On the paid page
How to check your academic qualifications on Xuexin.com
Mar 28, 2024 pm 04:31 PM
How to check my academic qualifications on Xuexin.com? You can check your academic qualifications on Xuexin.com, but many users don’t know how to check their academic qualifications on Xuexin.com. Next, the editor brings you a graphic tutorial on how to check your academic qualifications on Xuexin.com. Interested users come and take a look! Xuexin.com usage tutorial: How to check your academic qualifications on Xuexin.com 1. Xuexin.com entrance: https://www.chsi.com.cn/ 2. Website query: Step 1: Click on the Xuexin.com address above to enter the homepage Click [Education Query]; Step 2: On the latest webpage, click [Query] as shown by the arrow in the figure below; Step 3: Then click [Login Academic Credit File] on the new page; Step 4: On the login page Enter the information and click [Login];
How to run thinkphp
Apr 09, 2024 pm 05:39 PM
Steps to run ThinkPHP Framework locally: Download and unzip ThinkPHP Framework to a local directory. Create a virtual host (optional) pointing to the ThinkPHP root directory. Configure database connection parameters. Start the web server. Initialize the ThinkPHP application. Access the ThinkPHP application URL and run it.
Which one is better, laravel or thinkphp?
Apr 09, 2024 pm 03:18 PM
Performance comparison of Laravel and ThinkPHP frameworks: ThinkPHP generally performs better than Laravel, focusing on optimization and caching. Laravel performs well, but for complex applications, ThinkPHP may be a better fit.
Comparison of similarities and differences between MySQL and PL/SQL
Mar 16, 2024 am 11:15 AM
MySQL and PL/SQL are two different database management systems, representing the characteristics of relational databases and procedural languages respectively. This article will compare the similarities and differences between MySQL and PL/SQL, with specific code examples to illustrate. MySQL is a popular relational database management system that uses Structured Query Language (SQL) to manage and operate databases. PL/SQL is a procedural language unique to Oracle database and is used to write database objects such as stored procedures, triggers and functions. same
How to install thinkphp
Apr 09, 2024 pm 05:42 PM
ThinkPHP installation steps: Prepare PHP, Composer, and MySQL environments. Create projects using Composer. Install the ThinkPHP framework and dependencies. Configure database connection. Generate application code. Launch the application and visit http://localhost:8000.
