Doctrine2 query with QueryBuilder returns array instead of object

Question

I want to get doctrin2 query result in object format but it gives me in array format. I tried but I can't succeed.

This is demo query but if I want to apply similar types of join in another query than also requires results in object format but in all of them.

Can you have any solution?

return $this->createQueryBuilder("u")
->select("u.id as userid, up.id as profileid, u.username, u.email, u.isactive, up.firstname, up.lastname, up.profileimage, up.address, up.zipcode, up.biography")
->innerjoin("u.userprofile", "up")
->where("u.id = :userid")
->setParameter(":userid", $userid)
->getQuery()
->getResult();

ResultSet :

Array
(
    [userid] => 4
    [profileid] => 3
    [username] => Test user
    [email] => [email protected]
    [isactive] => 1
    [firstname] => MyFname
    [lastname] => MyLname
    [profileimage] => 5111ea998c9476c2231180050d5ad64dc3298fe0.jpeg
    [address] => My Address
    [zipcode] => 36102555
    [biography] => This is my first symfon2.3 project.
)

xurshid29 · Accepted Answer · 2014-11-06 06:33:34Z

3

May be it's because you 're not loading the object fully, as you're loading it partially. That's why ORM is converting it automatically. You can use partial keyword to force it to load as partial object, but be carefull.

answered Nov 6, 2014 at 6:33

xurshid29

4,2101 gold badge23 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Dipak Over a year ago

Thank you Xurshid, But can you give me example I try to found from google but can't understand.

xurshid29 Over a year ago

->select(['partial u.{id,...}']) - something like this.. I've never tried it, as it's not recommended by ORM.. You should better load it as full object..

Dipak Over a year ago

Thanks I have done it. Xurshid29 Can You help me my another issue which is bit more complex about custom authentication provider.

Dipak Over a year ago

Xurshid It requires to wait 90 minutes. I really appreciate your response and answer.

xurshid29 Over a year ago

@Dipakchavda The answer to your question will be very long, It's not good to post an unrelated answer to this question.. Did you look at this doc page?

|

Collectives™ on Stack Overflow

Doctrine2 query with QueryBuilder returns array instead of object

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related