Symfony JSON output including field name

Question

I'm trying to pull a value from my DB in the field 'action', it is a JSON string however I'm storing it as a single value for now, this is it:

'command'=>'get','target'=>'location'

However when I pull it from the DB it includes the field name, which I don't want, see below:

[{"action":"'command'=>'get','target'=>'location'"}]

My code is here:

$em = $this->getDoctrine()->getManager();   
    $query = $em->createQueryBuilder();
    $q = $query->select('z.action')
    ->from('AppBundle:ZeusUsers', 'z')
    ->where('z.id = ?1')
    ->setParameter(1, $id)
    ->getQuery();


    $action = $q->getResult();
    return new Response(json_encode($action));

So I just need to know how to grab the field value not including the field name?

LPodolski · Accepted Answer · 2015-04-04 09:31:00Z

1

try this method getSingleScalarResult()

but remember that if it wouldn't find anything it will throw exception

http://doctrine-orm.readthedocs.org/en/latest/reference/dql-doctrine-query-language.html#single-scalar-hydration

answered Apr 4, 2015 at 9:31

LPodolski

2,8884 gold badges24 silver badges25 bronze badges

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

Comments

Im0rtality · Accepted Answer · 2015-04-02 19:30:07Z

0

You want to use getSingleResult() instead of getResult() to get value of your field. It will throw exception if there are no results found or there are more than one result (setMaxResults(1) will remedy this part) though.

https://github.com/doctrine/doctrine2/blob/master/lib/Doctrine/ORM/AbstractQuery.php#L802

answered Apr 2, 2015 at 19:30

Im0rtality

3,5333 gold badges34 silver badges42 bronze badges

1 Comment

Ben Clarke Over a year ago

Doesn't seem to make a difference

Collectives™ on Stack Overflow

Symfony JSON output including field name

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related