How to query data in thinkphp framework

1. Basic query

In the ThinkPHP framework, you can use the find, select, where, order and other methods of the model class to perform basic query operations.

(1)find method

The find method is used to query a data record, and can be queried directly based on the primary key. For example:

$user = UserModel::find(1);

The above code will query the user record with ID 1 from the UserModel model class.

(2) select method

The select method can be used to retrieve multiple data records, and can be restricted and sorted using methods such as where and order. For example:

$list = UserModel::where('age', '>', 18)->order('id desc')->select();

The above code will query all user records older than 18 years old from the UserModel model class, and sort them in reverse order by ID.

(3) where method

The where method is used to set conditions and can be used for basic queries and statistical queries. For example:

$count = UserModel::where('gender', 1)->count();

The above code will count the number of male users in the UserModel model class.

(4) order method

The order method is used to set the sorting. For example:

$list = UserModel::order('id desc')->select();

The above code will query all user records from the UserModel model class and sort them in reverse order by ID.

2. Advanced query

In addition to basic query operations, the ThinkPHP framework also provides powerful advanced query functions, including multi-table query, join table query, and statistical query wait.

(1) Multi-table query

In multi-table query, multiple model classes need to be used. For example:

$list = UserModel::alias('u')->join('order o', 'u.id = o.user_id')->where('u.age', '>', 18)->select();

The above code will query all users older than 18 years old and their order records from the UserModel and OrderModel model classes.

(2) Joined table query

Joint table query is one form of multi-table query. Use the join method of ThinkPHP to operate:

$list = UserModel::join('order o', 'user.id = o.user_id')->select();

The above code will be generated from UserModel And query all users and their order records in the OrderModel model class.

(3) Statistical query

In statistical query, you can use the count method of the model class to operate, for example:

$count = UserModel::where('age', '>', 18)->count();

The above code will count the age in the UserModel model class Number of users over 18 years old.

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