Login Register

Mvc\Model\Query\Builder::andWhere

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));

Links:

https://docs.phalconphp.com/en/latest/api/Phalcon_Mvc_Model_Query_Builder.html#andwhere

doc_Phalcon

2025-01-10 15:47:30

Comments

Leave a Comment

Please login to continue.

Popular Articles

Mvc\Model\Query\Builder implements Phalcon\Mvc\Model\Query\BuilderInterface, Phalcon\Di\InjectionAwareInterface Source on GitHub Helps to create PHQL queries using an OO int

Mvc\Model\Query\Builder::notBetweenWhere public notBetweenWhere (mixed $expr, mixed $minimum, mixed $maximum, [mixed $operator]) Appends a NOT BETWEEN condition to the current conditions $bu

Mvc\Model\Query\Builder::getHaving public string | array getHaving () Return the current having clause

Mvc\Model\Query\Builder::distinct public distinct (mixed $distinct) Sets SELECT DISTINCT / SELECT ALL flag $builder->distinct("status"); $builder->distinct(null);

Mvc\Model\Query\Builder::leftJoin public Phalcon\Mvc\Model\Query\Builder leftJoin (string $model, [string $conditions], [string $alias]) Adds a LEFT join to the query $builder->lef