Symfony2 Doctrine, remove useless array in query

Question

I have a query in a repository like :

        $qb->select('f.state as link')
            ->from('MyProjectBundle:Friend', 'f')
            ->where('CONDITIONS');
        return $qb->getQuery()->getResult();

So, this query return the state with you and a friend. In my controller i return :

return array('link' => $state);

$state is the result of my query. I can only have one result with this query, it's just the state with ONE other user. So, when i check the response, i have (in json) :

    {
    "link": [
        {
            "link": 1
        }
    ]    
   }

How can i remove the array [] in this json ? It's useless here.. Thanks !

return array(current($state)); ?

Fabien Papet
– Fabien Papet

2014-07-30 09:19:56 +00:00
Commented Jul 30, 2014 at 9:19 — Fabien Papet
– Fabien Papet, Commented Jul 30, 2014 at 9:19
Nice ! Answer my question if you want ;)

Clément Andraud
– Clément Andraud

2014-07-30 09:25:59 +00:00
Commented Jul 30, 2014 at 9:25 — Clément Andraud
– Clément Andraud, Commented Jul 30, 2014 at 9:25

Fabien Papet · Accepted Answer · 2014-07-30 09:37:31Z

1

As expected ;)
You can use return array(current($state));

answered Jul 30, 2014 at 9:37

Fabien Papet

2,3294 gold badges25 silver badges55 bronze badges

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

Comments

krichprollsch · Accepted Answer · 2014-07-30 09:58:06Z

1

You can use getSingleScalarResult() method as explained here :

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

$qb->select('f.state as link')
    ->from('MyProjectBundle:Friend', 'f')
    ->where('CONDITIONS');

return $qb->getQuery()->getSingleScalarResult();

answered Jul 30, 2014 at 9:58

krichprollsch

3912 silver badges7 bronze badges

Collectives™ on Stack Overflow

Symfony2 Doctrine, remove useless array in query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related