Search

Bind params Doctrine 2 ORM


Description
Bind Params in Prepared Statements


$dql = "SELECT b, e, r FROM Bug b JOIN b.engineer e JOIN b.reporter r ".
               "WHERE b.status = 'OPEN' AND e.id = ?1 OR r.id = ?1 ORDER BY b.created DESC";

return $this->getEntityManager()->createQuery( $dql )
                     ->setParameter( 1, $userId )
                     ->setMaxResults( $number )
                     ->getResult();
SEE ALSO