Fetching Items from a ManyToMany Collection

Hello. i Need a little help. I have really long loading of my symfony webpage on localhost. FIrewall probably taking the most as u can see on screenshort. Is there someone who probably know how to fix it ? I tryind all thinks from internet but nothing works its taking like 6 seconds to load 1 page and thats bad if u want to test somehing new :) http://imgur.com/a/8X0YO
My controller : https://pastebin.com/1xcSeLjw

Please help me :) Thanks

Hey Marek Burda

Does it happens all the time ? When you clear the cache, the first time you load a page it takes longer because Symfony needs to setup a few things, but after that it should be fast

Yes it happening all the time. I tryid a lot of thigs.. restarting server, changim some things in services or parameters a lot of things from tutorials and forums on internet. But nothing change. Still loading page 6-10 seconds.

Hmm, it is a weird behaviour, in which enviroment are you running, windows, mac, linux ? Try to monitor your resources (htop command if you are on Linux), maybe something is leaking memory

Iam on windows :/ Every other pages are working normaly. Btw i think a projekt which i make before this one, working normaly and i also used same codes and db connections as here...

Okey a fixed it. Problem was in loading javascript and foundation scripts from nonexists files. (I have 1 where is exists and 1 who dont exist) so cose was looking for files who dont exist. But thanks :)

I'm glad to hear you could fix your problem :)

Hey, I've been looking what you did here, but I applied to my own project and didn't work.. I don't know what I am doing wrong.... I have posted the question in stackOverflow but seems that nobody is answering, I need help :( https://stackoverflow.com/q...

Hey Carles,

I see your question on SO was answered correctly, I'm glad you were able to solve this.

Cheers!

Hi,
The download button on this page https://knpuniversity.com/s... is serving the wrong video file, it's serving the EP07 instead of EP06

Hey Abesse,

Oh, I see what you mean here. Actually, if you look closer - it's the same correct video about "Fetching Items from a ManyToMany Collection", but it just has a wrong numbering :)

We'll fix numbering soon, thanks for this report!

Cheers!

Thank you.

Hi.
I have the following ManyToMany relationship:

Posts - Tags.

# AppBundle/Entity/Post
    /**
     * @ORM\ManyToMany(targetEntity="Tag", inversedBy="posts")
     * @ORM\JoinTable(name="post_tag")
     */
    private $tags;

    public function __construct() { $this->tags = new ArrayCollection(); }

    public function addTags(Tag $tag)
    {
    if($this->tags->contains($tag)){ return; }
    $this->tags[] = $tag;
    }

    /**
     * @return ArrayCollection|Tag[]
     */
     public function getTags() { return $this->tags; }

     /**
      * @param ArrayCollection $tags
      * @return Post
      */
      public function setTags($tags)
      {
    $this->tags = $tags;
    return $this;
      }

# AppBundle/Entity/Tag

/**

 * @ORM\ManyToMany(targetEntity="Post", mappedBy="tags")
 * @ORM\JoinTable(name="post_tag")
 */
private $posts;

public function __construct() { $this->posts = new ArrayCollection(); }

public function addPosts(Post $post)

{
    if($this->posts->contains($post)){
        return;
    }
    $this->posts[] = $post;
}

/**

 * @return ArrayCollection|Post[]
 */
 public function getPosts() { return $this->posts; }

 /**
  * @param ArrayCollection $posts
  */
 public function setPosts($posts)
 {
$this->posts = $posts;
return $this;
 }

I have a CRUD controller for my Post entity, generated with $ php bin/console doctrine:generate:crud

I have a PostType form, generated with $ php bin/console doctrine:generate:form AppBundle:Post

All I need is to be able to attache, for each new post that I create, a list of corresponding tags. I want to add the tags, by using select2 jquery plugin. ( https://select2.github.io/ ).

My problem is that I can't figure out a way to get all the tags available in the database, and put them in a select html element, in the /post/new template. Or better I should say that I implemented a way, but I have the feeling it's not the right way to do it, as when I click the "Create" button, to create a new post, my browser freezes (firefox), chrome is behaving almost the same, when I try to print_r($form->getData()).

# AppBundle/Form/TagType

$builder->add('name');

# AppBundle/Form/PostType

$builder->add(

$builder->create('tags', FormType::class, ['by_reference'=>false]) ->add(

'tag',EntityType::class,[

                    'class' => 'AppBundle:Tag',
                    'placeholder' => ' ',
                    'query_builder' => function (EntityRepository $er) {
                        return $er->createQueryBuilder('t')
                            ->orderBy('t.name', 'ASC');
                    },
                    'choice_label' => 'name',
                ])
        );

# app/Resources/views/post/new.html.twig

<div class="form-group">

            {{ form_label(form.tags.tag) }}
            {{ form_errors(form.tags.tag) }}
            {{ form_widget(form.tags.tag, { attr: { class: 'form-control select2-multi', title:'Choose a Tag', multiple:'multiple' } }) }}
        </div>

# AppBundle/Controller/PostController

/**

 * Creates a new Post entity.
 *
 * @Route("/new", name="post_new")
 * @Method({"GET", "POST"})
 */
public function newAction(Request $request)
{

    $post = new Post();
    $form = $this->createForm('AppBundle\Form\PostType', $post);
    $form->handleRequest($request);
    if ($form->isSubmitted() && $form->isValid()) {
        $tag = $post->getTags();
        echo var_dump($tag);die;

}
}

In `PostController` I need to get all the tags sent through the /post/new form, explode them, and then add them to the $post object, then save the $post object to the database.

Right now, as I already said, if I run this in the browser, I get a HUGE representation of the form

What I'm doing wrong?

Here's a part of the output: http://imgur.com/t6TXo9Q

Sorry for this long post, but I have no more solutions ,and thanks for any tip.

Hey Dan!

Ok! A few things:

1) If you can, install XDebug. Or, instead of using print_r, use dump(). What's happening is that when you print_r the tags, you're expecting an array of Tag objects. But in fact, it's an ArrayCollection of Tag objects... and also that ArrayCollection contains a reference to the database connection... and a ton of other stuff. The tl;dr is that if you try to print_r certain objects, they will print forever and ever... and kill your browser :). If you install XDebug or (better) use Symfony's dump(), it avoids this.

2) Basically, you're building your "select" element correctly, by using the EntityType for AppBundle:Tag Though, you can simplify your builder code (I don't know if this is the problem, but it looks nicer):

# AppBundle/Form/PostType
$builder->add( 'tags', EntityType::class, [
    'class' => 'AppBundle:Tag',
    'placeholder' => ' ',
    'query_builder' => function (EntityRepository $er) {
        return $er->createQueryBuilder('t')
            ->orderBy('t.name', 'ASC');
    },
    'choice_label' => 'name',
    // these are important: multiple true is needed to make this a multi-select box, and allow the user
    // to select multiple tags (important, even if you replace the UI with select 2
    'multiple' => true,
    // this says to render as a select, not checkboxes
    'expanded' => false,
]);

NOTICE that I added multiple => true and expanded => false options!

Then, you should simply be printing {{ form_widget(form.tags) }}.

3) Because your PostType is bound to a Post object, and because your PostType has a tags field that uses the EntityType (and because this corresponds with the tags property that you ultimately want to update)... you basically shouldn't need to do anything in your controller. What I mean is:

/**
 * Creates a new Post entity.
 *
 * @Route("/new", name="post_new")
 * @Method({"GET", "POST"})
 */
public function newAction(Request $request)
{

    $post = new Post();
    $form = $this->createForm('AppBundle\Form\PostType', $post);
    $form->handleRequest($request);
    if ($form->isSubmitted() && $form->isValid()) {
        // $post->getTags() will already, at this point, contain the correct
        // array of Tag objects that was selected
        // you can just save the Post to Doctrine now
        $em = $this->getDoctrine()->getManager();
        $em->persist($post);
        $em->flush();
        
        // redirect
    }
}

Let me know if this helps! I would try it first without select2 (but using that shouldn't make any difference). What you have here is a pretty traditional ManyToMany form setup - it should end up looking similar to what we have here: http://knpuniversity.com/screencast/collections/entity-type-checkboxes

Cheers!

Wo hoooo! You're a life saviour! It worked! Many thanks!

Hi Guys:

how does the view know genusScientist.id is User ID not genus ID

{% for genusScientist in genus.genusScientists %}
                            <li class="list-group-item">
                                <a href="{{ path('user_show', {
                                    id : genusScientist.id
                                }) }}">
                                    {{ genusScientist.fullName }}
                                </a>
                            </li>
                        {% endfor %}

Is it because of this?

/**
     * @return ArrayCollection|User[]
     */
    public function getGenusScientists()
    {
        return $this->genusScientists;
    }

If this is the reason, then I ArrayCollection| Genus [], it would give me genus ID instead. or does it works?

Hey Jian,

If you're talking about PhpStorm autocompletion in templates - yes, it's due to that annotation: "@return ArrayCollection|User[]" for getGenusScientists(). And yes, if you change it to "@return ArrayCollection|Genus[]" (what is not a good idea because getGenusScientists returns collection of *User* not Genus) - you'll get autocompletion for Genus entity instead of User in the template. But it will be just an autocompletion, you still will have *User* object which is autocompleted as Genus object, because there's no magic, getGenusScientists() return collection of genusScientists, i.e. users according to the Doctrine mapping for Genus::$genusScientists property.

P.S. if you want to get Genus ID in that for loop, you can call it on genus variable: {{ genus.id }}.

Cheers!

Thank you Victor! you are always been helpful :)

Hi guys:

I tried to dump the user object. And I could not find any ArrayCollection inside studiedGenuses.
as you can see -elements: [] is empty
How does symfony do the magic and accessing genusStudied.name?

array:2 [▼
  "user" => User {#353 ▼
    -id: 74
    -email: "aquanaut4@example.org"
    -password: "$2y$13$XuPa.HYwBc23Dwa6FlaN3Op4f3J4kpMcdGbMb5/PELlIrgxb9elxq"
    -plainPassword: null
    -roles: []
    -isScientist: true
    -firstName: "Hector"
    -lastName: "Wisozk"
    -avatarUri: "http://lorempixel.com/100/100/abstract/?37466"
    -universityName: "Blanda-O'Conner University"
    -studiedGenuses: PersistentCollection {#393 ▼
      -snapshot: []
      -owner: User {#353}
      -association: array:17 [ …17]
      -em: EntityManager {#282 …11}
      -backRefFieldName: "genusScientists"
      -typeClass: ClassMetadata {#355 …}
      -isDirty: false
      #collection: ArrayCollection {#394 ▼
        -elements: []
      }
      #initialized: false
    }
  }
  "app" => AppVariable {#413 ▶}
]

Hey Jian!

When you haven't hydrated a relationship of an object (in this case User - StudiedGenuses), Doctrine creates and sets a "Proxy" into that property via "Reflection" by default, so when you use that property, it magically fetches and hydrates it on the fly with the proper entity object, and then, executes the method you called.
That's why you can see all those extra fields like "initialized"

I hope it helps you ;)

Have a nice day!

Thank you so much, I understand it now Cheer!

Hey folks,

thanks for this awesome site & your style.

Greetings from Germany

Hey Ronny,

Thanks for your warm words!

Cheers!

Haha, cheers! You rock for saying so! Cheers from Michigan, USA!