Doctrine createQueryBuilder - If Where Parameter is Empty Get All Records

Question

My Query Builder :

$nameParameter="david";

$query=$this->entityManager->createQueryBuilder()
            ->from('Person\Entity\User', 'u')
            ->select("u")
            ->where("u.name = :name")
            ->setParameter('name',$nameParameter);

        return  $query->getQuery()->getResult();

When $nameParameteris Empty not returned any Result;

Question : HOW Create Query That if $nameParameter is Empty Get All Records Of U.name Entity;

score 0 · Answer 1 · answered Mar 16 '15 at 07:53

I Find This Way :

$nameParameter="david";

$query=$this->entityManager->createQueryBuilder()
            ->from('Person\Entity\User', 'u')
            ->select("u");

           if($nameParameter) {

                    $query->andWhere('u.name = :name')
                    ->setParameter('name', $nameParameter);
                }

        return  $query->getQuery()->getResult();

Doctrine createQueryBuilder - If Where Parameter is Empty Get All Records

1 Answers1