README

A symfony2 bundle for MeekroDB.

Installation

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(),
 );
}

Configuration

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:

Use

<?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');