如何将 Doctrine2 结果对象作为关联数组? [英] How to get a Doctrine2 result object as an associative array?

问题描述

我有一个简单的实体，它是一个包含我的用户数据的表格我想将特定用户的所有列作为数组获取，然后对它们进行 json_encode，但我得到的是一个实体对象，我必须对每个值使用 get 方法.我只想要一个用户表值的关联数组.我试过但没有用的代码(返回的实体对象)如下:1.

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', 'EntitiesAdminprofile a')
->add('where', 'a.userid = 3333');
$accounts = $qb->getQuery()->getResult();

2.

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

PS:我使用的是z2d2项目，它是将doctrine2集成到Zend框架中.

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

推荐答案

当你做 $accounts = $qb->getQuery()->getResult(); 你传递给的参数getResult 告诉它如何水合将返回的结果集.

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.

阵列水化

如果你想要数组，那么你应该传递 CONSTANT 用于数组水合 DoctrineORMQuery::HYDRATE_ARRAY.

If you want arrays, than you should pass the CONSTANT for array hydrations DoctrineORMQuery::HYDRATE_ARRAY.

$accounts = $qb->getQuery()->getResult(DoctrineORMQuery::HYDRATE_ARRAY);

$accounts = $qb->getQuery()->getResult( DoctrineORMQuery::HYDRATE_ARRAY );

如果您使用的是 findOneBy()，那么它将总是返回一个实体.由于 find 工作原理的内部结构，您不能告诉它通过返回实体以外的任何其他方式进行水合.

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.

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

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 文档:http://www.doctrine-project.org/api/orm/2.1/namespace-Doctrine.ORM.Internal.Hydration.html

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

这篇关于如何将 Doctrine2 结果对象作为关联数组?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！