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- gt remove  product    em- gt 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- gt getDoctrine  - gt getEntityManager             guest    em- gt getRepository  GuestBundle Guest  - gt find  id            if    guest                throw  this- gt createNotFoundException  No guest found for id    id                       em- gt remove  guest            em- gt flush             return  this- gt redirect  this- gt generateUrl  GuestBundle Page viewGuests html twig

User · Accepted Answer

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}) }}

User · Answer

From what I understand  you struggle with what to put into your template   I ll show an example    lt ul gt         for guest in guests         lt li gt    guest name     lt a href     path  your delete route name    id   guest id       gt   DELETE   lt  a gt  lt  li gt         endfor     lt  ul gt    Now what happens is it iterates over every object within guests  you ll have to rename this if your object collection is named otherwise    shows the name and places the correct link  The route name might be different

User · Answer

DELETE FROM     WHERE id       protected function templateRemove  id                em    this- gt getDoctrine  - gt getManager                 entity    em- gt getRepository  XXXBundle Templates  - gt findOneBy array  id    gt   id                 if   entity    null                    em- gt remove  entity                    em- gt flush

[symfony] How do I delete an entity from symfony2

Examples related to symfony

Examples related to doctrine