# Class Phalcon\\Mvc\\Model\\Query # Class **Phalcon\\Mvc\\Model\\Query** *implements*[*Phalcon\\Mvc\\Model\\QueryInterface*](#), `Phalcon\Di\InjectionAwareInterface` This class takes a PHQL intermediate representation and executes it. ``` <pre class="calibre14">``` <?php $phql = "SELECT c.price*0.16 AS taxes, c.* FROM Cars AS c JOIN Brands AS b WHERE b.name = :name: ORDER BY c.name"; $result = manager->executeQuery($phql, array( "name": "Lamborghini" )); foreach ($result as $row) { echo "Name: ", $row->cars->name, "\n"; echo "Price: ", $row->cars->price, "\n"; echo "Taxes: ", $row->taxes, "\n"; } ``` ``` ### Constants *integer***TYPE\_SELECT** *integer***TYPE\_INSERT** *integer***TYPE\_UPDATE** *integer***TYPE\_DELETE** ### Methods public **\_\_construct** (\[*string* $phql\], \[[*Phalcon\\DiInterface*](#) $dependencyInjector\]) Phalcon\\Mvc\\Model\\Query constructor public **setDI** (*unknown* $dependencyInjector) Sets the dependency injection container public **getDI** () Returns the dependency injection container public **setUniqueRow** (*unknown* $uniqueRow) Tells to the query if only the first row in the resultset must be returned public **getUniqueRow** () Check if the query is programmed to get only the first row in the resultset final protected **\_getQualified** (*unknown* $expr) Replaces the model's name to its source name in a qualifed-name expression final protected **\_getCallArgument** (*unknown* $argument) Resolves a expression in a single call argument final protected **\_getCaseExpression** (*unknown* $expr) Resolves a expression in a single call argument final protected **\_getFunctionCall** (*unknown* $expr) Resolves a expression in a single call argument final protected *string*\*\*\_getExpression\*\* (*array* $expr, \[*boolean* $quoting\]) Resolves an expression from its intermediate code into a string final protected *array*\*\*\_getSelectColumn\*\* (*array* $column) Resolves a column from its intermediate representation into an array used to determine if the resultset produced is simple or complex final protected *string*\*\*\_getTable\*\* ([*Phalcon\\Mvc\\Model\\ManagerInterface*](#) $manager, *array* $qualifiedName) Resolves a table in a SELECT statement checking if the model exists final protected *array*\*\*\_getJoin\*\* ([*Phalcon\\Mvc\\Model\\ManagerInterface*](#) $manager, *array* $join) Resolves a JOIN clause checking if the associated models exist final protected *string*\*\*\_getJoinType\*\* (*array* $join) Resolves a JOIN type final protected *array*\*\*\_getSingleJoin\*\* (*string* $joinType, *string* $joinSource, *string* $modelAlias, *string* $joinAlias, [*Phalcon\\Mvc\\Model\\RelationInterface*](#) $relation) Resolves joins involving has-one/belongs-to/has-many relations final protected *array*\*\*\_getMultiJoin\*\* (*string* $joinType, *string* $joinSource, *string* $modelAlias, *string* $joinAlias, [*Phalcon\\Mvc\\Model\\RelationInterface*](#) $relation) Resolves joins involving many-to-many relations final protected *array*\*\*\_getJoins\*\* (*array* $select) Processes the JOINs in the query returning an internal representation for the database dialect final protected *array*\*\*\_getOrderClause\*\* (*array|string* $order) Returns a processed order clause for a SELECT statement final protected **\_getGroupClause** (*unknown* $group) Returns a processed group clause for a SELECT statement final protected **\_getLimitClause** (*unknown* $limitClause) Returns a processed limit clause for a SELECT statement final protected **\_prepareSelect** (\[*unknown* $ast\], \[*unknown* $merge\]) Analyzes a SELECT intermediate code and produces an array to be executed later final protected **\_prepareInsert** () Analyzes an INSERT intermediate code and produces an array to be executed later final protected **\_prepareUpdate** () Analyzes an UPDATE intermediate code and produces an array to be executed later final protected **\_prepareDelete** () Analyzes a DELETE intermediate code and produces an array to be executed later public **parse** () Parses the intermediate code produced by Phalcon\\Mvc\\Model\\Query\\Lang generating another intermediate representation that could be executed by Phalcon\\Mvc\\Model\\Query public **getCache** () Returns the current cache backend instance final protected **\_executeSelect** (*unknown* $intermediate, *unknown* $bindParams, *unknown* $bindTypes, \[*unknown* $simulate\]) Executes the SELECT intermediate representation producing a Phalcon\\Mvc\\Model\\Resultset final protected [*Phalcon\\Mvc\\Model\\Query\\StatusInterface*](#)**\_executeInsert** (*array* $intermediate, *array* $bindParams, *array* $bindTypes) Executes the INSERT intermediate representation producing a Phalcon\\Mvc\\Model\\Query\\Status final protected [*Phalcon\\Mvc\\Model\\Query\\StatusInterface*](#)**\_executeUpdate** (*array* $intermediate, *array* $bindParams, *array* $bindTypes) Executes the UPDATE intermediate representation producing a Phalcon\\Mvc\\Model\\Query\\Status final protected [*Phalcon\\Mvc\\Model\\Query\\StatusInterface*](#)**\_executeDelete** (*array* $intermediate, *array* $bindParams, *array* $bindTypes) Executes the DELETE intermediate representation producing a Phalcon\\Mvc\\Model\\Query\\Status final protected [*Phalcon\\Mvc\\Model\\ResultsetInterface*](#)**\_getRelatedRecords** ([*Phalcon\\Mvc\\ModelInterface*](#) $model, *array* $intermediate, *array* $bindParams, *array* $bindTypes) Query the records on which the UPDATE/DELETE operation well be done public *mixed***execute** (\[*array* $bindParams\], \[*array* $bindTypes\]) Executes a parsed PHQL statement public *halconMvcModelInterface***getSingleResult** (\[*array* $bindParams\], \[*array* $bindTypes\]) Executes the query returning the first result public **setType** (*unknown* $type) Sets the type of PHQL statement to be executed public **getType** () Gets the type of PHQL statement executed public **setBindParams** (*unknown* $bindParams, \[*unknown* $merge\]) Set default bind parameters public *array***getBindParams** () Returns default bind params public **setBindTypes** (*unknown* $bindTypes, \[*unknown* $merge\]) Set default bind parameters public *array***getBindTypes** () Returns default bind types public **setIntermediate** (*unknown* $intermediate) Allows to set the IR to be executed public *array***getIntermediate** () Returns the intermediate representation of the PHQL statement public **cache** (*unknown* $cacheOptions) Sets the cache parameters of the query public **getCacheOptions** () Returns the current cache options public **getSql** () Returns the SQL to be generated by the internal PHQL (only works in SELECT statements) | - [索引](# "总目录") - [下一页](# "Class Phalcon\Mvc\Model\Query\Builder") | - [上一页](# "Class Phalcon\Mvc\Model\MetaData\Xcache") | - [API Indice](#) »