/
index.php
124 lines (105 loc) · 3.02 KB
/
index.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?php
/**
* 首页
*
* @version 2010-1-7 14:35:11
* @author Zerolone
*/
require('include/common.php');
define('PAGENAME','index.php');
$cateid = Request('cateid',0); //读取分类
$pagenum = Request('pagenum',1); //读取页数
$searchkey = Request('searchkey'); //搜索
$pagesize = 5 ; //页面记录数
$SqlStr = 'SELECT COUNT( * ) FROM `'.DB_TABLE_PRE.'mb_blog` ';
$SqlStr.= ' WHERE 1=1 ' ;
if ($cateid<>0) {
$SqlStr.= ' AND `cateid` ='.$cateid ;
}
if($searchkey<>''){
$SqlStr.= ' AND `title` like \'%'. $searchkey .'%\' ' ;
}
$MyDatabase->SqlStr = $SqlStr;
$recordcount = 0; //总记录
if ($MyDatabase->Query ()) {
$DB_Record = $MyDatabase->ResultArr [0];
$recordcount = $DB_Record[0];
}
//*/
//Blog列表
//-------------------0------1---------2------------3----------4----------5
$SqlStr = ' SELECT `id`, `title`, `posttime`, `catetitle`, `cateid`, `content` from `'.DB_TABLE_PRE.'mb_view_blog`';
$SqlStr.= ' WHERE 1=1 ';
if ($cateid<>0) {
$SqlStr.= ' AND `cateid`='.$cateid;
}
if($searchkey<>''){
$SqlStr.= ' AND `title` like \'%'. $searchkey .'%\' ' ;
}
$SqlStr.= ' ORDER BY `id` DESC';
$SqlStr.= ' LIMIT '. $pagesize * ($pagenum-1) .' ,'.$pagesize.';';
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$DB_Record_Arr = $MyDatabase->ResultArr;
foreach ( $DB_Record_Arr as $DB_Record ) {
$str_content = $DB_Record[5];
$str_content = str_replace('{html_and}','&',$str_content);
$blog_list[] = array(
'id' => $DB_Record[0],
'title' => $DB_Record[1],
'posttime' => $DB_Record[2],
'catetitle' => $DB_Record[3],
'cateid' => $DB_Record[4],
'content' => $str_content,
);
}
}
//栏目列表
//------------------0------1
$SqlStr = 'SELECT `id`, `title` FROM `' .DB_TABLE_PRE. 'mb_cate` Order By `order`';
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$DB_Record_Arr = $MyDatabase->ResultArr;
foreach ( $DB_Record_Arr as $DB_Record ) {
$cate_list[] = array(
'id' => $DB_Record[0],
'title' => $DB_Record[1],
);
}
}
//每月条数统计
//------------------------------0----===========--1
$SqlStr = 'SELECT COUNT(left(posttime,7)), left(posttime,7) as `sj` FROM `' .DB_TABLE_PRE. 'mb_blog` GROUP By `sj` Order By `posttime` DESC LIMIT 5;';
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$DB_Record_Arr = $MyDatabase->ResultArr;
foreach ( $DB_Record_Arr as $DB_Record ) {
$posttime_list[] = array(
'count' => $DB_Record[0],
'month' => $DB_Record[1],
);
}
}
//quick列表
//-------------------0
$SqlStr = ' SELECT `title` from `'.DB_TABLE_PRE.'mb_quick`';
$SqlStr.= ' ORDER BY `id` DESC';
$SqlStr.= ' LIMIT 5;';
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$DB_Record_Arr = $MyDatabase->ResultArr;
foreach ( $DB_Record_Arr as $DB_Record ) {
$quick_list[] = array(
'title_long' => $DB_Record[0],
// 'title' => subString($DB_Record[0],36),
'title' => utf_substr($DB_Record[0],42),
);
}
}
//管理员日志
$ThisPage='index.php';
$log_content = 'Blog列表';
require('include/log.php');
require(PAGENAME.'.php');
require('include/debug.php');
?>