How do I delete an entity from symfony2

Question

My first symfony2 project is a list of guests (invited in an event) stored in a database. I have

created the entity class Guest with all variables for them (id, name, address, phone number etc.)
created the schema in the mysql db
created a route for "adding a guest" to a twig template
created a formType

and finally a "createGuest" method in the Controller and everything works fine.

I can't manage to remove a guest from the database. I have read every tutorial in the web, including the official Symfony2 book; all that it says is :

Deleting an Object

Deleting an object is very similar, but requires a call to the remove() method of the entity manager:

$em->remove($product);
$em->flush();

It does not say anything more than that (even the "Update an object" section is missing documentation) on how to connect the controller deleteAction($id) with the twig template. What I want to do is to list all guests with a viewGuests action and a viewGuests twig template, having a delete icon next to every row, which you should click to delete an entry. Simple, but I cannot find any documentation and do not know where to start from.

public function deleteGuestAction($id)
    {
        $em = $this->getDoctrine()->getEntityManager();
        $guest = $em->getRepository('GuestBundle:Guest')->find($id);

        if (!$guest) {
            throw $this->createNotFoundException('No guest found for id '.$id);
        }

        $em->remove($guest);
        $em->flush();

        return $this->redirect($this->generateUrl('GuestBundle:Page:viewGuests.html.twig'));
    }

Actually there is no error. I do not know how to interface the twig template. That means: you have a table that in each row a guest and some information (name, surname, phone number etc.) is displayed along with an <img> icon. I want to click on that button and get the row deleted from the database. — Radolino
Is your Guest well loaded after the find() ? Else, try this prototype public function deleteGuestAction(Guest $guest) and delete your two first lines. Try also to var_dump your $guest — Jérôme Boé
Thanks for the replies. How should I send the Guest.name from the twig template to the controller ? — Radolino
This one gives me Controller "xxxxxBundle\Controller\PageController::deleteGuestAction()" requires that you provide a value for the "$id" argument (because there is no default value or because there is a non optional argument after this one). — Radolino

Jérôme Boé Jérôme Boé · Accepted Answer · 2012-08-04T16:01:35

Symfony is smart and knows how to make the find() by itself :

public function deleteGuestAction(Guest $guest)
{
    if (!$guest) {
        throw $this->createNotFoundException('No guest found');
    }

    $em = $this->getDoctrine()->getEntityManager();
    $em->remove($guest);
    $em->flush();

    return $this->redirect($this->generateUrl('GuestBundle:Page:viewGuests.html.twig'));
}

To send the id in your controller, use {{ path('your_route', {'id': guest.id}) }}

How do I delete an entity from symfony2

3 Answers