Symfony Query in controller

Question

$query = $em->query("
    SELECT c.id AS id
    FROM collectif c, zone z
    WHERE
        c.zone_id = z.id
    AND z.label = '$zone'
    ANDc.collectif = '$collectif'
");

$c = $query->fetchAll();
$idc = $c['id'];

I have this query that returns a single line, Symfony shows me an error as what variable id undefined

NB: I know that's don't respect the concept of Symfony [MVC] but it's for a particular reason so if someone can tell me how I can resolve this problem

Thank you

Very curious what your "particular reason" is. It's probably your real problem for which you should be asking a question on how to resolve it. — Oldskool
– Oldskool, Commented Jul 26, 2017 at 20:36
It's not to show a bad example that I specify here that it's a particular reason, I used a request in a controller — DjibJoker
– DjibJoker, Commented Jul 26, 2017 at 21:17
z.label = '$zone' and c.collectif = '$collectif' - please don't do this. please create parameters and set them on your query...it will be a lot safer that way — Jason Roman
– Jason Roman, Commented Jul 26, 2017 at 21:29

Grzegorz Gajda · Accepted Answer · 2017-07-26 20:33:01Z

2

$query->fetchAll() should return numeric array of elements so key id does not exists. You should try $c[0]['id'] to get value.

answered Jul 26, 2017 at 20:33

Grzegorz Gajda

2,4842 gold badges18 silver badges23 bronze badges

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

Comments

Alvin Bunk · Accepted Answer · 2017-07-26 20:46:23Z

0

If you'd rather use the results in the assocative way, you can use fetchAssoc() instead:

$c = $query->fetchAssoc();
$idc = $c['id'];

Here is the documentation for reference: http://docs.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/data-retrieval-and-manipulation.html#fetchassoc

I'm just giving an alternate way to do this.

answered Jul 26, 2017 at 20:46

Alvin Bunk

7,8123 gold badges31 silver badges48 bronze badges

3 Comments

Alvin Bunk Over a year ago

Did this help at all?

DjibJoker Over a year ago

No, it did not work, the solution is : $query->fetchAll();$c[0]['id'];

Alvin Bunk Over a year ago

But as per your original post you wanted to use $c['id'], so in that case if you use fetchAssoc(0) instead, then you can use $c['id'] like I've indicated in my answer. I use fetchAssoc() exactly in this way, so I know it works. I was only trying to provide you with a better solution.

Collectives™ on Stack Overflow

Symfony Query in controller

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related