How to pass results from raw SQL query to view in Symfony2

Question

I have this code that uses a raw SQL query inside my controller:

        $sql1 = "SELECT completion_date FROM enviro_figures_upload GROUP BY YEAR(completion_date), MONTH(completion_date) DESC;";

        $activeDate = $this->getDoctrine()->getManager()->getConnection()->prepare($sql1);
        $activeDate->execute();
        $activeDate->fetchAll();

This code then passes the data to the view which is then used in a drop down date picker. However, no results are passed to the view even though running that SQL query on the database returns the results I need. What am I missing in order to pass this data to the view?

Seems work fine to me. How do you pass the data to the view? BTW: you can just do $this->get('database_connection')->fetchAll('...'); — Federkun
– Federkun, Commented Jan 4, 2015 at 10:56
Provide the relevant code how you are passing data to view ? — M Khalid Junaid
– M Khalid Junaid, Commented Jan 4, 2015 at 10:58

xurshid29 · Accepted Answer · 2015-01-04 11:08:20Z

2

$activeDate->execute(); $activeDate->fetchAll(); This code then passes the data to the view ...

this code doesn't pass the data to view, you have to pass the data to view by array option in render method..

something like this:

$sql1 = "SELECT completion_date FROM enviro_figures_upload GROUP BY YEAR(completion_date), MONTH(completion_date) DESC;";

$activeDate = $this->getDoctrine()->getManager()->getConnection()->prepare($sql1);
$activeDate->execute();

$result = $activeDate->fetchAll();

return $this->render('TEMPLATE_PATH', [
    'result' => $result
]);

answered Jan 4, 2015 at 11:08

xurshid29

4,2101 gold badge23 silver badges25 bronze badges

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

3 Comments

Karol Wojciechowski Over a year ago

Or just return array with data, and template name is equal to your action name.

qooplmao Over a year ago

Only if you are using the @Template annotation.

mickburkejnr Over a year ago

This is correct, and it was exactly what I was doing. The issue was down to a memory issue on my development server which was preventing the query to run correctly.

Collectives™ on Stack Overflow

How to pass results from raw SQL query to view in Symfony2

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related