A symfony2 bundle for MeekroDB.
Add the bundle to your composer.json
{
"require": {
"...",
"hamaryuginh/meekrodb-bundle": "dev-master"
}
}
Run composer install
php composer.phar install
Enable the bundle in the kernel
<?php
// app/AppKernel.php
public function registerBundles()
{
$bundles = array(
// ...
new Hamaryuginh\MeekroDbBundle\HamaryuginhMeekroDbBundle(),
);
}
Add configuration to config.yml.
# config.yml
hamaryuginh_meekro_db:
meekrodb:
connections:
my_db_host_1:
host: database_host # default value is "localhost"
port: 6666 # default value is 3306
encoding: utf8 # default value is utf8
db_name: database_name
user: database_user
password: user_password # default value is ""
my_db_host_2: # you can set multiple host
...
Now you're all set, you can now use the bundle as following:
<?php
// In a controller
$dbManager = $this->get('hamaryuginh.meekro_db');
$myDbHost = $dbManager->get('my_db_host'); // The name of the connection
$account = $myDbHost->query("SELECT * FROM accounts WHERE username=%s", 'Joe');