示例#1
0
 /**
 * Creates a new db layer
 *
 * @abstract 
 * @access   public
 *
 * @param    String      $layerType          'ADODB', 'METABASE', 'MYSQL', 'PEAR', PHPLIB'
 * @param    String      $libraryPath        path to the abstraction layer
 * @param    String      $dbType             for the abstraction layers (e.g. 'ODBC')
 * @param    Integer     $preferredResType   the preferred result type
 * 
 * @returns  AbstractDB
 */
 public static function getLayer($layerType, $libraryPath, $dbType, $preferredResType = ANYDB_RES_ASSOC)
 {
     $path = dirname(__FILE__) . '/dbs/';
     $layer = strtoupper(trim($layerType));
     // checks if php extension is loaded
     if ($dbType != '') {
         anyDB::checkForDB($dbType);
     } else {
         anyDB::checkForDB($layer);
     }
     // gets the layer
     $res = null;
     switch ($layer) {
         case 'DBX':
             require_once $path . 'DbxDB.php';
             $res = new DbxDB($libraryPath, $dbType, $preferredResType);
             break;
         case 'METABASE':
             require_once $path . 'MetabaseDB.php';
             $res = new MetabaseDB($libraryPath, $dbType, $preferredResType);
             break;
         case 'MYSQL':
             require_once $path . 'MysqlDB.php';
             $res = new MysqlDB('', 'mysql', $preferredResType);
             break;
         case 'PGSQL':
         case 'POSTGRES':
             require_once $path . 'PostgresDB.php';
             $res = new PostgresDB('', 'pgsql', $preferredResType);
             break;
         case 'PEAR':
             require_once $path . 'PearDB.php';
             $res = new PearDB($libraryPath, $dbType, $preferredResType);
             break;
         case 'PHPLIB':
             require_once $path . 'PhplibDB.php';
             $res = new PhplibDB($libraryPath, $dbType, $preferredResType);
             break;
         case 'ADODB':
             require_once $path . 'ADOdbDB.php';
             $res = new ADOdbDB($libraryPath, $dbType, $preferredResType);
             break;
         case 'SQLITE':
             require_once $path . 'SQLiteDB.php';
             $res = new SQLiteDB('', 'sqlite', $preferredResType);
             break;
         default:
             die('Unknown database layer!');
     }
     return $res;
 }
<?php

require_once '../anyDB.php';
require_once '../addon/DBHelper.php';
require_once '../addon/QueryHelper.php';
$database = 'test';
$host = 'localhost';
$user = '';
$password = '';
$dbType = 'mysql';
// create a new db layer
$db = anyDB::getLayer('MYSQL', '', $dbType);
//$db = anyDB::getLayer('PEAR', 'c:/php4/pear/', $dbType);
//$db = anyDB::getLayer('PHPLIB', '../../../inc/phplib-7.2d/', $dbType);
//$db = anyDB::getLayer('METABASE', '../../../inc/metabase/', $dbType);
//$db = anyDB::getLayer('ADODB', '../../../inc/adodb/', $dbType);
//$db = anyDB::getLayer('DBX','../../../inc/dbx/', $dbType);
//connect to db
$db->connect($host, $database, $user, $password);
<?php

require_once './anyDB/anyDB.php';
require_once './anyDB/addon/DBHelper.php';
require_once './anyDB/addon/QueryHelper.php';
$database = 'idrc_db1';
$host = 'localhost';
//$user = '******';
//$password = '******';
$user = '******';
$password = '******';
$dbType = 'mysql';
// create a new db layer
//$db = anyDB::getLayer('MYSQL','', $dbType);
//$db = anyDB::getLayer('PEAR', 'C:\apachefriends\xampp\php\pear', $dbType);
//$db = anyDB::getLayer('PHPLIB', '../../../inc/phplib-7.2d/', $dbType);
//$db = anyDB::getLayer('METABASE', '../../../inc/metabase/', $dbType);
$db = anyDB::getLayer('ADODB', './adodb', $dbType);
//$db = anyDB::getLayer('DBX','../../../inc/dbx/', $dbType);
//connect to db
$db->connect($host, $database, $user, $password) or die("Connection Not Established");
<?php

require_once '../anyDB.php';
require_once '../addon/DBHelper.php';
require_once '../addon/QueryHelper.php';
$database = 'ehmis_00256_e001';
$host = 'localhost';
$user = '******';
$password = '******';
$dbType = 'mysql';
// create a new db layer
//$db = anyDB::getLayer('MYSQL','', $dbType);
//$db = anyDB::getLayer('PEAR', 'C:\apachefriends\xampp\php\pear', $dbType);
//$db = anyDB::getLayer('PHPLIB', '../../../inc/phplib-7.2d/', $dbType);
//$db = anyDB::getLayer('METABASE', '../../../inc/metabase/', $dbType);
$db = anyDB::getLayer('ADODB', 'C:\\apachefriends\\xampp\\php\\pear\\adodb', $dbType);
//$db = anyDB::getLayer('DBX','../../../inc/dbx/', $dbType);
//connect to db
$db->connect($host, $database, $user, $password) or die('No Connection');