db_settings.php

来自「视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.」· PHP 代码 · 共 35 行

<?php
// $Id: db_settings.php,v 1.1 2005/02/25 14:25:08 quipo Exp $

$dbtype = isset($_GET['type']) ? $_GET['type'] : 'mysql';
$valid_dbms = array(
    'mysql', 'pgsql', 'ibase',
);
if (!in_array($dbtype, $valid_dbms)) {
    $dbtype = 'mysql';
}
define('DB_TYPE',        $dbtype);
define('TABLE_USER',     'querytool_user');
define('TABLE_ADDRESS',  'querytool_address');
define('TABLE_QUESTION', 'question');
define('TABLE_ANSWER',   'answer');

switch ($dbtype) {
    case 'pgsql':
        define('DB_DSN', 'pgsql://user:pwd@host/dbname');
        $GLOBALS['DB_OPTIONS'] = array();
        break;
    case 'ibase':
        define('DB_DSN', 'ibase(firebird)://user:pwd@host/dbname');
        $GLOBALS['DB_OPTIONS'] = array(
            'optimize'    => 'portability',
            'portability' => DB_PORTABILITY_ALL,
        );
        break;
    case 'mysql':
    default:
        define('DB_DSN', 'mysql://user:pwd@host/dbname');
        $GLOBALS['DB_OPTIONS'] = array();
}
$allTables = array(TABLE_USER, TABLE_ADDRESS, TABLE_QUESTION, TABLE_ANSWER);
?>