A simple database client utilizing PHP PDO.
$pdo->configMaster(
'myhostname.example',
'my_database_name',
'my_database_user',
'my_database_password',
'my_database_port' // optional
);
$pdo->configSlave(
'myhostname1.example',
'my_database_name',
'my_database_user',
'my_database_password',
'my_database_port' // optional
);
$pdo->configSlave(
'myhostname2.example',
'my_database_name',
'my_database_user',
'my_database_password',
'my_database_port' // optional
);
// etc
$results = PDOWrapper::instance()->select('post', array('thread_id'=>$thread_id));
$results = PDOWrapper::instance()->select('thread', array('open'=>0), $limit+1, $start, array('favs'=>'DESC'));
$invite_id = PDOWrapper::instance()->insert('invite', array(
'user_id' => $user_id,
'text' => $text,
'invite_key' => $invite_key
));
$post = PDOWrapper::instance()->queryFirst('
SELECT invite.*, user.name FROM invite
LEFT JOIN user ON user.id=invite.user_id
WHERE invite_key=:invite_key
', array(':invite_key'=>$invite_key));