Installing a PEAR Package - Using the installed Packages
(Page 2 of 5 )
Let’s test the PEAR DB package. In a text editor add the following code:
<?php
// You know you're gonna need this
// Imports all the PEAR::DB classes, static
// methods, etc...
require_once 'db.php';
// Get the connection variables:
include 'connx.php';
// Build a DSN string (Data Source Name)
// Required by DB::connect()
$dsn = $dbtype . "://"
.$dbuser . ":"
. $dbpass . "@"
. $dbhost . "/"
. $dbname;
// or, a database error object if it went wrong.
// The boolean specifies this is a persistent
// connection like mysql_pconnect(), it
// defaults to FALSE.
$db = DB::connect($dsn, TRUE);
// Check whether the object is a connection or
// an error.
// Print out a message and exit if it's
// an error object.
if (DB::isError($db)) {
die($db->getMessage());
}else{
print 'All is well';
}
// Close the connection.
$db->disconnect();
?>
The two includes at the beginning of the code block call the db class and a file called connx.php. The db file refers to the db package that we just installed, which can be accessed from anywhere in the system. And the connx.php file simply refers to a file that contains the database connection credentials, which are used to connect to the database.
The next step is to create a Data Source Name or DSN, which is required by the DB::Connect() function:
$dsn = $dbtype . "://"
.$dbuser . ":"
. $dbpass . "@"
. $dbhost . "/"
. $dbname;
The parameters are all stored in the included connx.php file. Then the code actually connects to the database using the dsn:
$db = DB::connect($dsn, TRUE);
Then we check to see if the connection is an error and if so, we print out an appropriate message:
if (DB::isError($db)) {
die($db->getMessage());
}else{
print 'All is well';
}
Otherwise a positive message is printed out and the connection is closed:
