Symfony2 fetch data from entity with OneToMany relation

Question

I have two entities: Ad and AdPhoto. They have relation: OneToMany(Many AdPhoto to one Ad). After persist, I tried to get AdPhoto from Ad by method Ad::getPhoto(), but I get PersistentCollection class and I dont know what do with it.

Help me to understand how I can get all related AdPhoto to Ad.

Entity Ad:

namespace AdBundle\Entity;

use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\ORM\Mapping as ORM;

/**
 * Ad
 *
 * @ORM\Table(name="Ad")
 * @ORM\Entity
 */
class Ad
{
...
    /**
     * @ORM\OneToMany(targetEntity="AdBundle\Entity\AdPhoto", mappedBy="id")
     */
    private $photo;
...
}

Entity AdPhoto:

namespace AdBundle\Entity;

use Doctrine\ORM\Mapping as ORM;
use Symfony\Component\HttpFoundation\File\UploadedFile;
use Symfony\Component\Validator\Constraints as Assert;

/**
 * AdPhoto
 *
 * @ORM\Table(name="AdPhoto")
 * @ORM\Entity
 */
class AdPhoto
{
    ...    
    /**
     * @ORM\ManyToOne(targetEntity="AdBundle\Entity\Ad", inversedBy="photo")
     * @ORM\JoinColumn(name="ad", referencedColumnName="id")
     */
    private $ad;
...
}

In controller:

$ad = $this->getDoctrine()->getRepository('AdBundle:Ad')
            ->findOneBy(array(
                'id' => $id
            ));

        var_dump($ad->getPhoto());

        return $this->render('AdBundle:Default:view.html.twig', array(
            'ad' => $ad
        ));

Edit the question and put the code you tried

Dipen Shah
– Dipen Shah

2015-12-03 20:38:57 +00:00
Commented Dec 3, 2015 at 20:38 — Dipen Shah
– Dipen Shah, Commented Dec 3, 2015 at 20:38

Ivan Toncev · Accepted Answer · 2015-12-03 22:13:51Z

1

You can loop through array collection in twig like through regular array. If you want to use it as array in php code you can use

$photos = $ad->getPhotos()->toArray();

And since add can have many photos it would be better to use $photos instead $photo.

answered Dec 3, 2015 at 22:13

Ivan Toncev

5325 silver badges15 bronze badges

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

1 Comment

trauma Over a year ago

Thanks a lot, I should try it in the morning. Rename $photo to $photos it`s a good proposition. Thanks!

Allart · Accepted Answer · 2022-01-18 09:50:44Z

0

Ivan Toncev it's answer is great, but there is an extra thing you might want to know about to make things more understandable.

PersistentCollection does have the value's you need. You just don't see it when you log them. Idk why.

You could try out the following things to check if there is actually data existing:

$ad->getPhotos()->count(); // Counts the amount of items (rows).

count($ad->getPhotos()); // Same as above.

// Loop trough all photo's.
for ($i = 0; $i < count($ad->getPhotos()); $i++) {

    // A single photo!
    $photo = $ad->getPhotos()[$i];
}

answered Jan 18, 2022 at 9:50

Allart

92813 silver badges40 bronze badges

Collectives™ on Stack Overflow

Symfony2 fetch data from entity with OneToMany relation

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related