Symfony2，PagerFanta结果

Question

如何从Symfony2.1.1中的PagerFanta中获取结果作为数组？

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

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
                    ...
                    ...
                    ...

我想以getQuery->getArrayResult();的身份获得结果

Answer 1

1. 我将执行查询

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

• Use ArrayAdapter

$adapter =新Pagerfanta($adapter);；$pagerfanta =新ArrayAdapter($array)

Answer 2

您必须将消隐模式设置为从适配器进行查询：

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