Shulou(Shulou.com)06/01 Report--

This article mainly explains "how to use execute in thinkphp". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn how to use execute in thinkphp.

In thinkphp, the execute () method can enter SQL statements directly into parameters. This method is used to execute SQL statements such as insert or update, and the result returned is the number of records affected by the SQL statement. The syntax is "$model-> execute (SQL statement)".

This article operating environment: Windows10 system, ThinkPHP5 version, Dell G3 computer.

What is the use of execute in thinkphp

Both the execute () and query () methods in ThinkPHP can enter SQL statements directly in the parameters. But the difference is that execute () is usually used to execute SQL statements such as insert or update, while query is often used to execute statements such as select.

The execute () method returns the number of records affected, and if the select statement of SQL is executed, the result will be the total number of records in the table:

The code is as follows:

$model = M ("MyTable"); $result = $model-> execute ('update MyTable set name=aaa where id=11'); / / the total number of rows will be returned

The query () method returns the dataset:

The code is as follows:

$model = M ("MyTable"); $result = $model-> query ('select * from MyTable'); / / will return array () Thank you for reading, above is the content of "how to use execute in thinkphp". After the study of this article, I believe you have a deeper understanding of how to use execute in thinkphp, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.