Introduction - Connect

Description

To connect to a database you have to use the function DB::connect(), which requires a valid DSN as the first parameter. This parameter can either be a string or an array. If using an array, the array used gets merged with the default information:

$dsn = array(     'phptype'  => false,     'dbsyntax' => false,     'username' => false,     'password' => false,     'protocol' => false,     'hostspec' => false,     'port'     => false,     'socket'   => false,     'database' => false, );

The second parameter is the optional $options array that can contain runtime configuration settings for this package. See setOption() for more information on the available settings.

In case of success you get a new instance of the database class. It is strongly recommened to check this return value with DB::isError().

To disconnect use the method disconnect() from your database class instance.

<?php require_once 'DB.php';  $dsn = 'pgsql://someuser:apasswd@localhost/thedb'; $options = array(     'debug'       => 2,     'portability' => DB_PORTABILITY_ALL, );  $db =& DB::connect($dsn, $options); if (DB::isError($db)) {     die($db->getMessage()); }  // ...  $db->disconnect(); ?>

<?php require_once 'DB.php';  $dsn = array(     'phptype'  => 'pgsql',     'username' => 'someuser',     'password' => 'apasswd',     'hostspec' => 'localhost',     'database' => 'thedb', );  $options = array(     'debug'       => 2,     'portability' => DB_PORTABILITY_ALL, );  $db =& DB::connect($dsn, $options); if (DB::isError($db)) {     die($db->getMessage()); } ?>

See

DB_Error, setOption(), Intro - Portability