How to fetch class instead of array in Doctrine 2

Question

I am able to fetch my data from database by using this structure:

$user = $this->getDoctrine()
->getRepository('AcmeDemoBundle:Emails')
->find(8081);

When I do that, I am able to get my data like this:

$user->getColumnNameHere();

Basically, I am able to use Entity Class.

But if I want to use QueryBuilder instead of find I am only getting associative arrays.

$product->createQueryBuilder('p')
        ->setMaxResults(1)
        ->where('p.idx = :idx')
        ->select('p.columnNameHere')
        ->setParameter('idx', 8081)
        ->orderBy('p.idx', 'DESC')
        ->getQuery();
        $product = $query->getResult();

$product returns as array. Is it possible to fetch it with Entity Manager Class? If yes, how?

I digg the documentation but it seems not possible or not exist in the doc or I'm just blind :)

Florian Klein · Accepted Answer · 2013-02-12T08:48:42.173

Yes you can, usually using:

$repository
    ->createQueryBuilder('p')
    ->getQuery()
    ->execute()
;

This should return you an array of entities.

If you want to get a single entity result, use either getSingleResult or getOneOrNullResult:

$repository
    ->createQueryBuilder('p')
    ->getQuery()
    ->getOneOrNullResult()
;

Warning: These method can potentially throw NonUniqueResultException.

Edit: Ok, so the question was about partial objects: http://docs.doctrine-project.org/en/latest/reference/partial-objects.html

ismaail E.G. · Answer 2 · 2012-08-20T21:24:45.633

18

you can get an object instead of array by using "Partial Objects".

here is a tested example with DoctrineORM 2.2.2:

// create query builder
// $em is the EntityManager
$qb    = $em->createQueryBuilder();

// specify the fields to fetch (unselected fields will have a null value)
$qb->select  ('partial p.{id,pubDate,title,summary}')
   ->from    ('Project\Entity\Post', 'p')
   ->where   ('p.isActive = 1')
   ->orderBy ('p.pubDate', 'desc');

$q      = $qb->getQuery();

$result = $q->getResult();
var_dump($result); // => object

edited Aug 20 '12 at 21:24

answered Aug 20 '12 at 20:14

ismaail E.G.

419
5
16

@user1191081 can give code example of using **Joins** where this doesn't work, thanks. – ismaail E.G. Mar 04 '14 at 15:00
What I needed. Thanks – Aysennoussi Oct 08 '15 at 20:08

score 10 · Answer 3 · answered Nov 07 '15 at 21:28

10

If you wish to return an object from your original query:

    $product->createQueryBuilder('p')
    ->setMaxResults(1)
    ->where('p.idx = :idx')
    ->select('p.columnNameHere')
    ->setParameter('idx', 8081)
    ->orderBy('p.idx', 'DESC')
    ->getQuery();
    $product = $query->getResult();

Remove this line

->select('p.columnNameHere')

As soon as you use select, it will return an array...

answered Nov 07 '15 at 21:28

HappyCoder

5,985
6
42
73

The question-related code itself was about loading as less data as possible so I suppose it's not an appropriate solution. – igronus Feb 17 '22 at 16:34

score 4 · Answer 4 · edited Jun 20 '20 at 09:12

4

getResult() method returns a collection (an array) of entities. Use getSingleResult() if you're going to fetch only one object.

EDIT:

Oh, I just noticed that you want to fetch a single field of a single object. Use getSingleScalarResult() as @Florian suggests.

edited Jun 20 '20 at 09:12

Community

1
1

answered May 07 '12 at 12:31

Crozin

43,890
13
88
135

No, i will fetch few columns not one. The query in this question is just an example. Not all rows and not one row. – flower58 May 07 '12 at 12:35
2

I think you mix the idea of column, row and entity. What @Crozin says is right. – Florian Klein May 07 '12 at 12:39
Moreover, If you want to fetch only one column, then use `getSingleScalarResult`. – Florian Klein May 07 '12 at 12:40
@Florian, Yes and no. The aquery in this question is just an example. Lets say i want to fetch 4 column. But i dont want to fetch with arrays i want to fetch with Entity Class? Like `$result->getColumn();` instead of `$result['column'];` I am missing something here so lighting me. :) – flower58 May 07 '12 at 12:43
Ha, ok :) I think you cannot hydrate an entity if you dan't have all the columns in the resultset. – Florian Klein May 07 '12 at 12:45
1

Using `QueryBuilder`, it should always fetch all columns for a given entity. – Florian Klein May 07 '12 at 12:46
If you really want to partially hydrate your entity, use http://docs.doctrine-project.org/projects/doctrine-orm/en/2.0.x/reference/partial-objects.html – Florian Klein May 07 '12 at 12:47

How to fetch class instead of array in Doctrine 2

4 Answers4

EDIT:

Linked