如何以关联数组的形式获取 Doctrine2 结果对象？

发布于 2024-12-02 02:36:11 字数 570 浏览 2 评论 0原文

我有一个简单的实体，它是一个保存用户数据的表我想将特定用户的所有列作为数组获取，然后对它们进行 json_encode，但我得到的是一个实体对象，我必须对每个值使用 get 方法。我只想要一个用户表值的关联数组。我尝试过但不起作用的代码（返回实体对象）如下： 1.

$qb = $this->em->createQueryBuilder();
$qb->add('select', 'a')
->add('from', 'Entities\Adminprofile a')
->add('where', 'a.userid = 3333');
$accounts = $qb->getQuery()->getResult();

$account = $this->em->getRepository('Entities\Adminprofile')->findOneBy(
array('userid' => '3333'));

PS：我使用的是z2d2项目，该项目是将doctrine2集成到Zend框架中。

原文

I have a simple entity which is a table holding my user data
and I want to fetch all columns of a specific user as an array and then json_encode them but what I get is an entity object which I will have to use get method for every value. I just want an associative array of my user table values.
The codes I tried and didn't work (returned entity object) are as follows:
1.

$qb = $this->em->createQueryBuilder();
$qb->add('select', 'a')
->add('from', 'Entities\Adminprofile a')
->add('where', 'a.userid = 3333');
$accounts = $qb->getQuery()->getResult();

$account = $this->em->getRepository('Entities\Adminprofile')->findOneBy(
array('userid' => '3333'));

PS: im using z2d2 Project,which is doctrine2 integration into Zend framework.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

素年丶 2024-12-09 02:36:11

当您执行 $accounts = $qb->getQuery()->getResult(); 时，您传递给 getResult 的参数告诉它如何合并将返回的结果集。

数组水合

如果你想要数组，那么你应该为数组水合Doctrine\ORM\Query::HYDRATE_ARRAY传递CONSTANT。

$accounts = $qb->getQuery()->getResult( Doctrine\ORM\Query::HYDRATE_ARRAY );

如果您使用findOneBy()，那么它将始终返回一个实体。由于 find 工作原理的内部原因，除了返回实体之外，您不能通过任何其他方式告诉它进行水合。

在这种情况下，您需要做的是在实体内部创建一个 getValues() 方法，该方法返回实体的数组，如下所示：

 public function getSimpleValues(){
     return array(
        'id'      => $this->getId(),
        'lft'     => $this->getLft(),
        'rgt'     => $this->getRgt(),
        'name'    => $this->getName(),
        'md5Name' => $this->getMd5Name(),              
        'owner'   => $this->getOwner()->getId(),
        'etag'    => $this->getEtag()
    );
}

Hydration API 文档：http://www.doctrine-project.org/api/orm/ 2.1/命名空间-Doctrine.ORM.Internal.Hydration.html

When you do $accounts = $qb->getQuery()->getResult(); the argument you pass to getResult tells it how to hydrate the result set which is will return.

Array Hydration

If you want arrays, than you should pass the CONSTANT for array hydrations Doctrine\ORM\Query::HYDRATE_ARRAY.

$accounts = $qb->getQuery()->getResult( Doctrine\ORM\Query::HYDRATE_ARRAY );

If you are using findOneBy() then it will always return an entity. Due to the internals of how find works, you cannot tell it to hydrate by any other means other than to return entities.

In this scenario, what you need to do is create a getValues() method inside of your entity which returns an array of your entity, like this:

 public function getSimpleValues(){
     return array(
        'id'      => $this->getId(),
        'lft'     => $this->getLft(),
        'rgt'     => $this->getRgt(),
        'name'    => $this->getName(),
        'md5Name' => $this->getMd5Name(),              
        'owner'   => $this->getOwner()->getId(),
        'etag'    => $this->getEtag()
    );
}

Hydration API Docs: http://www.doctrine-project.org/api/orm/2.1/namespace-Doctrine.ORM.Internal.Hydration.html

回复收藏 0 原文

野却迷人 2024-12-09 02:36:11

您还可以使用 getArrayResult() 作为传入常量以获取数组的快捷方式：

$accounts = $qb->getQuery()->getArrayResult();

You can also use getArrayResult() as a shortcut to passing in the constant to get an array back:

$accounts = $qb->getQuery()->getArrayResult();

回复收藏 0 原文

〃温暖了心ぐ 2024-12-09 02:36:11

您应该使用包含值 2 的常量，它是内置的，您可以在查询的末尾部分这样做

$qb->getQuery()->getResult( Doctrine\ORM\Query::HYDRATE_ARRAY );

You should use constant containing value 2 and it is inbuilt, you can do it like this at the end part of your query

$qb->getQuery()->getResult( Doctrine\ORM\Query::HYDRATE_ARRAY );

回复收藏 0 原文

卷耳 2024-12-09 02:36:11

$data = $this->entity->findOneBy(array('key' => $value));

$hydrator = new \DoctrineModule\Stdlib\Hydrator\DoctrineObject($this->_em, $entity_name);

$array = $hydrator->extract($data);

$data = $this->entity->findOneBy(array('key' => $value));

$hydrator = new \DoctrineModule\Stdlib\Hydrator\DoctrineObject($this->_em, $entity_name);

$array = $hydrator->extract($data);

回复收藏 0 原文

~没有更多了~