# Class **Phalcon\Mvc\Model\Query**[](# "永久链接至标题") *implements*[*Phalcon\Mvc\Model\QueryInterface*](#), `Phalcon\Di\InjectionAwareInterface` This class takes a PHQL intermediate representation and executes it. ~~~ <?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](#) »