Ejemplo n.º 1
0
 function connect($dsninfo, $persistent = false)
 {
     if (!DB::assertExtension('msql')) {
         return $this->raiseError(DB_ERROR_EXTENSION_NOT_FOUND);
     }
     $this->dsn = $dsninfo;
     $user = $dsninfo['username'];
     $pw = $dsninfo['password'];
     $dbhost = $dsninfo['hostspec'] ? $dsninfo['hostspec'] : 'localhost';
     $connect_function = $persistent ? 'msql_pconnect' : 'msql_connect';
     if ($dbhost && $user && $pw) {
         $conn = $connect_function($dbhost, $user, $pw);
     } elseif ($dbhost && $user) {
         $conn = $connect_function($dbhost, $user);
     } else {
         $conn = $connect_function($dbhost);
     }
     if (!$conn) {
         $this->raiseError(DB_ERROR_CONNECT_FAILED);
     }
     if (!@msql_select_db($dsninfo['database'], $conn)) {
         return $this->raiseError(DB_ERROR_NODBSELECTED);
     }
     $this->connection = $conn;
     return DB_OK;
 }
Ejemplo n.º 2
0
 function SelectDatabase()
 {
     if (!strcmp($this->database_name, "")) {
         return $this->SetError("Select database", "It was not specified a valid database name to select");
     }
     $last_connection = $this->connection;
     if (!$this->Connect()) {
         return 0;
     }
     if ($last_connection == $this->connection && strcmp($this->selected_database, "") && !strcmp($this->selected_database, $this->database_name)) {
         return 1;
     }
     if (!msql_select_db($this->database_name, $this->connection)) {
         return $this->SetError("Select database", msql_error());
     }
     $this->selected_database = $this->database_name;
     return 1;
 }
Ejemplo n.º 3
0
function sql_connect($host, $user, $password, $db)
{
    global $dbtype;
    switch ($dbtype) {
        case "MySQL":
            $dbi = @mysql_connect($host, $user, $password);
            mysql_select_db($db);
            return $dbi;
            break;
        case "mSQL":
            $dbi = msql_connect($host);
            msql_select_db($db);
            return $dbi;
            break;
        case "postgres":
            $dbi = @pg_connect("host={$host} user={$user} password={$password} port=5432 dbname={$db}");
            return $dbi;
            break;
        case "postgres_local":
            $dbi = @pg_connect("user={$user} password={$password} dbname={$db}");
            return $dbi;
            break;
        case "ODBC":
            $dbi = @odbc_connect($db, $user, $password);
            return $dbi;
            break;
        case "ODBC_Adabas":
            $dbi = @odbc_connect($host . ":" . $db, $user, $password);
            return $dbi;
            break;
        case "Interbase":
            $dbi = @ibase_connect($host . ":" . $db, $user, $password);
            return $dbi;
            break;
        case "Sybase":
            $dbi = @sybase_connect($host, $user, $password);
            sybase_select_db($db, $dbi);
            return $dbi;
            break;
        default:
            break;
    }
}
Ejemplo n.º 4
0
function OpenDataBase($dbinfo)
{
    global $msql_db;
    if (!($dbc = msql_connect())) {
        $msg = gettext("Cannot establish connection to database, giving up.");
        $msg .= "<BR>";
        $msg .= sprintf(gettext("Error message: %s"), msql_error());
        ExitWiki($msg);
    }
    if (!msql_select_db($msql_db, $dbc)) {
        $msg = gettext("Cannot open database %s, giving up.");
        $msg .= "<BR>";
        $msg .= sprintf(gettext("Error message: %s"), msql_error());
        ExitWiki($msg);
    }
    $dbi['dbc'] = $dbc;
    $dbi['table'] = $dbinfo['table'];
    // page metadata
    $dbi['page_table'] = $dbinfo['page_table'];
    // page content
    return $dbi;
}
Ejemplo n.º 5
0
 /**
  * Connect to the database server, log in and open the database
  *
  * Don't call this method directly.  Use DB::connect() instead.
  *
  * Example of how to connect:
  * <code>
  * require_once 'DB.php';
  * 
  * // $dsn = 'msql://hostname/dbname';  // use a TCP connection
  * $dsn = 'msql:///dbname';             // use a socket
  * $options = array(
  *     'portability' => DB_PORTABILITY_ALL,
  * );
  * 
  * $db =& DB::connect($dsn, $options);
  * if (PEAR::isError($db)) {
  *     die($db->getMessage());
  * }
  * </code>
  *
  * @param array $dsn         the data source name
  * @param bool  $persistent  should the connection be persistent?
  *
  * @return int  DB_OK on success. A DB_Error object on failure.
  */
 function connect($dsn, $persistent = false)
 {
     if (!PEAR::loadExtension('msql')) {
         return $this->raiseError(DB_ERROR_EXTENSION_NOT_FOUND);
     }
     $this->dsn = $dsn;
     if ($dsn['dbsyntax']) {
         $this->dbsyntax = $dsn['dbsyntax'];
     }
     $params = array();
     if ($dsn['hostspec']) {
         $params[] = $dsn['port'] ? $dsn['hostspec'] . ',' . $dsn['port'] : $dsn['hostspec'];
     }
     $connect_function = $persistent ? 'msql_pconnect' : 'msql_connect';
     $ini = ini_get('track_errors');
     $php_errormsg = '';
     if ($ini) {
         $this->connection = @call_user_func_array($connect_function, $params);
     } else {
         ini_set('track_errors', 1);
         $this->connection = @call_user_func_array($connect_function, $params);
         ini_set('track_errors', $ini);
     }
     if (!$this->connection) {
         if (($err = @msql_error()) != '') {
             return $this->raiseError(DB_ERROR_CONNECT_FAILED, null, null, null, $err);
         } else {
             return $this->raiseError(DB_ERROR_CONNECT_FAILED, null, null, null, $php_errormsg);
         }
     }
     if (!@msql_select_db($dsn['database'], $this->connection)) {
         return $this->msqlRaiseError();
     }
     return DB_OK;
 }
Ejemplo n.º 6
0
function sql_connect($host, $user, $password, $db)
{
    global $dbtype;
    switch ($dbtype) {
        case "MySQL":
            $dbi = @mysql_connect($host, $user, $password);
            if (!mysql_select_db($db)) {
                mysql_query("CREATE DATABASE {$db}");
                mysql_select_db($db);
                include 'install.php';
                die;
            }
            return $dbi;
            break;
        case "mSQL":
            $dbi = msql_connect($host);
            if (!msql_select_db($db)) {
                msql_query("CREATE DATABASE {$db}");
                msql_select_db($db);
                include 'install.php';
                die;
            }
            return $dbi;
            break;
        case "PostgreSQL":
            $dbi = @pg_connect("host={$host} user={$user} password={$password} port=5432 dbname={$db}");
            return $dbi;
            break;
        case "PostgreSQL_local":
            $dbi = @pg_connect("user={$user} password={$password} dbname={$db}");
            return $dbi;
            break;
        case "ODBC":
            $dbi = @odbc_connect($db, $user, $password);
            return $dbi;
            break;
        case "ODBC_Adabas":
            $dbi = @odbc_connect($host . ":" . $db, $user, $password);
            return $dbi;
            break;
        case "Interbase":
            $dbi = @ibase_connect($host . ":" . $db, $user, $password);
            return $dbi;
            break;
        case "Sybase":
            $dbi = @sybase_connect($host, $user, $password);
            if (!sybase_select_db($db, $dbi)) {
                sybase_query("CREATE DATABASE {$db}", $dbi);
                sybase_select_db($db, $dbi);
                include 'install.php';
                die;
            }
            return $dbi;
            break;
        default:
            break;
    }
}
Ejemplo n.º 7
0
 function connect_msql($host, $user, $pass, $db)
 {
     $this->msql_link = msql_connect($host, $user, $pass);
     if ($this->msql_link == 0) {
         return false;
     }
     if (!msql_select_db($db, $this->msql_link)) {
         print "Database Error " . msql_error();
         return false;
     }
     return $this->msql_link;
 }