<?php
$con = sqlrcon_alloc('mysqlpool', 12000, '/tmp/mysqlpool.socket', 'root', '******', 0, 1);
var_dump(sqlrcon_errorNumber($con));
var_dump(sqlrcon_dbHostName($con));
var_dump(sqlrcon_dbIpAddress($con));
$cur = sqlrcur_alloc($con);
sqlrcur_sendQuery($cur, 'select * from test');
var_dump(sqlrcur_totalRows($cur));
for ($row = 0; $row < sqlrcur_rowCount($cur); $row++) {
for ($col = 0; $col < sqlrcur_colCount($cur); $col++) {
echo sqlrcur_getField($cur, $row, $col);
}
echo PHP_EOL;
}
sqlrcur_free($cur);
sqlrcon_free($con);
/**
* Try to connect to the configured Database (during installation)
*
* @access public
* @param array input configuration array, holding the connection info
* @param array referenced array which holds the errors that might be encountered
* @return boolean return true on success, false on error
*/
function serendipity_db_probe($hash, &$errs)
{
global $serendipity;
$c;
if (!function_exists('sqlrcon_alloc')) {
$errs[] = 'No sql_relay extension found. Please check your webserver installation or contact your systems administrator regarding this problem.';
return false;
}
if (!($c = @sqlrcon_alloc($hash['dbHost'], '', '', $hash['dbUser'], $hash['dbPass'], 0, 5))) {
$errs[] = 'Could not connect to database; check your settings.';
return false;
}
$serendipity['dbConn'] = $c;
/* which db should be used is defined in sqlrelay.conf */
return true;
}
/**
* Non-persistent database connection
*
* @access protected
* @return resource
* @see parent::initialize();
*/
function db_connect()
{
if (!function_exists('sqlrcon_alloc')) {
log_message('error', 'Driver Db_sqlrelay ' . "\t" . 'Method db_connect ' . PHP_EOL . "\t\t" . 'Module SQL Relay non chargé dans la configuration serveur"' . PHP_EOL . " Connexion data " . PHP_EOL . " username : "******" hostname : " . $this->hostname . PHP_EOL . " database : " . $this->database . PHP_EOL . " dbdriver : " . $this->dbdriver . PHP_EOL . " dbprefix : " . $this->dbprefix . PHP_EOL . " port : " . $this->port);
return false;
}
$sConnect = sqlrcon_alloc($this->hostname, $this->port, '', $this->username, $this->password, 1, 3);
if (sqlrcon_ping($sConnect) !== 1) {
log_message('error', 'Driver Db_sqlrelay ' . "\t" . 'Method db_connect ' . PHP_EOL . "\t\t" . 'Pas de ping serveur"' . PHP_EOL . " Connexion data " . PHP_EOL . " username : "******" hostname : " . $this->hostname . PHP_EOL . " database : " . $this->database . PHP_EOL . " dbdriver : " . $this->dbdriver . PHP_EOL . " dbprefix : " . $this->dbprefix . PHP_EOL . " port : " . $this->port);
return false;
}
if (sqlrcon_identify($sConnect) == 'oracle8') {
$this->setIsOracle(true);
$this->setPrefetchState(true);
} else {
$this->setIsOracle(false);
}
// $curs_id = sqlrcur_alloc($sConnect);
// sqlrcur_prepareQuery($curs_id, "ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '. ' ");
// sqlrcur_sendquery($curs_id, "ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '. ' ");
// sqlrcur_free($curs_id);
return $sConnect;
}
function da_sql_pconnect($config)
{
$retrytime = 0;
if ($config[sql_use_http_credentials] == 'yes') {
global $HTTP_SERVER_VARS;
$SQL_user = $HTTP_SERVER_VARS["PHP_AUTH_USER"];
$SQL_passwd = $HTTP_SERVER_VARS["PHP_AUTH_PW"];
} else {
$SQL_user = $config[sql_username];
$SQL_passwd = $config[sql_password];
}
if ($config[sql_connect_timeout] != 0) {
$retrytime = $config[sql_connect_timeout];
}
if ($config[sql_debug] == 'true') {
print "<b>DEBUG(SQL,SQLRELAY DRIVER): Connect: Host={$config['sql_server']},Port={$config['sql_port']},User={$SQL_user},Password={$SQL_passwd} </b><br>\n";
}
$link[con] = sqlrcon_alloc($config[sql_server], $config[sql_port], '', $SQL_user, $SQL_passwd, $retrytime, 1);
if ($link[con]) {
sqlrcon_debugOn($link[con]);
$link[cur] = sqlrcur_alloc($link[con]);
if ($link[cur]) {
sqlrcur_setResultSetBufferSize($link[cur], 4);
sqlrcur_lowerCaseColumnNames($link[cur]);
return $link;
} else {
return false;
}
} else {
return false;
}
}
public function __construct($connMngt)
{
$this->_connectionManagement = $connMngt;
$this->_conn = sqlrcon_alloc($this->_connectionManagement->getServer(), $this->_connectionManagement->getPort(), $this->_connectionManagement->getExtraParam("unixsocket"), $this->_connectionManagement->getUsername(), $this->_connectionManagement->getPassword(), 0, 1);
sqlrcon_autoCommitOn($this->_conn);
}
