How to execute native SQL statements in thinkPHP framework

This article mainly introduces the method of executing native SQL statements in the thinkPHP framework. It analyzes the related operating skills of executing native SQL statements in thinkPHP in the form of examples, and briefly analyzes the difference between the query and execute methods. Friends in need You can refer to the following example

This article describes the method of executing native SQL statements in the thinkPHP framework. Share it with everyone for your reference, the details are as follows:

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 have to distinguish between two methods? There are two reasons:

1. Different return types

query is used to query , returns the data set , the same as select or findall, so you can directly use the volist tag in the template to output the query query Result

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

2. Read and write statistics required

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

Using native SQL is very simple, we don’t even need Instantiate any model, 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 data table corresponding to the current model The name and actual data table are 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 entire content of this article. I hope it will be helpful to everyone's study. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

ThinkPHP5 framework simply implements batch query

ThinkPHP3.2 framework uses addAll() to insert batches Data method

thinkPHP5 method of adding content to the database

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