如何使用symfony2对搜索结果进行分页？

Question

I am working on a project using symfony2. I already have my search function and it is already working. But what I want is to have pagination on the search results since there are times that there are a lots of data being retrieve. How can I possibly do it?

Here is my code :

public function searchAction (Request $request) {

        $request = $this->getRequest();
        $data = $request->get('search');

        $em = $this->getDoctrine()->getManager();
        $query = $em->createQuery (
            'SELECT a,b,c FROM SampleBundle:transactDetail a
            JOIN a.transact b
            JOIN b.transactType c
            WHERE b.pNumber LIKE :data
            OR b.senderId LIKE :data'
        )
        ->setParameter('data', "%$data%");
        $result = $query->getResult();

        if ($result == null ) {
            return $this->render('SampleBundle:Sample:noresult.html.twig');
        }
        return $this->render('SampleBundle:Sample:search.html.twig', array('result' => $result));
    }

Thanks in advance.

Answer 1

This is an example of your code with Paginator :

public function searchAction(Request $request, $firstResult = 0, $maxResults = 100)
{
    $request = $this->getRequest();
    $data = $request->get('search');

    $em = $this->getDoctrine()->getManager();
    $query = $em->createQuery(
        'SELECT a,b,c FROM SampleBundle:transactDetail a
            JOIN a.transact b
            JOIN b.transactType c
            WHERE b.pNumber LIKE :data
            OR b.senderId LIKE :data'
    )
        ->setParameter('data', "%$data%")
        ->setFirstResult($firstResult)
        ->setMaxResults($maxResults);

    $result = new Paginator($query);

    if ($result == null) {
        return $this->render('SampleBundle:Sample:noresult.html.twig');
    }

    return $this->render('SampleBundle:Sample:search.html.twig', array('result' => $result));
}

And if you would like to count the total just count($result);.
Paginator has Countable et IteratorAggregate interfaces.
So you can loop on your result without problem.