Doctrine query using execute

Question

Option 1 and Option 2 seem to give similar results. Is there a particular advantage for using the execute statement rather than the usual getResult() method?

Option 1:

public function getEventsByOrganiser(EventInterface $event, $username)
{
    $qb = $this->repository->createQueryBuilder('e')
        ->select(array('e', 'u'))
        ->leftJoin('e.user', 'u')
        ->andWhere('u.username = :username');

    return $qb->getQuery()->execute(array(
        'username' => $username
    ));
}

Option2:

public function getEventsByOrganiser(EventInterface $event, $username)
{
    $qb = $this->repository->createQueryBuilder('e')
        ->select(array('e', 'u'))
        ->leftJoin('e.user', 'u')
        ->andWhere('u.username = :username')
        ->setParameter('username', $username);

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

}

l3l0 · Accepted Answer · 2013-01-31 07:13:50Z

15

Basically getResult() is alias for execute(array()) you can set as argument hydration mode for example: getResult(Query::HYDRATE_OBJECT) is execute(array(), Query::HYDRTE_OBJECT)

Only difference: in execute method you can set query parameters as first argument so you do not have to call setParameter method before...

answered Jan 31, 2013 at 7:13

l3l0

3,38322 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mick Over a year ago

Just citing the doc for people to look into if they need to: query-result-formats

Collectives™ on Stack Overflow

Doctrine query using execute

Option 1:

Option2:

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Option 1:

Option2:

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related