How to create table with raw SQL in symfony controller and get a response

Question

I have a controller where I create a table with doctrine raw sql:

$sql = 'CREATE TABLE IF NOT EXISTS testTable
(id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id))
DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB';
$em = $this->getDoctrine()->getManager();

$statement = $em->getConnection()->prepare($sql);
$statement->execute();

Yet I cannot seem to figure out how to get a response to know if it executed successfully. Any ideas?

If there is a problem then an exception will be thrown. No exception means that the table was created. In other words, no need to do or check anything. Though execute does return true on success. — Cerad
– Cerad, Commented Apr 14, 2017 at 15:36

Alvin Bunk · Accepted Answer · 2017-04-14 15:57:36Z

2

Cerad is correct. Get the errorCode and check if it is '0000'. I'm using MySQL and I get '0000' as an errorCode if it ran successfully.

...
$statement->execute();

var_dump( $statement->errorCode() );   // Get the error code.

I think that should work for you.

For reference I got that from the Doctrine API documentation and I tried it out. Here is the link for reference:

http://www.doctrine-project.org/api/dbal/2.4/class-Doctrine.DBAL.Driver.Statement.html

edited Apr 14, 2017 at 15:57

answered Apr 14, 2017 at 15:32

Alvin Bunk

7,8123 gold badges31 silver badges48 bronze badges

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

Comments

Marko Živković · Accepted Answer · 2017-04-14 14:30:13Z

1

Response should be in your "statement" variable, add a: var_dump($statement); and see.

answered Apr 14, 2017 at 14:30

Marko Živković

915 bronze badges

Collectives™ on Stack Overflow

How to create table with raw SQL in symfony controller and get a response

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