Example #1
0
 function F2MysqlClass($DBHost, $DBUser, $DBPswd, $DBName, $DBNewlink = "false", $debug = false)
 {
     if ($DBNewlink == "true") {
         if (!mysql_pconnect($DBHost, $DBUser, $DBPswd)) {
             $this->halt("Don't connect to database!");
         }
     } else {
         if (!mysql_connect($DBHost, $DBUser, $DBPswd)) {
             $this->halt("Don't connect to database!");
         }
     }
     if ($this->getServerInfo() > '4.1') {
         mysql_query("SET NAMES 'utf8'");
     }
     if ($this->getServerInfo() > '5.0.1') {
         mysql_query("SET sql_mode=''");
     }
     if ($DBName) {
         $this->selectDB($DBName);
     }
     if ($debug) {
         $this->_debug = $debug;
         $this->_fp = fopen(F2BLOG_ROOT . "./cache/" . date("Ymd") . ".log", "a");
     }
 }
Example #2
0
 /**
  * Persistent database connection
  *
  * @access	private called by the base class
  * @return	resource
  */
 private function db_pconnect()
 {
     if ($this->port != '') {
         $this->db_hostname .= ':' . $this->port;
     }
     return @mysql_pconnect($this->db_hostname, $this->db_username, $this->db_password);
 }
Example #3
0
 /**
 +----------------------------------------------------------
 * 连接数据库方法
 +----------------------------------------------------------
 * @access public
 +----------------------------------------------------------
 * @throws ThinkExecption
 +----------------------------------------------------------
 */
 public function connect($config = '', $linkNum = 0)
 {
     if (!isset($this->linkID[$linkNum])) {
         if (empty($config)) {
             $config = $this->config;
         }
         // 处理不带端口号的socket连接情况
         $host = $config['hostname'] . ($config['hostport'] ? ":{$config['hostport']}" : '');
         if ($this->pconnect) {
             $this->linkID[$linkNum] = mysql_pconnect($host, $config['username'], $config['password'], CLIENT_MULTI_RESULTS);
         } else {
             $this->linkID[$linkNum] = mysql_connect($host, $config['username'], $config['password'], true, CLIENT_MULTI_RESULTS);
         }
         if (!$this->linkID[$linkNum] || !empty($config['database']) && !mysql_select_db($config['database'], $this->linkID[$linkNum])) {
             throw_exception(mysql_error());
         }
         $dbVersion = mysql_get_server_info($this->linkID[$linkNum]);
         if ($dbVersion >= "4.1") {
             //使用UTF8存取数据库 需要mysql 4.1.0以上支持
             mysql_query("SET NAMES '" . C('DB_CHARSET') . "'", $this->linkID[$linkNum]);
         }
         //设置 sql_model
         if ($dbVersion > '5.0.1') {
             mysql_query("SET sql_mode=''", $this->linkID[$linkNum]);
         }
         // 标记连接成功
         $this->connected = true;
         // 注销数据库连接配置信息
         if (1 != C('DB_DEPLOY_TYPE')) {
             unset($this->config);
         }
     }
     return $this->linkID[$linkNum];
 }
Example #4
0
function Open($dbType, $connectType = "c", $connect, $username = "", $password = "", $dbName)
{
    switch ($dbType) {
        case "mssql":
            if ($connectType == "c") {
                $idCon = mssql_connect($connect, $username, $password);
            } else {
                $idCon = mssql_pconnect($connect, $username, $password);
            }
            mssql_select_db($dbName);
            break;
        case "mysql":
            if ($connectType == "c") {
                $idCon = @mysql_connect($connect, $username, $password);
            } else {
                $idCon = @mysql_pconnect($connect, $username, $password);
            }
            $idCon1 = mysql_select_db($dbName, $idCon);
            break;
        case "pg":
            if ($connectType == "c") {
                $idCon = pg_connect($connect . " user=" . $username . " password=" . $password . " dbname=" . $dbName);
            } else {
                $idCon = pg_pconnect($connect . " user=" . $username . " password=" . $password . " dbname=" . $dbName);
            }
            break;
        default:
            $idCon = 0;
            break;
    }
    return $idCon;
}
Example #5
0
 function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true)
 {
     $this->persistency = $persistency;
     $this->user = $sqluser;
     $this->password = $sqlpassword;
     $this->server = $sqlserver;
     $this->dbname = $database;
     if ($this->persistency) {
         $this->db_connect_id = @mysql_pconnect($this->server, $this->user, $this->password);
     } else {
         $this->db_connect_id = @mysql_connect($this->server, $this->user, $this->password);
     }
     if ($this->db_connect_id) {
         if ($database != "") {
             $this->dbname = $database;
             $dbselect = @mysql_select_db($this->dbname);
             if (!$dbselect) {
                 @mysql_close($this->db_connect_id);
                 $this->db_connect_id = $dbselect;
             }
         }
         return $this->db_connect_id;
     } else {
         return false;
     }
 }
 function getID3_cached_mysql($host, $database, $username, $password)
 {
     // Check for mysql support
     if (!function_exists('mysql_pconnect')) {
         throw new Exception('PHP not compiled with mysql support.');
     }
     // Connect to database
     $this->connection = mysql_pconnect($host, $username, $password);
     if (!$this->connection) {
         throw new Exception('mysql_pconnect() failed - check permissions and spelling.');
     }
     // Select database
     if (!mysql_select_db($database, $this->connection)) {
         throw new Exception('Cannot use database ' . $database);
     }
     // Create cache table if not exists
     $this->create_table();
     // Check version number and clear cache if changed
     $version = '';
     if ($this->cursor = mysql_query("SELECT `value` FROM `getid3_cache` WHERE (`filename` = '" . mysql_real_escape_string(GETID3_VERSION) . "') AND (`filesize` = '-1') AND (`filetime` = '-1') AND (`analyzetime` = '-1')", $this->connection)) {
         list($version) = mysql_fetch_array($this->cursor);
     }
     if ($version != GETID3_VERSION) {
         $this->clear_cache();
     }
     parent::getID3();
 }
Example #7
0
 function DoConnect()
 {
     if ($this->bConnected) {
         return;
     }
     $this->bConnected = true;
     if (DBPersistent && !$this->bNodeConnection) {
         $this->db_Conn = @mysql_pconnect($this->DBHost, $this->DBLogin, $this->DBPassword);
     } else {
         $this->db_Conn = @mysql_connect($this->DBHost, $this->DBLogin, $this->DBPassword, true);
     }
     if (!$this->db_Conn) {
         $s = DBPersistent && !$this->bNodeConnection ? "mysql_pconnect" : "mysql_connect";
         if ($this->debug || @session_start() && $_SESSION["SESS_AUTH"]["ADMIN"]) {
             echo "<br><font color=#ff0000>Error! " . $s . "('-', '-', '-')</font><br>" . mysql_error() . "<br>";
         }
         SendError("Error! " . $s . "('-', '-', '-')\n" . mysql_error() . "\n");
         return false;
     }
     if (!mysql_select_db($this->DBName, $this->db_Conn)) {
         if ($this->debug || @session_start() && $_SESSION["SESS_AUTH"]["ADMIN"]) {
             echo "<br><font color=#ff0000>Error! mysql_select_db(" . $this->DBName . ")</font><br>" . mysql_error($this->db_Conn) . "<br>";
         }
         SendError("Error! mysql_select_db(" . $this->DBName . ")\n" . mysql_error($this->db_Conn) . "\n");
         return false;
     }
     $this->cntQuery = 0;
     $this->timeQuery = 0;
     $this->arQueryDebug = array();
     global $DB, $USER, $APPLICATION;
     if (file_exists($_SERVER["DOCUMENT_ROOT"] . BX_PERSONAL_ROOT . "/php_interface/after_connect.php")) {
         include $_SERVER["DOCUMENT_ROOT"] . BX_PERSONAL_ROOT . "/php_interface/after_connect.php";
     }
     return true;
 }
Example #8
0
 /**
 +----------------------------------------------------------
 * 连接数据库方法
 +----------------------------------------------------------
 * @access public
 +----------------------------------------------------------
 * @throws ThinkExecption
 +----------------------------------------------------------
 */
 public function connect()
 {
     if (!$this->connected) {
         $config = $this->config;
         // 处理不带端口号的socket连接情况
         $host = $config['hostname'] . ($config['hostport'] ? ":{$config['hostport']}" : '');
         if ($this->pconnect) {
             $this->linkID = mysql_pconnect($host, $config['username'], $config['password']);
         } else {
             $this->linkID = mysql_connect($host, $config['username'], $config['password'], true);
         }
         if (!$this->linkID || !empty($config['database']) && !mysql_select_db($config['database'], $this->linkID)) {
             echo mysql_error();
         }
         $dbVersion = mysql_get_server_info($this->linkID);
         if ($dbVersion >= "4.1") {
             //使用UTF8存取数据库 需要mysql 4.1.0以上支持
             mysql_query("SET NAMES 'UTF8'", $this->linkID);
         }
         //设置 sql_model
         if ($dbVersion > '5.0.1') {
             mysql_query("SET sql_mode=''", $this->linkID);
         }
         // 标记连接成功
         $this->connected = true;
         // 注销数据库连接配置信息
         unset($this->config);
     }
 }
 public function __construct($host, $database, $username, $password, $table = 'getid3_cache')
 {
     // Check for mysql support
     if (!function_exists('mysql_pconnect')) {
         throw new Exception('PHP not compiled with mysql support.');
     }
     // Connect to database
     $this->connection = mysql_pconnect($host, $username, $password);
     if (!$this->connection) {
         throw new Exception('mysql_pconnect() failed - check permissions and spelling.');
     }
     // Select database
     if (!mysql_select_db($database, $this->connection)) {
         throw new Exception('Cannot use database ' . $database);
     }
     // Set table
     $this->table = $table;
     // Create cache table if not exists
     $this->create_table();
     // Check version number and clear cache if changed
     $version = '';
     $SQLquery = 'SELECT `value`';
     $SQLquery .= ' FROM `' . mysql_real_escape_string($this->table) . '`';
     $SQLquery .= ' WHERE (`filename` = \'' . mysql_real_escape_string(getID3::VERSION) . '\')';
     $SQLquery .= ' AND (`filesize` = -1)';
     $SQLquery .= ' AND (`filetime` = -1)';
     $SQLquery .= ' AND (`analyzetime` = -1)';
     if ($this->cursor = mysql_query($SQLquery, $this->connection)) {
         list($version) = mysql_fetch_array($this->cursor);
     }
     if ($version != getID3::VERSION) {
         $this->clear_cache();
     }
     parent::__construct();
 }
Example #10
0
 function connect()
 {
     global $usepconnect;
     // connect to db server
     if (0 == $this->link_id) {
         if ($this->password == "") {
             if ($usepconnect == 1) {
                 $this->link_id = mysql_pconnect($this->server, $this->user);
             } else {
                 $this->link_id = mysql_connect($this->server, $this->user);
             }
         } else {
             if ($usepconnect == 1) {
                 $this->link_id = mysql_pconnect($this->server, $this->user, $this->password);
             } else {
                 $this->link_id = mysql_connect($this->server, $this->user, $this->password);
             }
         }
         if (!$this->link_id) {
             $this->halt("Link-ID == false, connect failed");
         }
         if ($this->database != "") {
             if (!mysql_select_db($this->database, $this->link_id)) {
                 $this->halt("cannot use database " . $this->database);
             }
         }
     }
 }
Example #11
0
function PMA_DBI_connect($user, $password)
{
    global $cfg, $php_errormsg;
    $server_port = empty($cfg['Server']['port']) ? '' : ':' . $cfg['Server']['port'];
    if (strtolower($cfg['Server']['connect_type']) == 'tcp') {
        $cfg['Server']['socket'] = '';
    }
    $server_socket = empty($cfg['Server']['socket']) ? '' : ':' . $cfg['Server']['socket'];
    if (PMA_PHP_INT_VERSION >= 40300 && PMA_MYSQL_CLIENT_API >= 32349) {
        $client_flags = $cfg['Server']['compress'] && defined('MYSQL_CLIENT_COMPRESS') ? MYSQL_CLIENT_COMPRESS : 0;
        // always use CLIENT_LOCAL_FILES as defined in mysql_com.h
        // for the case where the client library was not compiled
        // with --enable-local-infile
        $client_flags |= 128;
    }
    if (empty($client_flags)) {
        $connect_func = 'mysql_' . ($cfg['PersistentConnections'] ? 'p' : '') . 'connect';
        $link = @$connect_func($cfg['Server']['host'] . $server_port . $server_socket, $user, $password);
    } else {
        if ($cfg['PersistentConnections']) {
            $link = @mysql_pconnect($cfg['Server']['host'] . $server_port . $server_socket, $user, $password, $client_flags);
        } else {
            $link = @mysql_connect($cfg['Server']['host'] . $server_port . $server_socket, $user, $password, FALSE, $client_flags);
        }
    }
    if (empty($link)) {
        PMA_auth_fails();
    }
    // end if
    PMA_DBI_postConnect($link);
    return $link;
}
Example #12
0
 public function connect()
 {
     /**
     		if ($this->conn == "pconn") {
     			//永久链接
     			$this->conn = mysql_pconnect($this->db_host, $this->db_user, $this->db_pwd);
     		} else {
     			//即时链接
     			$this->conn = mysql_connect($this->db_host, $this->db_user, $this->db_pwd);
     		}
     
     		if (!mysql_select_db($this->db_database, $this->conn)) {
     			if ($this->show_error) {
     				$this->show_error("数据库不可用:", $this->db_database);
     			}
     		}
     		mysql_query("SET NAMES $this->coding");
     		**/
     if ($this->conn == "pconn") {
         //永久链接
         $this->conn = mysql_pconnect($this->db_host, $this->db_user, $this->db_pwd);
     } else {
         //即时链接
         $this->conn = mysqli_connect($this->db_host, $this->db_user, $this->db_pwd, $this->db_database);
     }
     if (mysqli_connect_errno($this->conn)) {
         $this->show_error("数据库不可用:", $this->db_database);
     }
     mysqli_query($this->conn, "SET NAMES {$this->coding}");
 }
Example #13
0
 function connect($dbhost, $dbuser, $dbpw, $dbname = '', $dbcharset, $pconnect = 0, $tablepre = '', $time = 0)
 {
     $this->tablepre = $tablepre;
     if ($pconnect) {
         if (!($this->link = mysql_pconnect($dbhost, $dbuser, $dbpw))) {
             die('Can not connect to MySQL server');
         }
     } else {
         if (!($this->link = mysql_connect($dbhost, $dbuser, $dbpw, 1))) {
             die('Can not connect to MySQL server');
         }
     }
     if ($this->version() > '4.1') {
         if ($dbcharset) {
             mysql_query("SET character_set_connection=" . $dbcharset . ", character_set_results=" . $dbcharset . ", character_set_client=binary", $this->link);
         }
         if ($this->version() > '5.0.1') {
             mysql_query("SET sql_mode=''", $this->link);
         }
     }
     if ($dbname) {
         $db_selected = mysql_select_db($dbname, $this->link);
         if (!$db_selected) {
             $sql = "CREATE DATABASE {$dbname} DEFAULT CHARACTER SET utf8;";
             self::query($sql);
             mysql_select_db($dbname, $this->link);
         }
     }
 }
Example #14
0
 function connect($db, $return = false)
 {
     if ($db['port']) {
         $db['server'] .= ':' . $db['port'];
     }
     if ($this->link_identifier) {
         $this->disconnect();
     }
     $this->link_identifier = $db['persistent'] ? @mysql_pconnect($db['server'], $db['username'], $db['password']) : @mysql_connect($db['server'], $db['username'], $db['password']);
     if ($this->link_identifier) {
         if (@mysql_select_db($db['database'])) {
             mysql_query('SET NAMES utf8', $this->link_identifier);
             //mysql_query('SET character_set_results = NULL', $this->link_identifier);
             return $this->link_identifier;
         }
         $error = '<center>There is currently a problem with the site<br/>Please try again later<br /><br />Error Code: DB2</center>';
     }
     if (!$this->report_error) {
         return false;
     }
     if (!isset($error)) {
         $error = '<center>There is currently a problem with the site<br/>Please try again later<br /><br />Error Code: DB1</center>';
     }
     $this->disconnect();
     trigger_error($error, E_USER_ERROR);
 }
Example #15
0
 public function __construct()
 {
     // attempt to connect
     if (!($this->db = !$_SERVER['tracker']['db_persist'] ? mysql_connect($_SERVER['tracker']['db_host'], $_SERVER['tracker']['db_user'], $_SERVER['tracker']['db_pass']) : mysql_pconnect($_SERVER['tracker']['db_host'], $_SERVER['tracker']['db_user'], $_SERVER['tracker']['db_pass'])) or !mysql_select_db($_SERVER['tracker']['db_name'], $this->db)) {
         tracker_error(mysql_errno($this->db) . ' - ' . mysql_error($this->db));
     }
 }
Example #16
0
 function connect()
 {
     if ($this->pconnect) {
         if (!($this->dou_link = @mysql_pconnect($this->dbhost, $this->dbuser, $this->dbpass))) {
             $this->error('Can not pconnect to mysql server');
             return false;
         }
     } else {
         if (!($this->dou_link = @mysql_connect($this->dbhost, $this->dbuser, $this->dbpass, true))) {
             $this->error('Can not connect to mysql server');
             return false;
         }
     }
     if ($this->version() > '4.1') {
         if ($this->charset) {
             $this->query("SET character_set_connection=" . $this->charset . ", character_set_results=" . $this->charset . ", character_set_client=binary");
         }
         if ($this->version() > '5.0.1') {
             $this->query("SET sql_mode=''");
         }
     }
     if (mysql_select_db($this->dbname, $this->dou_link) === false) {
         $this->error("NO THIS DBNAME:" . $this->dbname);
         return false;
     }
 }
Example #17
0
 public function connect()
 {
     if ($this->_connection) {
         return $this->_connection;
     }
     extract($this->_config['connection']);
     unset($this->_config['connection']);
     try {
         if ($persistent) {
             $this->_connection = mysql_pconnect($hostname, $username, $password);
         } else {
             $this->_connection = mysql_connect($hostname, $username, $password, TRUE);
         }
     } catch (Exception $e) {
         $this->_connection = NULL;
         throw new Kohana_Exception(':error', array(':error' => $e->getMessage()), $e->getCode());
     }
     if (!mysql_select_db($database, $this->_connection)) {
         throw new Kohana_Exception(':error', array(':error' => mysql_error($this->_connection)), mysql_errno($this->_connection));
     }
     if (!empty($this->_config['charset'])) {
         $this->set_charset($this->_config['charset']);
     }
     return $this->_connection;
 }
Example #18
0
 /**
  * 连接数据库方法
  * @access public
  * @throws ThinkExecption
  */
 public function connect()
 {
     if (!$this->connected) {
         $config = $this->config;
         // 处理不带端口号的socket连接情况
         $host = $config['hostname'] . ($config['hostport'] ? ":{$config['hostport']}" : '');
         $pconnect = !empty($config['params']['persist']) ? $config['params']['persist'] : $this->pconnect;
         if ($pconnect) {
             $this->linkID = mysql_pconnect($host, $config['username'], $config['password'], CLIENT_MULTI_RESULTS);
         } else {
             $this->linkID = mysql_connect($host, $config['username'], $config['password'], true, CLIENT_MULTI_RESULTS);
         }
         if (!$this->linkID || !empty($config['database']) && !mysql_select_db($config['database'], $this->linkID)) {
             throw_exception(mysql_error());
         }
         $dbVersion = mysql_get_server_info($this->linkID);
         if ($dbVersion >= "4.1") {
             //使用UTF8存取数据库 需要mysql 4.1.0以上支持
             mysql_query("SET NAMES '" . C('DB_CHARSET') . "'", $this->linkID);
         }
         //设置 sql_model
         if ($dbVersion > '5.0.1') {
             mysql_query("SET sql_mode=''", $this->linkID);
         }
         // 标记连接成功
         $this->connected = true;
         // 注销数据库连接配置信息
         unset($this->config);
     }
 }
Example #19
0
 public function connect()
 {
     if ($this->_connection) {
         return;
     }
     if (static::$_set_names === NULL) {
         // Determine if we can use mysql_set_charset(), which is only
         // available on PHP 5.2.3+ when compiled against MySQL 5.0+
         static::$_set_names = !function_exists('mysql_set_charset');
     }
     // Extract the connection parameters, adding required variabels
     extract($this->_config['connection'] + array('database' => '', 'hostname' => '', 'username' => '', 'password' => '', 'persistent' => FALSE));
     // Prevent this information from showing up in traces
     unset($this->_config['connection']['username'], $this->_config['connection']['password']);
     try {
         if ($persistent) {
             // Create a persistent connection
             $this->_connection = mysql_pconnect($hostname, $username, $password);
         } else {
             // Create a connection and force it to be a new link
             $this->_connection = mysql_connect($hostname, $username, $password, TRUE);
         }
     } catch (ErrorException $e) {
         // No connection exists
         $this->_connection = NULL;
         throw new \Database_Exception(mysql_error(), mysql_errno());
     }
     // \xFF is a better delimiter, but the PHP driver uses underscore
     $this->_connection_id = sha1($hostname . '_' . $username . '_' . $password);
     $this->_select_db($database);
     if (!empty($this->_config['charset'])) {
         // Set the character set
         $this->set_charset($this->_config['charset']);
     }
 }
Example #20
0
 /**
  *
  * @param $server
  * @param $username
  * @param $password
  * @param $db_name
  * @param $persistency
  * @return unknown_type
  */
 public function __construct($server, $username, $password, $db_name = null, $persistency = true)
 {
     if ($persistency) {
         $this->link = @mysql_pconnect($server, $username, $password);
     } else {
         $this->link = @mysql_connect($server, $username, $password, true);
     }
     if (!$this->link) {
         if (mysql_errno()) {
             throw new MySqlException(mysql_error(), mysql_errno());
         } else {
             throw new MySqlException("Can't connect to MySQL server on '{$server}'", 2003);
         }
     }
     if ($db_name !== null) {
         if (!$this->selectDatabase($db_name)) {
             if (mysql_errno()) {
                 $error = mysql_error();
                 $errno = mysql_errno();
             } else {
                 $error = "Error selecting database '{$db_name}' on host '{$server}'";
                 $errno = 1049;
             }
             @mysql_close($this->link);
             throw new MySqlException($error, $errno);
         }
     }
 }
Example #21
0
 function connect($pconnect = false, $force_new = false)
 {
     if (is_resource($this->_conn)) {
         return;
     }
     $this->_last_err = null;
     $this->_last_err_code = null;
     if (isset($this->_dsn['port']) && $this->_dsn['port'] != '') {
         $host = $this->_dsn['host'] . ':' . $this->_dsn['port'];
     } else {
         $host = $this->_dsn['host'];
     }
     if (!isset($this->_dsn['login'])) {
         $this->_dsn['login'] = '';
     }
     if (!isset($this->_dsn['password'])) {
         $this->_dsn['password'] = '';
     }
     if ($pconnect) {
         $this->_conn = mysql_pconnect($host, $this->_dsn['login'], $this->_dsn['password'], $force_new);
     } else {
         $this->_conn = mysql_connect($host, $this->_dsn['login'], $this->_dsn['password'], $force_new);
     }
     if (!is_resource($this->_conn)) {
         throw new QDB_Exception('CONNECT DATABASE', mysql_error(), mysql_errno());
     }
     if (!empty($this->_dsn['database'])) {
         $this->execute('USE ' . $this->qid($this->_dsn['database']));
     }
     if (isset($this->_dsn['charset']) && $this->_dsn['charset'] != '') {
         $charset = $this->_dsn['charset'];
         $this->execute("SET NAMES '" . $charset . "'");
     }
 }
Example #22
0
 function conn($host = 'localhost', $user = 'root', $pass = 'pass', $db = 'database')
 {
     $this->host = $host;
     $this->user = $user;
     $this->pass = $pass;
     $this->db = $db;
     if ($this->persistant) {
         $this->db_link = mysql_pconnect($this->host, $this->user, $this->pass, true);
     } else {
         $this->db_link = mysql_connect($this->host, $this->user, $this->pass, true);
     }
     if (!$this->db_link) {
         if ($this->error) {
             $this->error($type = 1);
         }
         return false;
     } else {
         if (empty($db)) {
             if ($this->error) {
                 $this->error($type = 2);
             }
         } else {
             $db = mysql_select_db($this->db, $this->db_link);
             if (!$db) {
                 if ($this->error) {
                     $this->error($type = 2);
                 }
                 return false;
             }
             $this->conn = true;
         }
         return $this->db_link;
     }
 }
Example #23
0
 /**
  * 连接数据库方法
  * @access public
  * @throws ThinkExecption
  */
 public function connect($config = '', $linkNum = 0, $force = false)
 {
     if (!isset($this->linkID[$linkNum])) {
         if (empty($config)) {
             $config = $this->config;
         }
         // 处理不带端口号的socket连接情况
         $host = $config['hostname'] . ($config['hostport'] ? ":{$config['hostport']}" : '');
         // 是否长连接
         $pconnect = !empty($config['params']['persist']) ? $config['params']['persist'] : $this->pconnect;
         if ($pconnect) {
             $this->linkID[$linkNum] = mysql_pconnect($host, $config['username'], $config['password'], CLIENT_MULTI_RESULTS);
         } else {
             $this->linkID[$linkNum] = mysql_connect($host, $config['username'], $config['password'], true, CLIENT_MULTI_RESULTS);
         }
         if (!$this->linkID[$linkNum] || !empty($config['database']) && !mysql_select_db($config['database'], $this->linkID[$linkNum]) || C('SPARE_DB_DEBUG')) {
             $errStr = mysql_error();
             $errno = mysql_errno();
             if ($errno == 13047 || C('SPARE_DB_DEBUG')) {
                 if (C('SMS_ALERT_ON')) {
                     Sms::send('mysql超额被禁用,请在SAE日志中心查看详情', $errStr, Sms::MYSQL_ERROR);
                 }
                 //[sae]启动备用数据库
                 if (C('SPARE_DB_HOST')) {
                     $this->linkID[$linkNum] = mysql_connect(C('SPARE_DB_HOST') . (C('SPARE_DB_PORT') ? ':' . C('SPARE_DB_PORT') : ''), C('SPARE_DB_USER'), C('SPARE_DB_PWD'), true, CLIENT_MULTI_RESULTS);
                     if (!$this->linkID[$linkNum]) {
                         throw_exception('备用数据库连接失败');
                     }
                     mysql_select_db(C('SPARE_DB_NAME'), $this->linkID[$linkNum]);
                     //标记使用备用数据库状态
                     $this->is_spare = true;
                 } else {
                     throw_exception($errStr);
                 }
             } else {
                 //[sae] 短信预警
                 if (C('SMS_ALERT_ON')) {
                     Sms::send('数据库连接时出错,请在SAE日志中心查看详情', $errStr, Sms::MYSQL_ERROR);
                 }
                 throw_exception($errStr);
             }
         }
         $dbVersion = mysql_get_server_info($this->linkID[$linkNum]);
         if ($dbVersion >= '4.1') {
             //使用UTF8存取数据库 需要mysql 4.1.0以上支持
             mysql_query("SET NAMES '" . C('DB_CHARSET') . "'", $this->linkID[$linkNum]);
         }
         //设置 sql_model
         if ($dbVersion > '5.0.1') {
             mysql_query("SET sql_mode=''", $this->linkID[$linkNum]);
         }
         // 标记连接成功
         $this->connected = true;
         // 注销数据库连接配置信息
         if (1 != C('DB_DEPLOY_TYPE')) {
             unset($this->config);
         }
     }
     return $this->linkID[$linkNum];
 }
Example #24
0
 /**
  * connect to the database
  *
  * @param bool $selectdb select the database now?
  * @return bool successful?
  */
 public function connect($selectdb = true)
 {
     static $db_charset_set;
     $this->allowWebChanges = $_SERVER['REQUEST_METHOD'] != 'GET';
     if (!extension_loaded('mysql')) {
         trigger_error(_CORE_DB_NOTRACE, E_USER_ERROR);
         return false;
     }
     if (XOOPS_DB_PCONNECT == 1) {
         $this->conn = @mysql_pconnect(XOOPS_DB_HOST, XOOPS_DB_USER, XOOPS_DB_PASS, true);
         // ALTERED BY FREEFORM SOLUTIONS FOR THE FORMULIZE STANDALONE RELEASE
     } else {
         $this->conn = @mysql_connect(XOOPS_DB_HOST, XOOPS_DB_USER, XOOPS_DB_PASS, true);
         // ALTERED BY FREEFORM SOLUTIONS FOR THE FORMULIZE STANDALONE RELEASE
     }
     if (!$this->conn) {
         $this->logger->addQuery('', $this->error(), $this->errno());
         return false;
     }
     if ($selectdb != false) {
         if (!mysql_select_db(XOOPS_DB_NAME)) {
             $this->logger->addQuery('', $this->error(), $this->errno());
             return false;
         }
     }
     if (!isset($db_charset_set) && defined('XOOPS_DB_CHARSET') && XOOPS_DB_CHARSET && XOOPS_DB_CHARSET !== 'ucs2') {
         $this->queryF("SET NAMES '" . XOOPS_DB_CHARSET . "'");
     }
     $db_charset_set = 1;
     return true;
 }
Example #25
0
 /**
  * 连接数据库方法
  * @access public
  * @throws ThinkExecption
  */
 public function connect($config='',$linkNum=0,$force=false) {
     if ( !isset($this->linkID[$linkNum]) ) {
         if(empty($config))  $config =   $this->config;
         // 处理不带端口号的socket连接情况
         $host = $config['hostname'].($config['hostport']?":{$config['hostport']}":'');
         // 是否长连接
         $pconnect   = !empty($config['params']['persist'])? $config['params']['persist']:$this->pconnect;
         if($pconnect) {
             $this->linkID[$linkNum] = mysql_pconnect( $host, $config['username'], $config['password'],131072);
         }else{
             $this->linkID[$linkNum] = mysql_connect( $host, $config['username'], $config['password'],true,131072);
         }
         if ( !$this->linkID[$linkNum] || (!empty($config['database']) && !mysql_select_db($config['database'], $this->linkID[$linkNum])) ) {
             E(mysql_error());
         }
         $dbVersion = mysql_get_server_info($this->linkID[$linkNum]);
         //使用UTF8存取数据库
         mysql_query("SET NAMES '".C('DB_CHARSET')."'", $this->linkID[$linkNum]);
         //设置 sql_model
         if($dbVersion >'5.0.1'){
             mysql_query("SET sql_mode=''",$this->linkID[$linkNum]);
         }
         // 标记连接成功
         $this->connected    =   true;
         // 注销数据库连接配置信息
         if(1 != C('DB_DEPLOY_TYPE')) unset($this->config);
     }
     return $this->linkID[$linkNum];
 }
 function connect($Database = "", $Host = "", $User = "", $Password = "")
 {
     /* Handle defaults */
     if ("" == $Database) {
         $Database = $this->Database;
     }
     if ("" == $Host) {
         $Host = $this->Host;
     }
     if ("" == $User) {
         $User = $this->User;
     }
     if ("" == $Password) {
         $Password = $this->Password;
     }
     /* establish connection, select database */
     if (0 == $this->Link_ID) {
         $this->Link_ID = mysql_pconnect($Host, $User, $Password);
         if (!$this->Link_ID) {
             //echo $Database;
             $this->halt("connect({$Host}, {$User}, \$Password) failed.");
             return 0;
         }
         if (!@mysql_select_db($Database, $this->Link_ID)) {
             $this->halt("cannot use database " . $this->Database);
             return 0;
         }
     }
     return $this->Link_ID;
 }
Example #27
0
 function connect($dbhost, $dbuser, $dbpw, $dbname = '', $dbcharset = '', $pconnect = 0, $tablepre = '', $time = 0)
 {
     $this->dbhost = $dbhost;
     $this->dbuser = $dbuser;
     $this->dbpw = $dbpw;
     $this->dbname = $dbname;
     $this->dbcharset = $dbcharset;
     $this->pconnect = $pconnect;
     $this->tablepre = $tablepre;
     $this->time = $time;
     if ($pconnect) {
         if (!($this->link = mysql_pconnect($dbhost, $dbuser, $dbpw))) {
             $this->halt('Can not connect to MySQL server');
         }
     } else {
         if (!($this->link = mysql_connect($dbhost, $dbuser, $dbpw))) {
             $this->halt('Can not connect to MySQL server');
         }
     }
     if ($this->version() > '4.1') {
         if ($dbcharset) {
             mysql_query("SET character_set_connection=" . $dbcharset . ", character_set_results=" . $dbcharset . ", character_set_client=binary", $this->link);
         }
         if ($this->version() > '5.0.1') {
             //mysql_query("SET sql_mode=''", $this->link); //关闭严格模式
         }
     }
     if ($dbname) {
         mysql_select_db($dbname, $this->link);
     }
 }
 public function connect($user, $pass, $db, $host = "localhost")
 {
     $this->database = $db;
     // Connect to the database
     if ($this->connected) {
         return $this->link_identifier;
     }
     if ($this->persistent_connect) {
         $this->link_identifier = @mysql_pconnect($host, $user, $pass, $this->new_link);
     } else {
         $this->link_identifier = @mysql_connect($host, $user, $pass, $this->new_link);
     }
     if ($this->link_identifier) {
         $select = @mysql_select_db($db, $this->link_identifier);
         if (!$select) {
             trigger_error("Database <b>{$db}</b> doesn't exist", E_USER_ERROR);
         }
         $this->connected = true;
         return $this->link_identifier;
     } else {
         $this->connected = false;
         if ($this->die_on_fail) {
             trigger_error('Could not connect to the database', E_USER_ERROR);
         }
         return false;
     }
 }
Example #29
0
 function db($dbhost, $dbuser, $dbpw, $dbname = '', $dbcharset = 'utf8', $pconnect = 0)
 {
     if ($pconnect) {
         if (!($this->mlink = @mysql_pconnect($dbhost, $dbuser, $dbpw))) {
             $this->halt('Can not connect to MySQL');
         }
     } else {
         if (!($this->mlink = @mysql_connect($dbhost, $dbuser, $dbpw))) {
             $this->halt('Can not connect to MySQL');
         }
     }
     if ($this->version() > '4.1') {
         if ('utf-8' == strtolower($dbcharset)) {
             $dbcharset = 'utf8';
         }
         if ($dbcharset) {
             mysql_query("SET character_set_connection={$dbcharset}, character_set_results={$dbcharset}, character_set_client=binary", $this->mlink);
         }
         if ($this->version() > '5.0.1') {
             mysql_query("SET sql_mode=''", $this->mlink);
         }
     }
     if ($dbname) {
         mysql_select_db($dbname, $this->mlink);
     }
 }
Example #30
0
 /**
  * connect stuff
  */
 function connect()
 {
     if ($this->_connected) {
         return;
     }
     core::dprint(array('CONNECT %s', $this->dbname), core::E_SQL);
     $starttime = microtime(true);
     if (!function_exists('mysql_connect')) {
         throw new dbal_exception('MySQL support not compiled with PHP!');
     }
     if (empty($this->dbname)) {
         throw new dbal_exception('Empty database given');
     }
     $this->_connect_id = $this->persistency ? mysql_pconnect($this->server, $this->user, $this->password) : mysql_connect($this->server, $this->user, $this->password);
     if (empty($this->_connect_id)) {
         throw new dbal_exception('Cant connect to database', $this->get_error());
     }
     $dbselect = mysql_select_db($this->dbname);
     if (!$dbselect) {
         throw new dbal_exception('Cant use database', $this->get_error());
     }
     $endtime = microtime(true) - $starttime;
     $this->sql_time += $endtime;
     $this->_disabled_set_names = !empty($this->_config['disable_set_names']);
     $this->_connected = true;
     if (!empty($this->_config['fix_charset'])) {
         if ($this->_connect_id) {
             $this->fix_charset();
         }
     }
     $this->password = null;
     return $this->_connect_id;
 }