$tp->assign('mysql_checked', 'checked');
$tp->assign('ado_access_checked', '');
$tp->assign('mysql_display', 'block');
$tp->assign('ado_access_display', 'none');
$tp->assign('ado_mssql_display', 'none');
$moduleTemplate = $tp->result();
$moduleTitle = '数据库连接设置';
} else {
session_start();
if ($_POST['type']) {
$databaseType = $_POST['type'];
} else {
$databaseType = $_GET['type'];
}
include_once 'adodb/adodb.inc.php';
$adodb = adonewconnection($databaseType);
$objName = 'NEAT_DB2DB_' . strtoupper($databaseType);
include_once 'includes/class/extra/NEATDB2DB.' . $databaseType . '.class.php';
$db2db = new $objName();
$db2db->setADODB($adodb);
if ($_GET['setp'] == 'testConnect') {
$dbStatus = $db2db->testConnect();
if (trim($_POST['MYSQL_TARGET_DB_NAME'])) {
$TARGET_DB_NAME = trim($_POST['MYSQL_TARGET_DB_NAME']);
} else {
if (trim($_POST['ADO_ACCESS_TARGET_DB_HOST'])) {
$TARGET_DB_NAME = trim($_POST['ADO_ACCESS_TARGET_DB_HOST']);
} else {
if (trim($_POST['ADO_MSSQL_TARGET_DB_NAME'])) {
$TARGET_DB_NAME = trim($_POST['ADO_MSSQL_TARGET_DB_NAME']);
}
case "i5":
case "u5":
?>
<h1><?php
echo _T("Check of the database");
?>
</h1>
<p><?php
echo _T("Check the parameters and the existence of the database");
?>
</p>
<ul>
<?php
include "../includes/adodb/adodb.inc.php";
$DB = adonewconnection($_POST["install_dbtype"]);
$DB->debug = false;
$permsdb_ok = true;
if (!@$DB->Connect($_POST["install_dbhost"], $_POST["install_dbuser"], $_POST["install_dbpass"], $_POST["install_dbname"])) {
$permsdb_ok = false;
echo "<li class=\"install-bad\">" . _T("Unable to connect to the database") . "</li>";
} else {
echo "<li class=\"install-ok\"> " . _T("Connection to database successfull") . "</li>";
$DB->Close();
}
echo "</ul>";
if (!$permsdb_ok) {
?>
<p><?php
echo _T("Database can't be reached. Please go back to enter the connection parameters again.");
?>
$sql .= $sqlRules . ' ';
$sql .= 'ORDER BY id DESC';
$rs = $db->query($sql, intval($_GET['start']), $eachTimes);
switch ($DB_TYPE) {
case 'mysql':
$TDB = adonewconnection('mysql');
$TDB->Connect($HOST, $USER, $PASS, $NAME);
break;
case 'ado_access':
$myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=' . realpath($HOST) . ';' . 'USER ID=' . $USER . ';PASSWORD='******';';
$TDB = adonewconnection('ado_access');
$TDB->Connect($myDSN, '', '', '');
break;
case 'ado_mssql':
$myDSN = 'Driver={SQL Server};Server=' . $HOST . ';Database=' . $NAME . ';Uid=' . $USER . ';Pwd=' . $PASS . ';';
$TDB = adonewconnection('ado_mssql');
$TDB->Connect($myDSN, '', '', '');
break;
default:
error('不可识别或者不支持的数据库类型');
break;
}
$NBS = new NEATBulidSql($dbAllList['orderList'][0]);
while ($rs->next_record()) {
switch ($DB_TYPE) {
case 'mysql':
$contents['title'] = addslashes($rs->get('title'));
$contents['body'] = addslashes($rs->get('body'));
$contents['date'] = $rs->get('date');
$contents['url'] = addslashes($rs->get('url'));
$contents['author'] = addslashes($rs->get('author'));
<?php
include 'adodb.inc.php';
//include('adodb-exceptions.inc.php');
$db = adonewconnection('mysqli');
$db->connect('localhost', 'root', 'C0yote71', 'mantis_13x');
$db->debug = true;
set_error_handler(function ($errno, $errstr, $errfile, $errline, array $errcontext) {
throw new ErrorException($errstr, 0, $errno, $errfile, $errline);
});
try {
$db->getAssoc('select * from mantis_user_table where 1=1');
$db->getAssoc('select * from mantis_user_table where 0=1');
} catch (Exception $e) {
throw $e;
exit(1);
}
