Introduction - Connect -- Connecting and disconnecting a database
Description
To connect to a database you have to use the function
DB::connect(), which requires a valid
DSN
as parameter and
optional a boolean value, which determines wether to use a
persistent connection or not. 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.
Example 20-1. Connect and disconnect <?php
require_once 'DB.php';
$user = 'foo';
$pass = 'bar';
$host = 'localhost';
$db_name = 'clients_db';
// Data Source Name: This is the universal connection string
$dsn = "mysql://$user:$pass@$host/$db_name";
// DB::connect will return a PEAR DB object on success
// or an PEAR DB Error object on error
$db = DB::connect($dsn);
// With DB::isError you can differentiate between an error or
// a valid connection.
if (DB::isError($db)) {
die ($db->getMessage());
}
....
// close conection
$db->disconnect();
?> |
|