Symfony/Doctrine: fetching data as object , still get array

Question

I have in my controller $id it's a foreign key

  $query = $em->getRepository('SurgeryPatientBundle:Patients')->findPatientByUserID($id);

And in my repository file this function

 public function findPatientByUserID($id)
{

    return $this->getEntityManager()
        ->createQuery('SELECT p FROM SurgeryPatientBundle:Patients p WHERE p.user ='.$id.'')
        ->execute();

}

I want get an instance of object but still get an array. Query with find($id) works good

edit Problem solves , I'm so stupid , I had invoked to $query[0]

Mirage · Accepted Answer · 2013-01-31 01:08:21Z

1

You can use $query->getSingleResult(); as well

see here

http://docs.doctrine-project.org/en/2.1/reference/dql-doctrine-query-language.html#query-result-formats

answered Jan 31, 2013 at 1:08

Mirage

31.7k64 gold badges173 silver badges266 bronze badges

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

Comments

MrGlass · Accepted Answer · 2013-01-30 17:09:45Z

0

If you want to grab the object, you shouldn't be using DQL. Doctrine entities have a find function that takes care of this for you.

Instead of all that code, you can just use (in your controller):

$em->getRepository('SurgeryPatientBundle:Patients')->find($id);

DQL is very powerful, but for simple lookups like this using the built in find methods will be more efficient & provide the entities as doctrine objects.

answered Jan 30, 2013 at 17:09

MrGlass

9,27217 gold badges67 silver badges94 bronze badges

3 Comments

mpm Over a year ago

then findByUser should work if you pass a user instance i think.

konadrian Over a year ago

It dosen't works I still get this array(1) { [0] => class Surgery\PatientBundle\Entity\Patients#914 (29) . When I find a primary key (find($id)) I get an object

Fusselchen Over a year ago

findByUser($userObject) will return always an array. But inside your array is the Patients Object. If you need a function returning only the Patient, just wrap it into a own function returning the first element or null, but be carfull nobody ensures that your User has only one Patient. If a user can have more than one Patient it makes no sense to return one Object by querying a one to many relation.

Collectives™ on Stack Overflow

Symfony/Doctrine: fetching data as object , still get array

2 Answers 2

Comments

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Related