Introduction - Connect
Introduction - Connect – Connecting and disconnecting a database
Description
To connect to a database you have to use the function MDB::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 recommended to check this return value with MDB::isError() . To disconnect use the method disconnect() from your database class instance.
Connect and disconnect
<?php
require_once 'MDB.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";
// MDB::connect will return a PEAR MDB object on success
// or an PEAR MDB Error object on error
$db = MDB::connect($dsn);
// With MDB::isError you can differentiate between an error or
// a valid connection.
if (MDB::isError($db)) {
die ($db->getMessage());
}
....
// close conection
$db->disconnect();
?>