Symfony doctrine ManyToMany insert

Question

I 'm having a form on which i can create a new "Book". For a book, i can add tags (e.g. to describe additional information about it).

The relation between Book and Tag is ManyToMany, because each Book can have many tags, and each tag can rely to different books. (Each tag is a unique field on its name). So, when a user enters a new tag to a book that does not exists in the database, i want to create the tag when submitting. If it already exists, i want to add the tag to the book. I've tried the following:

$book = $this->form->getData();

foreach ($tags as $tag) {
  $tag = strtolower($tag);

  // check if tag already exists
  $tagEntity = $this->em->getRepository('BookBundle:Tag')->findByName($tag);

  // if not, create new tag and add
  if(null === $tagEntity)
  {
      $tagEntity = new Tag();
      $tagEntity->setName($tag);
  }

  // add tag to book
  $book->addTag($tagEntity);
  // add book to tag
  $tagEntity->addbook($book);

  // create relation between tag and book
  $this->em->persist($book);
  $this->em->persist($tagEntity);

  $this->em->flush();
}

Questions:

1) Do i first need to create the book after line 1 with persist and flush, before i can go on?

2) What is the best way to handle adding (new) tags to books, like I described above ?

At the moment when i click on "submit", my local apache does not respond and "hangs up"..

Regards

Where are the $tags coming from then? Not in the code. Have you checked that the array exists and is not empty? — David Soussan, Apr 01 '15 at 17:14
it was not empty, i found the solution here, keyword "inverse side" and "addItem": http://stackoverflow.com/questions/7044864/symfony2-doctrine-manytomany-relation-is-not-saved-to-database — nova.cp, Apr 01 '15 at 20:26
Theres bug when tag already exists. You have to use ```findOneByName``` otherwise it will return array. — Keo, Apr 02 '15 at 08:49

score 1 · Accepted Answer · answered Apr 02 '15 at 08:43

1

Try not adding both book to tag and tag to book. Just add tag to book and persist the book entity. Doctrine should do it all. And of course the book or tag entity should have the method the capable method of adding book or tag which is generated by doctrine automatically.

answered Apr 02 '15 at 08:43

Imran

4,582
2
18
37

yep, thats what i also found on the link posted as comment on the other answer. Accepted yours though because it's exactly what needs tbd. Just make sure that you add 'cascade={"persist"}' on your field, than doctrine does all automatically. – nova.cp Apr 02 '15 at 09:05

Symfony doctrine ManyToMany insert

1 Answers1