Complex logical operator where Sympfony Sonata?

Question

symfony

I configure createQuery I form a query string in a loop in order to execute

$qb->where('u.firstName = ?1 AND u.surname = ?2')

why if in line 1 element the request is triggered, and if there are more than 2 elements, then nothing is displayed at all?

Answer 1

in the case of complex use , you WHEREshould write something like

$qb
    ->where('u.firstName = :fitst_name')
    ->andWhere('u.surname = :user_name')
    ->setParameters(array('fitst_name' => 'FirstName', 'user_name' => 'UserName'))