Installing a PEAR Package - mdb2 Package

The next package that we will test is the mdb2 package. Add the following code to a document, save and run it:

<?php

require_once("MDB2.php");

//include 'connx.php';

// Build a DSN string (Data Source Name)

// Required by MDB2::connect()

//$db_driver://$user:$password@$host/$database_name

$url="mysql://root:pass@localhost/cms";

$con = MDB2::factory($url);

if(PEAR::isError($con)) {

die("Error while connecting : " . $con->getMessage());

}else{

echo "Connection with MDB2 was successful";

}

?>

The setup of the second code block is the same as for PEAR::DB which we used before. The only difference, apart from the names, is that we explicitly define the connection URL (previously DSN):

$url="mysql://root:pass@localhost/cms";

Instead of including the connx.php file:

include 'connx.php';

We use the factory method to connect to the database:

$con = MDB2::factory($url);

then we check for any errors while attempting to connect and write out the appropriate message:

if(PEAR::isError($con)) {

die("Error while connecting : " . $con->getMessage());

}else{

echo "Connection with MDB2 was successful";

}

Next: Mail Package >>
 

More PEAR Articles Articles
More By David Web