How does Laravel elegantly build database query conditions, like ThinkPHP?

Laravel database query condition construction: an elegant solution comparable to ThinkPHP

Flexible construction of database query conditions is the key to efficient data operation. This article will demonstrate how to elegantly build query conditions containing various comparison operators (such as >, in, like) in the Laravel framework, just like ThinkPHP. ThinkPHP uses array method to pass in where method, which is simple and efficient. Although Laravel does not directly provide the same array syntax, its chain calling method can also achieve more flexible and readable conditional construction.

In the ThinkPHP example, the array $map is used to define complex query conditions, including multiple comparison operators. Laravel uses the where method and its variants ( whereIn , whereLike , etc.) to achieve similar functions. Each method corresponds to a comparison operator, combining multiple conditions through chain calls.

The following Laravel code reproduces the $map array logic in the ThinkPHP example:

 $model = User::query();
$str = 'liling';
$model->where('status', 1); // equivalent to status = 1
$model->where('age', '>', 18); // Equivalent to age > 18
$model->whereIn('type', [1, 2, 3]); // equivalent to type IN (1, 2, 3)
$model->where('name', 'like', "%{$str}%"); // equivalent to name LIKE '%liling%'
$result = $model->get(); // Get the result set, use ->paginate() to achieve pagination

This code uses Laravel's chain call to clearly construct complex query conditions. Each where method corresponds to a condition, selects the appropriate comparison operator, and finally achieves the same query effect as the ThinkPHP example. This object-oriented style of code is easier to read and maintain.

The above is the detailed content of How does Laravel elegantly build database query conditions, like ThinkPHP?. For more information, please follow other related articles on the PHP Chinese website!