CODEWITHSUNDEEP
symfonydoctrine-orm
Anish Shah
Anish Shah

Reputation: 333

search with Doctrine if blank field

i have written a DQL query for my multiple search,working fine if i specify the all fields but if i keep one of the field blank it won't show me the result

          $query = $em->createQuery
          ('SELECT d FROM EntityBundle:Doctor d WHERE d.name =:name AND d.degree =:degree AND d.area = :area_id AND d.sex = :sex AND
           (

                 ( YEAR(d.dob)  BETWEEN :d2 AND :d1 ) OR
                 ( YEAR(d.dob)  BETWEEN :e2 AND :e1 ) OR
                 ( YEAR(d.dob)  BETWEEN :f2 AND :f1 )

            )'          )

           ->setParameter('name', $name)
           ->setParameter('degree', $degree)
            ->setParameter('area_id', $area)
            ->setParameter('sex', $sex)
            ->setParameter('d1', $this->p1)
            ->setParameter('d2', $this->p2)
            ->setParameter('e1', $this->q1)
            ->setParameter('e2', $this->q2)
            ->setParameter('f1', $this->r1)
            ->setParameter('f2', $this->r2)

          ->getResult();

i have tried setParameter('name', (is_null($name)? "IS NULL" : $name)) also but still there is no luck..

Upvotes: 0

Views: 47

Answers (1)

Gregsparrow
Gregsparrow

Reputation: 1372

You can use QueryBuilder instead of DQL 

$qb = $qb->select('d');
if($name !== null) {
     $qb = $qb->where('d.name = :name')->setParameter(...);
}
...
$qb->getQuery()->getResult();

Upvotes: 1

Related Questions