CODEWITHSUNDEEP
phpmysqlpdo
siannone
siannone

Reputation: 6763

PDO doesn't seem to create MySQL database

I'm trying to create a database using the following code:

// Set up DB connection and creates the DB
try {

    $connection = new \PDO(
            'mysql:host='.Settings\Database::$host.';',
            Settings\Database::$username,
            Settings\Database::$password);

    $connection->exec("CREATE DATABASE IF NOT EXISTS ".Settings\Database::$databaseName." CHARACTER SET utf8 COLLATION utf8_unicode_ci;");
} catch (\PDOException $exception) {

    die("Could not connect to database: ".$exception->getMessage());
}

The problem is that no database is being created and I receive no error except for the fact that when I try create a table with PDO i receive this error:

READ EDIT 2

Could not connect to database: SQLSTATE[HY000] [1049] Unknown database 'dbname'

Edit:

I have no problem manually creating the DB with phpMyAdmin and similars.

Edit 2:

Mistakenly I thought that the error was given by the CREATE TABLE... statement. Instead the error is returned by the die() function in the exception handling.

Upvotes: 2

Views: 627

Answers (1)

Bill Karwin
Bill Karwin

Reputation: 562230

Your call to exec() isn't throwing exceptions. You have to enable that for each PDO connection with an attribute like this:

$connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

If you were getting the error message from exec(), you would have seen this:

Could not connect to database: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATION utf8_unicode_ci' at line 1

The syntax for CREATE DATABASE uses the keyword COLLATE, not COLLATION.

See http://dev.mysql.com/doc/refman/5.6/en/create-database.html

Upvotes: 2

Related Questions