Symfony + Doctrine how to display 5 latest records from database?

Question

symfony

How to display the last 5 records from a mySQL database in Symfony + Doctrine?
The controller has this code that displays all the records at once:

public function indexAction()
    {
        $em = $this->getDoctrine()->getManager();

        $posts = $em->getRepository('BlogBundle:Post')->findAll();

        return $this->render('post/index.html.twig', array(
            'posts' => $posts,
        ));
    }

How can you display exactly 5 records?

Answer 1

$em->getRepository('BlogBundle:Post')->findBy([condition], [sort => asc|desc], 5);