Project Versions

Table Of Contents

Previous topic

Interface Phalcon\Mvc\Model\QueryInterface

Next topic

Interface Phalcon\Mvc\Model\Query\StatusInterface

This Page

Interface Phalcon\Mvc\Model\Query\BuilderInterface

Phalcon\Mvc\Model\Query\BuilderInterface initializer

Methods

abstract public __construct ([array $params])

Phalcon\Mvc\Model\Query\Builder

abstract public Phalcon\Mvc\Model\Query\BuilderInterface columns (string|array $columns)

Sets the columns to be queried

abstract public string|array getColumns ()

Return the columns to be queried

abstract public Phalcon\Mvc\Model\Query\BuilderInterface from (string|array $models)

Sets the models who makes part of the query

abstract public Phalcon\Mvc\Model\Query\BuilderInterface addFrom (string $model, [string $alias])

Add a model to take part of the query

abstract public string|array getFrom ()

Return the models who makes part of the query

abstract public Phalcon\Mvc\Model\Query\BuilderInterface join (string $model, [string $conditions], [string $alias])

Adds a INNER join to the query

abstract public Phalcon\Mvc\Model\Query\BuilderInterface where (string $conditions)

Sets conditions for the query

abstract public Phalcon\Mvc\Model\Query\Builder andWhere (string $conditions)

Appends a condition to the current conditions using a AND operator

abstract public Phalcon\Mvc\Model\Query\Builder orWhere (string $conditions)

Appends a condition to the current conditions using a OR operator

abstract public string|array getWhere ()

Return the conditions for the query

abstract public Phalcon\Mvc\Model\Query\BuilderInterface orderBy (string $orderBy)

Sets a ORDER BY condition clause

abstract public string|array getOrderBy ()

Return the set ORDER BY clause

abstract public Phalcon\Mvc\Model\Query\BuilderInterface having (string $having)

Sets a HAVING condition clause

abstract public string|array getHaving ()

Returns the HAVING condition clause

abstract public Phalcon\Mvc\Model\Query\BuilderInterface limit (int $limit, [int $offset])

Sets a LIMIT clause

abstract public string|array getLimit ()

Returns the current LIMIT clause

abstract public Phalcon\Mvc\Model\Query\BuilderInterface groupBy (string $group)

Sets a LIMIT clause

abstract public string getGroupBy ()

Returns the GROUP BY clause

abstract public string getPhql ()

Returns a PHQL statement built based on the builder parameters

abstract public Phalcon\Mvc\Model\QueryInterface getQuery ()

Returns the query built