/**
* Returns string representation for WHERE clause.
*
* <p>
* Returned string can be easily inserted into SQL query.
* </p>
*
* @version 0.2.0+SVN
* @since 0.1.0
* @return string String WHERE clause.
*/
public function __toString()
{
// database handle
$db = POT::getDBHandle();
// basic name
$name = $db->fieldName($this->name);
// prepends table name
if (!empty($this->table)) {
$name = $db->tableName($this->table) . '.' . $name;
}
return $name;
}
/**
* Magic PHP5 method.
*
* <p>
* Allows object unserialisation.
* </p>
*
* @version 0.2.0+SVN
* @since 0.0.5
*/
public function __wakeup()
{
$this->db = POT::getDBHandle();
}
<?php
// includes POT main file
include_once 'classes/OTS.php';
// define database ids
define(DB_OTSERV1, 100);
define(DB_OTSERV2, 101);
// Config of first database
$config_db1 = array('driver' => POT::DB_MYSQL, 'prefix' => '', 'host' => 'localhost', 'user' => 'wrzasq', 'password' => '', 'database' => 'otserv1');
// Config of second database
$config_db2 = array('driver' => POT::DB_MYSQL, 'prefix' => '', 'host' => 'localhost', 'user' => 'wrzasq', 'password' => '', 'database' => 'otserv2');
// Catch PDO Exceptions!
try {
// Set the database we want to use
POT::setCurrentDB(DB_OTSERV1);
POT::connect(null, $config_db1);
// Change to another ID to connect
POT::setCurrentDB(DB_OTSERV2);
POT::connect(null, $config_db2);
} catch (Exception $e) {
var_dump($e->getMessage());
}
// To use a database you must set it with POT::setCurrentDB(DB_ID)
POT::setCurrentDB(DB_OTSERV1);
// Then you can get the DB Handle
$ot_db = POT::getDBHandle();
// ... and use it!
