Independent Digital

I thought I’d put together this tutorial for those of you, like me, would like to use something to make life easier when using databases but are somewhat overwhelmed when first dabbling with database abstraction layers such as PEAR:mdb2. Fear not, mdb2 is pretty easy to use once you know how. And that is the point of this tutorial, to show you how to use mdb2 without too much hassle.

This is not a tutorial in the sense that I ramble on and give snippets of code which eventually leaves you totally confused. Rather I have created a package of files covering the main aspects of mdb2. Each file has all the code commented to make understanding the code very easy. So for example the create_db.php file has all the code necessay to create a database. You actually run the code and enter a database name and the database is created. Here’s a sample from the code:

//create the data source name
$dsn = ‘mysql://root:sasha@localhost’;//database name is omitted as it will be added from your input
//do the connection thing
$mdb2 =& MDB2::connect($dsn);
//if there is an error
if (PEAR::isError($mdb2))
{
die($mdb2->getMessage());
}
// loading the Manager module
$mdb2->loadModule(’Manager’);

By working through the code and acompanying comments, you will quickly see how easy it is to use mdb2. Naturally you can tweek the code and use it as you please.

The files in the package cover the following:

You can get the file package here

Sorry, there are no related posts but check these out

• Why Article Marketing Is The Best Way To Drive Traffic To Your Blog
• PEAR:Quickform FAQ’s - a reference guide
• Search Engine Rules For Better SEO
• MySQL general security guidelines. Part 3.
• WordPress help - A comprehensive resource list for beginners and seasoned users. Part 4. Setting up WordPress.