common.func.html
2.28 KB
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
<?php
function format_date($time){
$t=time()-$time;
$f=array(
'31536000'=>'年',
'2592000'=>'个月',
'604800'=>'星期',
'86400'=>'天',
'3600'=>'小时',
'60'=>'分钟',
'1'=>'秒'
);
foreach ($f as $k=>$v) {
if (0 !=$c=floor($t/(int)$k)) {
return $c.$v.'前';
}
}
}
function kp_site_article($params = array()) {
global $_GPC, $_W;
extract($params);
$pindex = max(1, intval($_GPC['page']));
if (!isset($limit)) {
$psize = 10;
} else {
$psize = intval($limit);
$psize = max(1, $limit);
}
$result = array();
$condition = " WHERE uniacid = :uniacid ";
$pars = array(':uniacid' => $_W['uniacid']);
if (!empty($cid)) {
$category = pdo_fetch("SELECT parentid FROM ".tablename('site_category')." WHERE id = :id", array(':id' => $cid));
if (!empty($category['parentid'])) {
$condition .= " AND ccate = :ccate ";
$pars[':ccate'] = $cid;
} else {
$condition .= " AND pcate = :pcate";
$pars[':pcate'] = $cid;
}
}
if ($iscommend == 'true') {
$condition .= " AND iscommend = '1'";
}
if ($ishot == 'true') {
$condition .= " AND ishot = '1'";
}
$keyword = $_GPC['keyword'];
$keyword = addslashes($keyword);
if (!empty($keyword)){
$condition .= " AND title like :keyword";
$pars[':keyword'] = '%'.$keyword.'%';
}
$sql = "SELECT * FROM ".tablename('site_article'). $condition. ' ORDER BY displayorder DESC, id DESC LIMIT ' . ($pindex - 1) * $psize .',' .$psize;
$result['list'] = pdo_fetchall($sql, $pars);
$total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename('site_article') . $condition, $pars);
$result['pager'] = pagination($total, $pindex, $psize);
if (!empty($result['list'])) {
foreach ($result['list'] as &$row) {
if(empty($row['linkurl'])) {
$row['linkurl'] = murl('site/site/detail', array('id' => $row['id'], 'uniacid' => $_W['uniacid']));
}
$row['thumb'] = tomedia($row['thumb']);
}
}
return $result;
}
?>