开发者

Doctrine 2 configuration with MySQL

开发者 https://www.devze.com 2023-01-10 13:52 出处:网络
I\'m busy with Doctrine2, but I can\'t get it to work. Everything works fine out of t开发者_如何转开发he box with sqlite. But when I try to change the database in the sandbox demo to MySQL I\'m gett

I'm busy with Doctrine2, but I can't get it to work.

Everything works fine out of t开发者_如何转开发he box with sqlite. But when I try to change the database in the sandbox demo to MySQL I'm getting confused. This is what I did. I created a database, changed the connectionOptions array to:

$connectionOptions = array(
    'driver' => 'pdo_mysql',
    'path' => __DIR__.'/mysql.php'
);

the 'path' entry exists and looks like this:

$connectionParams = array(
    'dbname' => 'db_test',
    'user' => 'test',
    'password' => 'p4ssw0rd',
    'host' => 'localhost',
    'driver' => 'pdo_mysql',
);

When I run the command to create the database:

 php doctrine orm:schema-tool:create

Which gives me the error:

 no database selected

Seems to be a clear message. But how can I change the databasename, cause the one specified in mysql.php (see above) does excist and should be the one it uses! I searched for it for hours, but I cannot find it anywhere.


Is this the Doctrine 2 sandbox? This worked for me:

// sandbox/bootstrap.php

$connectionOptions = array(
    'driver'   => 'pdo_mysql',
    'host'     => '127.0.0.1',
    'dbname'   => 'your_database_name',
    'user'     => 'username',
    'password' => 'password'
);

$em = EntityManager::create($connectionOptions, $config);


The Cookbook code is also available for download. See here for the details. Look at cli-config.php after you download it.

0

精彩评论

暂无评论...
验证码 换一张
取 消