About the table method of ThinkPHP CURD method

This article mainly introduces the table method of ThinkPHP CURD method. It has certain reference value. Now I share it with you. Friends in need can refer to it.

The table method of ThinkPHP CURD method is mainly used. Data table for the specified operation. This article mainly introduces the usage of table method. Friends who need it can refer to it

The table method of ThinkPHP CURD method is also one of the coherent operation methods of the model class. This methodis mainly used for specifying operations. data sheet.

The specific usage is as follows:

Generally, the system can automatically identify the current corresponding data table when operating the model, so the table method is usually used for:

1. Switch the data table of the operation;
2. Operate multiple tables;

For example:

$Model->table('think_user')->where('status>1')->select();

You can also specify the database in the table method, for example:

$Model->table('db_name.think_user')->where('status>1')->select();

It should be noted that the table method will not change the database connection, so You need to ensure that the currently connected user has permission to operate the corresponding database and data table.

After switching the data table, the system will automatically re-obtain the field cache information of the switched data table.

If you need to operate multiple tables, you can use it like this:

$Model->field('user.name,role.title')->table('think_user user,think_role role')->limit(10)->select();

In order to avoid conflicts with mysql keywords, It is recommended to use array definition, for example:

$Model->field('user.name,role.title')->table(array('think_user'=>'user','think_role'=>'role'))->limit(10)->select();

The above is the entire content of this article. I hope it will be helpful to everyone's learning. Please pay attention to more related content. PHP Chinese website!

Related recommendations:

Analysis on ThinkPHP’s use of getlist method to implement data search function

setInc method in thinkphp3.2.0 Source code analysis

The above is the detailed content of About the table method of ThinkPHP CURD method. For more information, please follow other related articles on the PHP Chinese website!