1

I've been working on trying to setup a blog archive for a blog site where the use clicks on a date and the corresponding posts appear. (see image) I understand I need to retrieve all my blog posts and sort by date, but the steps after that are foggy to me. Taking that data then sorting it by month/year and passing it to a template is the part I am having trouble with.

Can someone shed some light on what I am doing wrong or provide a simple working example?

enter image description here

What I have thus far:

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

//        $query = $em->getRepository('AcmeProjectBundle:Blog')
//            ->findAll();

        $blogs = $em->getRepository('AcmeProjectBundle:Blog')
            ->getLatestBlogs();

        if (!$blogs) {
            throw $this->createNotFoundException('Unable to find blog posts');
        }

        foreach ($blogs as $post) {
            $year = $post->getCreated()->format('Y');
            $month = $post->getCreated()->format('F');
            $blogPosts[$year][$month][] = $post;
        }

//        exit(\Doctrine\Common\Util\Debug::dump($month));

        return $this->render('AcmeProjectBundle:Default:archive.html.twig', array(
            'blogPosts' => $blogPosts,
        ));
    }
DonCallisto
  • 29,419
  • 9
  • 72
  • 100
esteemed.squire
  • 524
  • 1
  • 7
  • 20

1 Answers1

1

You want to tell your archiveAction which month was actually clicked, so you need to one or more parameters to it: http://symfony.com/doc/current/book/controller.html#route-parameters-as-controller-arguments (I would do something like /archive/{year}/{month}/ for my parameters, but it's up to you.) Then when someone goes you myblog.com/archive/2014/04, they would see those posts.

Next, you want to show the posts for that month. For this you'll need to use the Doctrine Query builder. Here's one SO answer on it, but you can search around for some more that pertain to querying for dates. Select entries between dates in doctrine 2

Community
  • 1
  • 1
dkisselev
  • 120
  • 7
  • I can understand what you mean by the route part and adding $year and $month to the archive action parameters in the controller, but the twig part where to link the dates to the posts is where I'm unsure of how to proceed. – esteemed.squire Mar 30 '14 at 09:24