* This example is part of gelembjuk/db package by Roman Gelembjuk (@gelembjuk)
*/
// path to your composer autoloader
require 'vendor/autoload.php';
// simple example to show how to work with 2 DB parelelly in a PHP script
$dbsettings1 = array('user' => 'dbuser', 'password' => 'dbuserpassword', 'database' => 'mydb', 'host' => 'localhost', 'connectioncharset' => 'utf8', 'namescharset' => 'utf8');
// different DB
$dbsettings2 = array('user' => 'dbuser', 'password' => 'dbuserpassword', 'database' => 'mydb2', 'host' => 'localhost', 'connectioncharset' => 'utf8', 'namescharset' => 'utf8');
$dbengine1 = new Gelembjuk\DB\MySQL($dbsettings1);
$dbengine2 = new Gelembjuk\DB\MySQLi($dbsettings2);
// connection will be established on a first request to a DB
class MyTable extends Gelembjuk\DB\Base
{
public function getUsers()
{
return $this->getRows('SELECT * FROM users');
}
public function addUser($name, $email)
{
$sql = "INSERT INTO users (name,email) VALUES " . "('" . $this->quote($name) . "','" . $this->quote($email) . "')";
$this->executeQuery();
return getLastInsertedId();
}
}
$mytable = new MyTable($dbengine1);
$userid1 = $mytable->addUser('User 1', '*****@*****.**');
$userid2 = $mytable->addUser('User 2', '*****@*****.**');
print_r($mytable->getUsers());
// this will do same but with different DB
$mytable2 = new MyTable($dbengine2);
print_r($mytable2->getUsers());
