adrix

I, sorry for my little english ... i speak italian

this is my 2cent; please adjust path for your directory structure.

configuration.php

<?php
$dbHost = 'mysqlServerNameOrIPAddress';
$dbUser = 'mysqlUserName';
$dbPass = 'mysqlUserPassword';
$dbName = 'mysqlDatabaseName';
// Add here other var if necessary for your script
?>

<?php

autoloadClass.php

<?php
spl_autoload_register ( null, false );
/* Warning: Using register extension only if necessary 
spl_autoload_extensions ( '.php, .class.php, .inc' ); */
/* Loader. Warning: Using or modify function name if necessary if you using various directory for class
                               Example: commonClass, siteClass, adminClass
*/
function commonClassLoader ( $className )
{
   $filename = strtolower( $className ) . '.php';
   $file = [b]typeYourPath[/b] . '/common/' . strtolower($className) . '/' . $filename;
       if ( !file_exists ( $file ) )
       {       
           return false;
       }
       require_once $file;
}
?>

database.php

<?php
class Database
{

       /**
        *      Database connections attribute
        */
       private $_dbHost;
       private $_dbUser;
       private $_dbPass;
       private $_dbName;
       private $_linkID;
       private $_selectDB;

        public function __construct ( $dbHost, $dbUser, $dbPass, $dbName ) 
        {


               $this->_dbHost = $dbHost;
               $this->_dbUser = $dbUser;
               $this->_dbPass = $dbPass;
               $this->_dbName = $dbName;
               $this->_linkID = null;
               $this->_selectDB = null;

               /**
                * Create connection.
                */
               $this->_linkID = mysql_connect ( $this->_dbHost, $this->_dbUser, $this->_dbPass);

                        if ( !$this->_linkID ) 
                        { 
                               throw new Exception ( mysql_error() . ' : ' . mysql_errno() );                               
                        }

               // Select db. 
               $this->_selectDB = mysql_select_db ( $this->_dbName, $this->_linkID );

                       if ( !$this->_selectDB )
                       {
                               throw new Exception ( mysql_error() . ' : ' . mysql_errno() );
                       }    
        }

       // Run a query
   public function dbQuery ( $sql )
   {

       $query = mysql_query ( $sql );
       if ( !$query )
       {

           throw new Exception ( mysql_error() . ' : ' . mysql_errno() );

       }
       return $query;

   }

   // Number of rows involved from query        
   public function dbAffectedRows ()
   {

          return mysql_affected_rows ();

   }

   // Last auto incremental id 
   public function dbInsertId ()
   {

          return mysql_insert_id ();

   }

   // Extract result set (
   public function dbFetchArray ( $result, $resultType )
   {

          switch ( $resultType ) {
              case "mysql_num":
                  return mysql_fetch_array ( $result, MYSQL_NUM );
           case "mysql_assoc":
               return mysql_fetch_array ( $result, MYSQL_ASSOC );
           default:
               return mysql_fetch_array ( $result, MYSQL_BOTH );

       }
   }

   // Fetch object method. Using example: $rows->id - $rows->race ... etcetera 
   public function dbFetchObeject ( $result )
   {

       return mysql_fetch_object ( $result );

   }

   // Variant of dbFetchArray method
   public function dbFetchAssoc ( $result )
   {

       return mysql_fetch_assoc ( $result );

   }

   // Variant of dbFetchArray method
   public function dbFetchRow ( $query )
   {

       return mysql_fetch_row( $query );

   }

   // Number of rows in result set.
   public function dbNumRows ( $result )
   {

       return mysql_num_rows ( $result );

   }


}
?>

Example of usage:

<?php
try
{
error_reporting ( E_ALL );
session_start ();
require_once 'configuration.php';
require_once 'autoloadClass.php';
spl_autoload_register ('commonClassLoader');
$db = new Database( $dbHost, $dbUser, $dbPass, $dbName );

/**


               Insert here all code for you project.

*/
} catch (Exception $e) {

   echo $e->getMessage();

}
?>

Enjoy !!