<?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); }