Symfony 2 Doctrine 2 one to many relationship not returning data

Question

I got back to doctrine after a while. I have some problem with doctrine and symfony which I can't figure out at all, why it could be. A help would be nice.

I've got two entities: 1. Category:

/**
 * @var integer
 *
 * @ORM\Column(name="id", type="integer")
 * @ORM\Id
 * @ORM\GeneratedValue(strategy="AUTO")
 */
private $id;


/**
 * @ORM\OneToMany(targetEntity="Items", mappedBy="category")
 */
private $items;


public function __construct() 
{
    $this->items = new \Doctrine\Common\Collections\ArrayCollection();
}



/**
 * Get id
 *
 * @return integer 
 */
public function getId()
{
    return $this->id;
}

/**
 *
 * @param Items $items
 * @return Category
 */
public function addItem(Items $item)
{
    $this->items[] = $item;

    return $this;
}

/**
 *
 * @param Items $item
 */
public function removeItem(Items $item)
{
    $this->items->removeElement($item);
}

/**
 * @return Items
 */
public function getItems()
{
    return $this->items;
}

And Second is: Items

  /**
  * @var integer
  *
  * @ORM\Column(name="id", type="integer")
  * @ORM\Id
  * @ORM\GeneratedValue(strategy="AUTO")
  */
 private $id;

 /**
 * @var integer
 *
 * @ORM\ManyToOne(targetEntity="Category", inversedBy="items")
 * @ORM\JoinColumn(name="category_id", referencedColumnName="id")
 */
 private $category;


 /**
 * Get id
 *
 * @return integer 
 */
 public function getId()
 {
    return $this->id;
 }

 /**
 * Set category
 *
 * @param Category $category
 * @return Items
 */
 public function setCategory(Category $category = null)
 {
    $this->category = $category;

    return $this;
 }

 /**
  * Get category
  *
  * @return Category 
  */
 public function getCategory()
 {
    return $this->category;
 }

Now in Controller, I'm simply trying to retrieve items via categories:

    $categories = $em->getRepository('Category')->findAll();  
    //just example 
    foreach ($categories as $category) {
        print_r($category->getItems());
    }

Should $category->getItems() return the Items of that category? Or I'm in illusion that it should work? Please suggest.

It returns null at the moment but not errors although there is data in database.

The table structure is:

  CREATE TABLE `category` (

 `id` int(11) NOT NULL AUTO_INCREMENT,

  PRIMARY KEY (`id`)

 ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8

And

 CREATE TABLE `items` (

 `id` int(11) NOT NULL AUTO_INCREMENT,

 `category_id` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_category` (`category_id`),

 CONSTRAINT `fk_category` FOREIGN KEY (`category_id`) REFERENCES `Category` (`id`)

 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8

Thanks

It should work. What is the problem? Are there any errors? What is the result of printing `$category->getItems()`? — shad, Jan 04 '14 at 23:57
Thanks for getting back Shad. It returns nothing. Although, there is data in the database. — Webghost, Jan 05 '14 at 00:01
have you tried to put `public function __construct() { $this->items = new ArrayCollection(); }` inside the category entity? — shad, Jan 05 '14 at 00:10
It's already there. Sorry I had ommitted that part when I did paste here. — Webghost, Jan 05 '14 at 00:12
I've tested it locally and it worked. Should return `Doctrine\ORM\PersistentCollection` object — shad, Jan 05 '14 at 00:33
Which is not nice, as it doesn't work although the code is same for me. Thanks anyway. — Webghost, Jan 05 '14 at 00:40
Yea. And items is a property of $categories which is blank (null). — Webghost, Jan 05 '14 at 00:51
I have put the table structure in question, as formatting does not look good here in comments. — Webghost, Jan 05 '14 at 00:57
Maybe try the opposite. Instead of trying to get items for category, try to fetch some random item and see if there's category properly attached: `$categories = $em->getRepository('Items')->find($some_id);` — shad, Jan 05 '14 at 01:00
It is good question. Yea. Many times. I was doing that just earlier. :) — Webghost, Jan 05 '14 at 01:17
I don't see any reason for this to not work.. I'm out of ideas — shad, Jan 05 '14 at 01:19
Thanks for spending time on this though. Hopefully, Someone will look at it and will be able to say that there is one more thing to try. — Webghost, Jan 05 '14 at 01:21
2.4 Symfony. Just downloaded last week. Doctrine 2.2, (I believe 2.2.3 to be specific). — Webghost, Jan 05 '14 at 01:25
Is it dev environment? Check profilers db panel and see the queries that been run — shad, Jan 05 '14 at 01:31
It doesn't touch the items table at all, runs select ... from category once. — Webghost, Jan 05 '14 at 01:42
Should be like this: `SELECT t0.id AS id1 FROM category t0` `SELECT t0.id AS id1, [...] FROM items t0 WHERE t0.category_id = ?`. I just copied your code and it worked instantly. — shad, Jan 05 '14 at 01:49
It is just doing select t0.id as id1 from category t0 unfortunately. Is that what is does to you? — Webghost, Jan 05 '14 at 01:50
[Mapping] OK - The mapping files are correct. [Database] OK - The database schema is in sync with the mapping files. — Webghost, Jan 05 '14 at 02:02
I will look at after a while in fresh mind again. Please post any idea come into mind. Ta. — Webghost, Jan 05 '14 at 02:05

score 1 · Answer 1 · answered Jan 05 '14 at 00:23

1

You need to set the category of the item when you add it otherwise it will be saved in the database as NULL rather than the category id.

/**
 *
 * @param Items $items
 * @return Category
 */
public function addItem(Items $item)
{
    $item->setCategory($this);
    $this->items[] = $item;

    return $this;
}

answered Jan 05 '14 at 00:23

qooplmao

17,622
2
44
69

Qoop, thanks for getting back. But it's not null because of the way data is added. Plus, I tested by adding data to database manually, it is still not working. – Webghost Jan 05 '14 at 00:39
My problem was very similar: You only could access one side of the relation (item => category), but category => items was empty. The explicit usage of "setCategory" solved it for me, because it "tells" the other side, that there is one to take care of. – k00ni Jan 15 '20 at 09:02

score 1 · Answer 2 · answered Oct 27 '16 at 23:17

2 years later.. I'm also looking to make this work with the latest Symfony and Doctrine and by $category->getItems()

What I had to do is, in your case:

Controller:

$items = $em->getRepository('AppBundle:Items')->findByCategory($category);

For some reason ->getItems() is empty.

score 0 · Answer 3 · answered May 31 '17 at 15:25

0

try:

\Doctrine\Common\Util\Debug::dump($category->getItems());

instead of

print_r($category->getItems());

i face the same issue when i tried dump() function for some reason it doesn't dump results

answered May 31 '17 at 15:25

Ayaddi

1
3

Symfony 2 Doctrine 2 one to many relationship not returning data

3 Answers3

Linked