destoon自定义函数获取分类名称，地区名称，几天前时间，...
需要在api/extend.func.php 文件中加入的函数1、获取分类名称 cat_name($catid) 传入分类idfunction cat_name($catid) {
global $db;
$catid = intval($catid);
$catname = '';
$r = $db->get_one("SELEC<span style="box-sizing: border-box; word-break: break-all; text-size-adjust: none;">t catname FROM {$db->pre}category WHER<span style="box-sizing: border-box; word-break: break-all; text-size-adjust: none;">e catid=$catid");
$catname = $r['catname'];
return $catname;
}</span></span>
2、获取地区名称 area_name($areaid) 传入地区id
function area_name($areaid) {
global $db;
$catid = intval($areaid);
$areaname = '';
$r = $db->get_one("SELEC<span style="box-sizing: border-box; word-break: break-all; text-size-adjust: none;">t areaid,areaname FROM {$db->pre}area WHER<span style="box-sizing: border-box; word-break: break-all; text-size-adjust: none;">e areaid=$areaid");
$areaname = $r['areaname'];
return $areaname ? :'全国';
}</span></span>
3、时间格式化 比如几天前 gl_format_date($time)
<p style="box-sizing: border-box; word-break: break-all; text-size-adjust: none; color: rgb(51, 51, 51); font-family: " microsoft="" yahei",="" "hanhei="" sc",="" pinghei,="" "pingfang="" "helvetica="" neue",="" helvetica,="" arial,="" "hiragino="" sans="" gb",="" "heiti="" "wenquanyi="" micro="" hei",="" sans-serif;="" font-size:="" 16px;"=""><span style="box-sizing: border-box; word-break: break-all; text-size-adjust: none; color: rgb(47, 156, 10); font-family: Verdana, Arial; line-height: 21px; background-color: rgb(253, 253, 253);">//时间格式化 传入时间戳格式1464662723</span></p><p style="box-sizing: border-box; word-break: break-all; text-size-adjust: none; color: rgb(51, 51, 51); font-family: " microsoft="" yahei",="" "hanhei="" sc",="" pinghei,="" "pingfang="" "helvetica="" neue",="" helvetica,="" arial,="" "hiragino="" sans="" gb",="" "heiti="" "wenquanyi="" micro="" hei",="" sans-serif;="" font-size:="" 16px;"="">function gl_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.'前';
}
}
};
</p>
4、获取评论数 gl_get_comments($mid,$itemid) function gl_get_comments($mid,$itemid) {
global $db;
$nums = $db->get_one("SELEC<span style="box-sizing: border-box; word-break: break-all; text-size-adjust: none;">t COUNT(*) AS num FROM {$db->pre}comment WHER<span style="box-sizing: border-box; word-break: break-all; text-size-adjust: none;">e item_mid='$mid' and item_id='$itemid'");
return $nums['num'] ;
}</span></span>
页:
[1]