Table Of Contents

Previous topic

< Interface Phalcon\Mvc\Model\BehaviorInterface

Next topic

Interface Phalcon\Mvc\Model\ManagerInterface >

Interface Phalcon\Mvc\Model\CriteriaInterface

Phalcon\Mvc\Model\CriteriaInterface initializer

Methods

abstract public Phalcon\Mvc\Model\CriteriaInterface setModelName (string $modelName)

Set a model on which the query will be executed

abstract public string getModelName ()

Returns an internal model name on which the criteria will be applied

abstract public Phalcon\Mvc\Model\CriteriaInterface bind (string $bindParams)

Adds the bind parameter to the criteria

abstract public Phalcon\Mvc\Model\Criteria bindTypes (string $bindTypes)

Sets the bind types in the criteria This method replaces all previously set bound parameters

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

Sets the columns to be queried

<?php

$criteria->columns(array('id', 'name'));

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

Adds a join to the query

<?php

$criteria->join('Robots');
$criteria->join('Robots', 'r.id = RobotsParts.robots_id');
$criteria->join('Robots', 'r.id = RobotsParts.robots_id', 'r');
$criteria->join('Robots', 'r.id = RobotsParts.robots_id', 'r', 'LEFT');

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

Adds the conditions parameter to the criteria

abstract public Phalcon\Mvc\Model\CriteriaInterface conditions (string $conditions)

Adds the conditions parameter to the criteria

abstract public Phalcon\Mvc\Model\CriteriaInterface orderBy (string $orderColumns)

Adds the order-by parameter to the criteria

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

Sets the limit parameter to the criteria

abstract public Phalcon\Mvc\Model\CriteriaInterface forUpdate ([boolean $forUpdate])

Sets the “for_update” parameter to the criteria

abstract public Phalcon\Mvc\Model\Criteria sharedLock ([boolean $sharedLock])

Sets the “shared_lock” parameter to the criteria

abstract public Phalcon\Mvc\Model\Criteria andWhere (string $conditions, [array $bindParams], [array $bindTypes])

Appends a condition to the current conditions using an AND operator

abstract public Phalcon\Mvc\Model\Criteria orWhere (string $conditions, [array $bindParams], [array $bindTypes])

Appends a condition to the current conditions using an OR operator

abstract public Phalcon\Mvc\Model\Query\Builder betweenWhere (string $expr, mixed $minimum, mixed $maximum)

Appends a BETWEEN condition to the current conditions

<?php

$criteria->betweenWhere('price', 100.25, 200.50);

abstract public Phalcon\Mvc\Model\Query\Builder notBetweenWhere (string $expr, mixed $minimum, mixed $maximum)

Appends a NOT BETWEEN condition to the current conditions

<?php

$criteria->notBetweenWhere('price', 100.25, 200.50);

abstract public Phalcon\Mvc\Model\Query\Builder inWhere (string $expr, array $values)

Appends an IN condition to the current conditions

<?php

$criteria->inWhere('id', [1, 2, 3]);

abstract public Phalcon\Mvc\Model\Query\Builder notInWhere (string $expr, array $values)

Appends a NOT IN condition to the current conditions

<?php

$criteria->notInWhere('id', [1, 2, 3]);

abstract public string getWhere ()

Returns the conditions parameter in the criteria

abstract public string getConditions ()

Returns the conditions parameter in the criteria

abstract public string getLimit ()

Returns the limit parameter in the criteria

abstract public string getOrder ()

Returns the order parameter in the criteria

abstract public string getParams ()

Returns all the parameters defined in the criteria

abstract public static static fromInput (Phalcon\DiInterface $dependencyInjector, string $modelName, array $data)

Builds a Phalcon\Mvc\Model\Criteria based on an input array like $_POST

abstract public Phalcon\Mvc\Model\ResultsetInterface execute ()

Executes a find using the parameters built with the criteria