How to implement thinkphp to execute native SQL statements

How to execute native sql statements in thinkphp?

$Model = new Model();//或者 $Model = D(); 或者 $Model = M();
$sql = "select * from `order`";
$voList = $Model->query($sql);

Just need new an empty model to inherit the methods in Model.

Notequery is the query function, execute is the add, delete and modify function

Examples of querying and reading attribute values:

$sql = "select * from goods";
$Model = M();
$result = $Model->query($sql);
foreach ($result as $k=>$val){
$goods_id = $val["goods_id"];
}

tP’s model can support native SQL operations and provides two methods: query and execute. Why does native SQL need to distinguish between two methods? There are two reasons:

1. Different return types

query is used to query , returns the data set , which is the same as select or findall, so it can be used directly The volist tag is used in the template to output query results

execute is used for write operations,returns the status or the number of affected records

2. Read and write statistics are needed

In order to facilitate statistics of the current number of data reads and writes, separate the read and write operations of the database (corresponding to query and execute)

Use Native SQL is very simple, we don’t even need to instantiate any models, for example:

$Model = new Model(); // 实例化一个空模型

The following methods are equivalent

$Model = D();// 或者 $Model = M();
// 下面执行原生SQL操作
$Model->query('select * from think_user where status=1');
$Model->execute('update think_user set status=1 where id=1');

If you instantiate a model, you can still perform native SQL operations without being affected, for example:

$User = D('User');
$User->query('select * from think_user where status=1');
$User->execute('update think_user set status=1 where id=1');

In this case, We can simplify the writing of SQL statements, for example:

$User->query('select * from __TABLE__ where status=1');
$User->execute('update __TABLE__ set status=1 where id=1');

The system will automatically replace __TABLE__ with the name of the data table corresponding to the current model, and the actual data The table is determined by the model.

Generally speaking, we use native SQL operations to implement some operations that are difficult to implement with ORM and CURD . In addition, If the SQL is not complicated, the efficiency and coherence of native SQL The difference in operational efficiency is minimal, and the ORM implementation of TP itself is also quite efficient.

The above is the detailed content of How to implement thinkphp to execute native SQL statements. For more information, please follow other related articles on the PHP Chinese website!