Symfony2, PagerFanta results

Question

How can I take a result as an array from PagerFanta in Symfony2.1.1 ?

        $adapter = new \Pagerfanta\Adapter\DoctrineORMAdapter($query);
        $pager = new \Pagerfanta\Pagerfanta($adapter);
        $pager->setMaxPerPage(45);
        $data = $pager->getCurrentPageResults();

Results of print_r($data);

ArrayIterator Object
(
    [storage:ArrayIterator:private] => Array
        (
            [0] => Trucking\MainBundle\Entity\Sparcs Object
                (
                    [id:Trucking\MainBundle\Entity\Sparcs:private] => 77940
                    [container:Trucking\MainBundle\Entity\Sparcs:private] => MEDUUUU
                    ...
                    ...
                    ...

I want to get results as getQuery->getArrayResult();

score 3 · Accepted Answer · edited Sep 12 '12 at 07:47

3

I will Do the query

$array = $query->getResult(Query::HYDRATE_ARRAY);

Use the ArrayAdapter

$adapter = new ArrayAdapter($array);
$pagerfanta = new Pagerfanta($adapter);

edited Sep 12 '12 at 07:47

j0k

22,600
28
79
90

answered Sep 12 '12 at 07:41

Max Małecki

1,700
2
13
18

This will get the whole result set from the database, not just the current page!!! – Goran Jurić Aug 23 '13 at 19:39
Yes it will. Working on Query is optimal. But @Dezigo want an array. – Max Małecki Aug 26 '13 at 09:34

score 0 · Answer 2 · answered Nov 26 '21 at 23:00

0

You must to set hydratation mode to Query from the adapter:

$adapter = new DoctrineORMAdapter($queryBuilder);
$adapter->getQuery()->setHydrationMode(Query::HYDRATE_ARRAY);
$pager = new Pagerfanta($adapter);

answered Nov 26 '21 at 23:00

Diego Malagón

81
2
6

Symfony2, PagerFanta results

2 Answers2