public bind (array $bindParams, [mixed $merge]) Sets the bound parameters in the criteria This method replaces all previously set bound parameters
public distinct (mixed $distinct) Sets SELECT DISTINCT / SELECT ALL flag
public bindTypes (array $bindTypes) Sets the bind types in the criteria This method replaces all previously set bound parameters
public Phalcon\Mvc\Model\Criteria columns (string | array $columns) Sets the columns to be queried $criteria->columns(array('id', 'name'));
public execute () Executes a find using the parameters built with the criteria
public cache (array $cache) Sets the cache options in the criteria This method replaces all previously set cache options
public conditions (mixed $conditions) Adds the conditions parameter to the criteria
public betweenWhere (mixed $expr, mixed $minimum, mixed $maximum) Appends a BETWEEN condition to the current conditions $criteria->betweenWhere('price', 100.25, 200.50);
public andWhere (mixed $conditions, [mixed $bindParams], [mixed $bindTypes]) Appends a condition to the current conditions using an AND operator
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
Page 162 of 382