PHP DB_MySQL::select_db示例

define('IN_SAESPOT', 1);
@header("content-Type: text/html; charset=UTF-8");
$sqlfile = dirname(__FILE__) . '/yunbbs_mysql.sql';
if (!is_readable($sqlfile)) {
    exit('数据库文件不存在或者读取失败');
}
$fp = fopen($sqlfile, 'rb');
$sql = fread($fp, 2048000);
fclose($fp);
include dirname(__FILE__) . '/config.php';
include dirname(__FILE__) . '/include/mysql.class.php';
$DBM = new DB_MySQL();
$DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname);
unset($servername_m, $dbusername, $dbpassword);
$DBM->select_db($dbname);
if ($DBM->geterrdesc()) {
    if (mysql_get_server_info() > '4.1') {
        $DBM->query("CREATE DATABASE {$dbname} DEFAULT CHARACTER SET {$dbcharset}");
    } else {
        $DBM->query("CREATE DATABASE {$dbname}");
    }
    if ($DBM->geterrdesc()) {
        exit('指定的数据库不存在, 系统也无法自动建立, 无法安装.<br />');
    } else {
        $DBM->select_db($dbname);
        //成功建立指定数据库
    }
}
$DBM->query("SELECT COUNT(*) FROM `yunbbs_settings`", 'SILENT');
if (!$DBM->geterrdesc()) {

示例#2

显示文件

文件： install.php 项目： power12317/Youbbs-Openshift2

define('IN_SAESPOT', 1);
@header("content-Type: text/html; charset=UTF-8");
$sqlfile = dirname(__FILE__) . '/yunbbs_mysql.sql';
if (!is_readable($sqlfile)) {
    exit('数据库文件不存在或者读取失败');
}
$fp = fopen($sqlfile, 'rb');
$sql = fread($fp, 2048000);
fclose($fp);
include dirname(__FILE__) . '/config.php';
include dirname(__FILE__) . '/include/mysql.class.php';
$DBS = new DB_MySQL();
$DBS->connect($servername, $dbport, $dbusername, $dbpassword, $dbname);
unset($servername, $dbusername, $dbpassword);
$DBS->select_db($dbname);
if ($DBS->geterrdesc()) {
    if (mysql_get_server_info() > '4.1') {
        $DBS->query("CREATE DATABASE {$dbname} DEFAULT CHARACTER SET {$dbcharset}");
    } else {
        $DBS->query("CREATE DATABASE {$dbname}");
    }
    if ($DBS->geterrdesc()) {
        exit('指定的数据库不存在, 系统也无法自动建立, 无法安装.<br />');
    } else {
        $DBS->select_db($dbname);
        //成功建立指定数据库
    }
}
$query - $DBS->query("SELECT COUNT(*) FROM yunbbs_settings", 'SILENT');
if (!$DBS->geterrdesc()) {

示例#3

显示文件

文件： ins_lib.php 项目： BGCX261/zlskytakeorder-svn-to-git

function mysqlconn($configfile)
{
    include $configfile;
    //包含配置文件，并使用它连接数据库
    include 'func_db_mysql.php';
    $DB = new DB_MySQL();
    $quit = False;
    //创建一个新的数据库对象
    $DB->connect($servername, $dbusername, $dbpassword, $dbname, $usepconnect, $dbcharset);
    unset($servername, $dbusername, $dbpassword, $usepconnect);
    //销毁变量
    $curr_php_version = PHP_VERSION;
    //PHP的版本
    if ($curr_php_version < '4.0.6') {
        echo "<font color=\"#FF0000\">由于您的PHP版本过低, 无法继续安装 ,请更换版本大于4.0.6的PHP版本。3秒后返回配置页面</font></br>";
        echo "<font color=\"#FF0000\"><a href='setting.php'>立即返回</a></font>";
        echo "<meta http-equiv='refresh' content='3; url=setting.php'>";
        exit;
    }
    $query = $DB->query("SELECT VERSION()");
    //查询mysql版本信息
    $curr_mysql_version = $DB->result($query, 0);
    if ($curr_mysql_version < '3.23') {
        //mysql版本< 3.23
        echo "<font color=\"#FF0000\">您的MySQL版本低于3.23, 无法继续安装 ,建议您换 MySQL4 的数据库服务器。3秒后返回配置页面</font></br>";
        echo "<font color=\"#FF0000\"><a href='setting.php'>立即返回</a></font>";
        echo "<meta http-equiv='refresh' content='3; url=setting.php'>";
        exit;
    }
    /**************执行建立数据库***************/
    $DB->query("DROP DATABASE IF EXISTS {$dbname}");
    if (mysql_get_server_info() > '4.1') {
        $DB->query("CREATE DATABASE {$dbname} DEFAULT CHARACTER SET {$dbcharset}");
    } else {
        $DB->query("CREATE DATABASE {$dbname}");
    }
    $DB->select_db($dbname);
    $tablenum = '0';
    runquery($sqlfile, $DB, $db_prefix, $tablenum = '0', $dbcharset);
    //执行SQL 语句
}