When ThinkPHP is a beginner, many people do not understand the differences between execute () and query () methods. In this article, we will analyze the differences between them. If you need them, refer to ThinkPHP beginners, many people do not understand the differences between the execute () and query () methods. This article analyzes the differences between them.
As we all know, the execute () and query () methods in ThinkPHP can both directly input SQL statements in parameters. But the difference is that
Execute () is usually used to execute SQL statements such as insert or update., And
Query is commonly used to execute select statements..
The execute () method returns the number of affected recordsIf you execute the select statement of SQL, the returned results will be the total number of records of 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 returned
The query () method returns a dataset.:
The Code is as follows:
$ Model = M ("MyTable ");
$ Result = $ model-> query ('select * from mytable'); // returns array ()
