/**
* Test for MultiDB\DB
*
*/
require_once 'PDOWrapper.php';
$settings = array('blog' => array('host' => 'localhost', 'user' => 'root', 'password' => 'root', 'dbname' => 'blog'), 'store' => array('host' => 'localhost', 'user' => 'root', 'password' => 'root', 'dbname' => 'store'));
// Get an instance of the PDO DB wrapper class
$db = new MultiDB\DB($settings);
// Inject the wrapper object into the object that
// needs to communicate with the database
$example = new Example($db);
$post = $example->getPostById(2);
var_dump($post);
$customers = $example->getCustomers();
var_dump($customers);
$search = $example->searchPosts('honey');
var_dump($search);
class Example
{
private $db;
public function __construct($db = null)
{
if ($db) {
$this->db = $db;
}
}
public function getPostById($id)
{
$data = array(':id' => $id);
$this->db->prepare("\n SELECT *\n FROM posts \n WHERE id = :id \n ");
$this->db->execute($data);
