Mvc\Model\Criteria::join

public join (mixed $model, [mixed $conditions], [mixed $alias], [mixed $type])

Adds an INNER join to the query

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

Links:

https://docs.phalconphp.com/en/latest/api/Phalcon_Mvc_Model_Criteria.html#join

doc_Phalcon

2025-01-10 15:47:30

Comments

Popular Articles

Mvc\Model\Criteria implements Phalcon\Mvc\Model\CriteriaInterface, Phalcon\Di\InjectionAwareInterface Source on GitHub This class is used to build the array parameter r

Mvc\Model\Criteria::sharedLock public sharedLock ([mixed $sharedLock]) Adds the “shared_lock” parameter to the criteria

Mvc\Model\Criteria::orderBy public orderBy (mixed $orderColumns) Adds the order-by clause to the criteria

Mvc\Model\Criteria::setDI public setDI (Phalcon\DiInterface $dependencyInjector) Sets the DependencyInjector container

Mvc\Model\Criteria::notBetweenWhere public notBetweenWhere (mixed $expr, mixed $minimum, mixed $maximum) Appends a NOT BETWEEN condition to the current conditions $criteria->notBetwe