Mvc\Model\Criteria::bind

public bind (array $bindParams, [mixed $merge]) Sets the bound parameters in the criteria This method replaces all previously set bound parameters

Mvc\Model\Criteria::distinct

public distinct (mixed $distinct) Sets SELECT DISTINCT / SELECT ALL flag

Mvc\Model\Criteria::bindTypes

public bindTypes (array $bindTypes) Sets the bind types in the criteria This method replaces all previously set bound parameters

Mvc\Model\Criteria::columns

public Phalcon\Mvc\Model\Criteria columns (string | array $columns) Sets the columns to be queried $criteria->columns(array('id', 'name'));

Mvc\Model\Criteria::execute

public execute () Executes a find using the parameters built with the criteria

Mvc\Model\Criteria::cache

public cache (array $cache) Sets the cache options in the criteria This method replaces all previously set cache options

Mvc\Model\Criteria::conditions

public conditions (mixed $conditions) Adds the conditions parameter to the criteria

Mvc\Model\Criteria::betweenWhere

public betweenWhere (mixed $expr, mixed $minimum, mixed $maximum) Appends a BETWEEN condition to the current conditions $criteria->betweenWhere('price', 100.25, 200.50);

Mvc\Model\Criteria::andWhere

public andWhere (mixed $conditions, [mixed $bindParams], [mixed $bindTypes]) Appends a condition to the current conditions using an AND operator

Mvc\Model\Criteria

implements Phalcon\Mvc\Model\CriteriaInterface, Phalcon\Di\InjectionAwareInterface Source on GitHub This class is used to build the array parameter required by Phalcon\Mvc\Model::find() and Phalcon\Mvc\Model::findFirst() using an object-oriented interface. $robots = Robots::query() ->where('type = :type:') ->andWhere('year < 2000') ->bind(['type' => 'mechanical']) ->limit(5, 10) ->orderBy('name') ->execute(); Methods public setDI (Phalcon\D