public Phalcon\Mvc\Model\Query\Builder andWhere (string $conditions, [array $bindParams], [array $bindTypes]) Appends a condition to the current conditions using a AND operator $builder->andWhere('name = "Peter"'); $builder->andWhere('name = :name: AND id > :id:', array('name' => 'Peter', 'id' => 100));

public addFrom (mixed $model, [mixed $alias], [mixed $with]) Add a model to take part of the query // Load data from models Robots $builder->addFrom('Robots'); // Load data from model 'Robots' using 'r' as alias in PHQL $builder->addFrom('Robots', 'r'); // Load data from model 'Robots' using 'r' as alias in PHQL // and eager load model 'RobotsParts' $builder->addFrom('Robots', 'r', 'RobotsParts'); // Load data from model 'Robots' using 'r' as alias in PHQL // and eager loa

implements Phalcon\Mvc\Model\Query\BuilderInterface, Phalcon\Di\InjectionAwareInterface Source on GitHub Helps to create PHQL queries using an OO interface $params = array( 'models' => array('Users'), 'columns' => array('id', 'name', 'status'), 'conditions' => array( array( "created > :min: AND created < :max:", array("min" => '2013-01-01', 'max' => '2014-01-01'), array("min" => PDO::PARAM_STR, 'max' =>

abstract public setUniqueRow (mixed $uniqueRow) ...

abstract public parse () ...

abstract public getUniqueRow () ...

abstract public getCacheOptions () ...

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

abstract public cache (mixed $cacheOptions) ...

Source on GitHub Methods abstract public parse () ... abstract public cache (mixed $cacheOptions) ... abstract public getCacheOptions () ... abstract public setUniqueRow (mixed $uniqueRow) ... abstract public getUniqueRow () ... abstract public execute ([mixed $bindParams], [mixed $bindTypes]) ...