Mvc\Model\Query\Status

implements Phalcon\Mvc\Model\Query\StatusInterface Source on GitHub This class represents the status returned by a PHQL statement like INSERT, UPDATE or DELETE. It offers context information and the related messages produced by the model which finally executes the operations when it fails $phql = "UPDATE Robots SET name = :name:, type = :type:, year = :year: WHERE id = :id:"; $status = $app->modelsManager->executeQuery($phql, array( 'id' => 100, 'name' => 'Astroy Boy', 'typ

Mvc\Model\Query\Lang::parsePHQL

public static string parsePHQL (string $phql) Parses a PHQL statement returning an intermediate representation (IR)

Mvc\Model\Query\Lang

Source on GitHub PHQL is implemented as a parser (written in C) that translates syntax in that of the target RDBMS. It allows Phalcon to offer a unified SQL language to the developer, while internally doing all the work of translating PHQL instructions to the most optimal SQL instructions depending on the RDBMS type associated with a model. To achieve the highest performance possible, we wrote a parser that uses the same technology as SQLite. This technology provides a small in-memory parser wi

Mvc\Model\Query\BuilderInterface::where

abstract public where (mixed $conditions, [mixed $bindParams], [mixed $bindTypes]) ...

Mvc\Model\Query\BuilderInterface::rightJoin

abstract public rightJoin (mixed $model, [mixed $conditions], [mixed $alias]) ...

Mvc\Model\Query\BuilderInterface::orWhere

abstract public orWhere (mixed $conditions, [mixed $bindParams], [mixed $bindTypes]) ...

Mvc\Model\Query\BuilderInterface::orderBy

abstract public orderBy (mixed $orderBy) ...

Mvc\Model\Query\BuilderInterface::OPERATOR_OR

string OPERATOR_OR

Mvc\Model\Query\BuilderInterface::OPERATOR_AND

string OPERATOR_AND

Mvc\Model\Query\BuilderInterface::notInWhere

abstract public notInWhere (mixed $expr, array $values, [mixed $operator]) ...