symfony2 execute CREATE table query into controller

Question

In my symfony2 application there is a need to create a table on the basis of user selection. if user selects yes then a new table will be create into database.

I am trying to create table query into symfony2 controller but getting error message

Error: Expected SELECT, UPDATE or DELETE, got 'CREATE'

Is it any way to run create table query into controller.

it's a very bad practice why you wanna do that in the controller you can just run this command : php app/console generate:doctrine:entity — Anas EL KORCHI
– Anas EL KORCHI, Commented Jan 14, 2016 at 11:58

cn0047 · Accepted Answer · 2016-01-14 15:07:34Z

0

I know that it's BAD practice, but it just a single working way that i know.

$em = $this->getDoctrine()->getManager();
$em->getConnection()->exec('create table tmp (id int)');

answered Jan 14, 2016 at 15:07

cn0047

17.2k7 gold badges61 silver badges75 bronze badges

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

Collectives™ on Stack Overflow

symfony2 execute CREATE table query into controller

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related