Doctrine fetch one object directly not in array

Question

I have following repository:

    public function findClassPhotoByPath($path)
{
    return $this->getEntityManager()
        ->createQuery('SELECT p FROM KSRGalleryBundle:Photo p WHERE p.category = :category AND p.path = :path')
        ->setParameters(array('category' => 'class_photo', 'path' => $path))
        ->setMaxResults(1)
        ->getResult();
}

When I now use this repository-method the object is inside an array and I have to access it through $photo[0].

Is it possible to fetch the direct directly how it is the case by findOneBy()?

Best Regards, bodo

Mun Mun Das · Accepted Answer · 2012-03-31 19:04:31Z

8

You can use getSingleResult(). Also check here for other options.

Edit:

If you don't want catch the NoResultException you can also use getOneOrNullResult() method.

edited Mar 31, 2012 at 19:04

answered Mar 31, 2012 at 10:09

Mun Mun Das

15k2 gold badges46 silver badges43 bronze badges

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

2 Comments

Cerad Over a year ago

Just be careful that one result is always obtained. An exception will be thrown for no results.

Mun Mun Das Over a year ago

@Cerad, Right. This can be avoided using getOneOrNullResult() method.

Collectives™ on Stack Overflow

Doctrine fetch one object directly not in array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related