ôʻ
select ѡ
count 
table 
where 
result 
perpage ÿҳ
curpage ǰҳ
update 
delete ɾ
insert д
dateline 
time ʱ
echo    <?php   echo '123';   ?>
multi ҳ
if 
else 
start ʼ
limit   limit 10
DESC 
ASC 

õ
$qishi = DB::result(DB::query("SELECT qi FROM ".DB::table('jiangchi')." WHERE id = '1'"));

ͳ
$qishi = DB::result(DB::query("SELECT count(*) FROM ".DB::table('jiangchi')." WHERE id = '1'"));

ݱ
$perpage = 20;
$curpage = empty ( $_GET['page'] ) ? 1 : intval ( $_GET['page'] );
$start = ($curpage-1)*$perpage;
$askcount = DB::result(DB::query("SELECT COUNT(*) FROM ".DB::table('forum_thread')." WHERE fid = '2' AND authorid > 1 AND FROM_UNIXTIME(dateline, '%Y%m%d') = '$jintian'"));
//$asklist
$asklist = array();
if ($askcount) {
	$query = DB::query("SELECT * FROM ".DB::table('forum_thread')." WHERE fid = '2' AND displayorder > -1 ORDER BY tid ASC LIMIT $start,$perpage");
	while ($value = DB::fetch($query)) {
		$asklist[] = $value;
	}
}
$multi = multi($askcount, $perpage, $curpage, "portal.php?mod=topic&topic=ask");


ݱ
$perpage = 40;
$curpage = empty ( $_GET['page'] ) ? 1 : intval ( $_GET['page'] );
$start = ($curpage-1)*$perpage;
$acount = DB::result(DB::query("SELECT count(*) FROM ".DB::table('forum_forum')." b LEFT JOIN ".DB::table('forum_forumfield')." bf ON bf.fid=b.fid WHERE b.type='sub' AND b.status = 3 AND bf.icon != ''"));
//$alist
$alist = array();
if ($acount) {
	$query = DB::query("SELECT bf.*, b.* FROM ".DB::table('forum_forum')." b LEFT JOIN ".DB::table('forum_forumfield')." bf ON bf.fid=b.fid WHERE b.type='sub' AND b.status = 3 AND bf.icon != '' ORDER BY bf.shoplevel DESC, b.commoncredits DESC, bf.fid DESC LIMIT $start,$perpage");
	while ($value = DB::fetch($query)) {
		$alist[] = $value;
	}
}
$multi = multi($acount, $perpage, $curpage, "дתַ");

ǰ̨ʾ
<!--{loop $alist $key $value}-->
<!--{eval $tupianfm = DB::result(DB::query("SELECT attachment FROM ".DB::table('forum_threadimage')." WHERE tid = '$value[tid]'"));}-->
$value[authorid]
<!--{/loop}-->

Իʱ
<!--{echo dgmdate(дʱ, 'u', '9999', getglobal('setting/dateformat'))}-->
<!--{echo date("Y-m/d H:i:s",дʱ)}-->

ȡַ
<!--{echo cutstr(д,40)}-->

дݿ
if(submitcheck('tijiao')) {
	$setarr = array(
		'tid' => $_GET['topicid'],
		'name' => $_POST['name'],
		'position' => $_GET['position'],
		'dateline' => $_G['timestamp'],
	);
	DB::insert('forum_poststick', $setarr, 1);
	$query = DB::query("UPDATE ".DB::table('forum_thread')." SET stickreply='1' 
		WHERE tid='$tid'");
	$query = DB::query("DELETE FROM ".DB::table('forum_post')." 
		WHERE pid='$pid'");
	showmessage('ɹʾϢ', "forum.php?mod=viewthread&tid=$tid");
}

ύ
<form action="do.php?op=jiangchi&con=yes" method="post" autocomplete="off">
	<input type="hidden" value="{FORMHASH}" name="formhash" />
	ͽ<input name="qi" type="text" value="$qishi" />
	߽<input name="end" type="text" value="$zhzh" />
	<button value="true" name="tijiao" type="submit">ύ</button>
	<input type="hidden" name="tijiao" value="true" />
</form>

ʱʽǶԵȹϵ
date("Ymd",time());  20150212
FROM_UNIXTIME(dateline, '%Y%m%d')
ǰPHPݿõֶεĸʽ

ͼƬ
<!--{eval $biaoid = substr($value[tid], -1); $cover = DB::result(DB::query("SELECT attachment FROM ".DB::table('forum_attachment_'.$biaoid.'')." WHERE tid = '$value[tid]'"));}-->