$DB 初始化了一个数据库操作类,$DB->query只是调用了查询.例如类里面有个connect,调用就用$DB->connect();
解决方案 »
- 一个PHP递归程序请教大家下。。
- mysql里面一个表就2m多。是不是我设计的不合理?
- $_GET['zhuanye']
- 想实现这样一个缓存功能,请大家帮忙.
- 一个关于表单的初级问题
- 如何在mysql中读出二进制的文件内容
- 我想自动将某个目录下(有子目录)的所有文件加上个头文件,做得到吗?
- 请问,为什么调用组件总是出错
- win8.1 专业版 64位 (PHP5.4.33) (没有使用wampserver)redis扩展无法生效
- 关于httpd.ini转换.htaccess问题---求解
- 怎样理解这句话:(php)能处理的最大十进位数字为 2147483647。
- 请问如何将连接后面带的PHPSESSID去掉。linux9.0 + php4.2 + apache2.0 ,在线等!
如$DB->query("SELECT news.*,user.username,user.userid
意思是执行$DB对象中的query函数
error_reporting(7);if ($showqueries==1 OR $_GET[showqueries]==1){
$script_start_time = microtime();
}require "admin/config.php";
require "admin/class/mysql.php";
require "admin/configs/setting.php";//var_dump($configuration);
//extract($configuration,EXTR_SKIP);extract($configuration,EXTR_OVERWRITE);
$DB = new DB_MySQL;$DB->servername = $servername;
$DB->dbname = $dbname;
$DB->dbusername = $dbusername;
$DB->dbpassword = $dbpassword;$DB->connect();
$DB->selectdb();
require "admin/functions.php";if (get_magic_quotes_gpc()) { $_GET = stripslashes_array($_GET);
$_POST = stripslashes_array($_POST);
$_COOKIE = stripslashes_array($_COOKIE);
//$GLOBALS = stripslashes_array($GLOBALS);}extract($_GET,EXTR_SKIP);
extract($_POST,EXTR_SKIP);unset($debug);
unset($exp);
set_magic_quotes_runtime(0);$onlineuser = 0;
require "admin/class/session.php";if (empty($url)) {
$url = $_SERVER[REQUEST_URI];
}
$url = htmlspecialchars($url);unset($pauserinfo);if (!$_SESSION[logined]) {
$pauserinfo = getuserinfo($_COOKIE[pauserid],$_COOKIE[papasswordhash]);
//print_rr($pauserinfo);
//exit;
if (empty($pauserinfo)) {
$pauserinfo = array();
$usergroup = $DB->fetch_one_array("SELECT * FROM ".$db_prefix."usergroup WHERE usergroupid=4"); // get guest's permission
$pauserinfo = $usergroup;
$pauserinfo[timezoneoffset] = $timezone;
unset($usergroup);
} else {
$_SESSION[logined] = 1;
}
$_SESSION[pauserinfo] = $pauserinfo;
}
$pauserinfo = $_SESSION[pauserinfo];
//print_rr($_SESSION);
//print_rr($pauserinfo);$onlineusers = $DB->fetch_one_array("SELECT COUNT(DISTINCT ipaddress) AS total FROM ".$db_prefix."session WHERE expiry>".time()."");
$onlineuser += $onlineusers[total];
$filename = basename($_SERVER[SCRIPT_NAME]);
unset($styleid);
if ($filename=="article.php") { if (!empty($_GET[articleid])) {
$articleid = intval($_GET[articleid]);
$pagenum = intval($_GET[pagenum]);
} if (empty($articleid)) {
$nav = $_SERVER["REQUEST_URI"];
$script = $_SERVER["SCRIPT_NAME"];
$nav = ereg_replace("^$script","",urldecode($nav));
$vars = explode("/",$nav);
$articleid = intval($vars[1]);
if (!empty($vars[2])) {
$pagenum = intval($vars[2]);
}
}
$article = $DB->fetch_one_array("SELECT * FROM ".$db_prefix."article WHERE articleid='$articleid'");
$sort = $DB->fetch_one_array("SELECT styleid FROM ".$db_prefix."sort WHERE sortid='$article[sortid]'"); $styleid = $sort[styleid];
unset($sort);
//unset($article);} else if ($filename=="sort.php") { if (!empty($_GET[sortid])) {
$sortid = intval($_GET[sortid]);
$pagenum = intval($_GET[pagenum]);
} else {
$nav = $_SERVER["REQUEST_URI"];
$script = $_SERVER["SCRIPT_NAME"];
$nav = ereg_replace("^$script","",urldecode($nav));
$vars = explode("/", $nav);
$sortid = intval($vars[1]); if (!empty($vars[2])) {
$pagenum = intval($vars[2]);
}
} $sortinfo = $DB->fetch_one_array("SELECT * FROM ".$db_prefix."sort WHERE sortid='$sortid'");
if (!empty($sortinfo[styleid])) {
$styleid = $sortinfo[styleid];
}
//unset($sortinfo);}$style = getstyle();
unset($_GET[templatelist]);
unset($_POST[templatelist]);if (empty($noheader)) {
if (trim($templatelist)!="") {
$templatelist .= ",";
}
$templatelist .= "header,footer,";
}if (trim($templatelist)!="") {
$templatelist .= ",";
}$templatelist .="headinclude,searchcode,sortlist,sortlistbit_level1,sortlistbit_level2,sortlistbit_level3,nav,nav_joiner,logincode,logoutcode,navbar,navbar_joiner,navbar_sort";
cachetemplatelist($templatelist);
eval("\$headinclude = \"".gettemplate('headinclude')."\";");
if (empty($noheader)) {
eval("\$header = \"".gettemplate('header')."\";");
eval("\$footer = \"".gettemplate('footer')."\";");
}
//print_rr($pauserinfo);
?>