登錄
<a href="member.php?mod=logging&action=login" onclick="showWindow('login', this.href);return false;" title="登錄">登錄</a>

注冊(cè)
<a href="member.php?mod=register" title="立即注冊(cè)">立即注冊(cè)</a>

忘記密碼
<a href="javascript:;" onclick="showWindow('login', 'member.php?mod=logging&action=login&viewlostpw=1')" title="找回密碼">找回密碼</a>

購買邀請(qǐng)碼 misc.php?mod=buyinvitecode

JS跳轉(zhuǎn)
onclick="window.location.href='home.php?mod=mobile&do=friend';"

JS更換class的名稱
document.getElementById('idname').className='a';
document.getElementById('idname').style.display='block';
document.getElementById("idname").style.marginTop="30px";

批量替換超鏈接：href="[^"]*"

過濾DZ代碼：
preg_replace ("/\[[a-z][^\]]*\]|\[\/[a-z]+\]/i",'',preg_replace("/\[attach\]\d+\[\/attach\]/i",'',$message));

………………………………………………………………………………………………………………………………………………………………

調(diào)用單個(gè)數(shù)據(jù)
$qishi = DB::result(DB::query("SELECT qi FROM ".DB::table('jiangchi')." WHERE id = '1'"));

調(diào)用統(tǒng)計(jì)數(shù)據(jù)
$qishi = DB::result(DB::query("SELECT count(*) FROM ".DB::table('jiangchi')." WHERE id = '1'"));

單數(shù)據(jù)表調(diào)用
$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");


多數(shù)據(jù)表調(diào)用
$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, "這里填寫跳轉(zhuǎn)地址");

前臺(tái)數(shù)據(jù)顯示
<!--{loop $alist $key $value}-->
<!--{eval $tupianfm = DB::result(DB::query("SELECT attachment FROM ".DB::table('forum_threadimage')." WHERE tid = '$value[tid]'"));}-->
$value[authorid]
<!--{/loop}-->

取數(shù)據(jù)表中符合條件的第一條數(shù)據(jù)
$app=array();
$app=DB::fetch_first("select * from ".DB::table('home_diy_center')." where id='{$id}'");

人性化時(shí)間戳
<!--{echo dgmdate(這里填寫時(shí)間參數(shù), 'u', '9999', getglobal('setting/dateformat'))}-->
<!--{echo date("Y-m/d H:i:s",這里填寫時(shí)間參數(shù))}-->

截取字符字?jǐn)?shù)
<!--{echo cutstr(這里填寫參數(shù),40)}-->

過濾DISCUZ代碼
preg_replace ("/\[[a-z][^\]]*\]|\[\/[a-z]+\]/i",'',preg_replace("/\[attach\]\d+\[\/attach\]/i",'',$message));

寫入數(shù)據(jù)庫
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" />
	最低獎(jiǎng)金：<input name="qi" type="text" value="$qishi" />　
	最高獎(jiǎng)金：<input name="end" type="text" value="$zhzh" />　　
	<button value="true" name="tijiao" type="submit">提交設(shè)置</button>
	<input type="hidden" name="tijiao" value="true" />
</form>

以下兩個(gè)時(shí)間格式是對(duì)等關(guān)系
date("Ymd",time());  20150212
FROM_UNIXTIME(dateline, '%Y%m%d')
前者用于PHP，后者用于數(shù)據(jù)庫調(diào)用的字段的格式化

調(diào)用圖片附件
<!--{eval $biaoid = substr($value[tid], -1); $cover = DB::result(DB::query("SELECT attachment FROM ".DB::table('forum_attachment_'.$biaoid.'')." WHERE tid = '$value[tid]'"));}-->

數(shù)據(jù)庫循環(huán)嵌套調(diào)用
<!--{eval $slides = DB::fetch_all("SELECT * FROM ".DB::table('a')." WHERE `uid`= $_G[uid] ORDER BY `id` DESC");}-->
<!--{loop $slides $slide}-->
$slide[name]
<!--{/loop}-->

ucenter無法登錄：
打開uc_server/model/admin.php
找到第22行的
$this->cookie_status = 0;
改成
$this->cookie_status = isset($_COOKIE['sid']) ? 1 : 0;

無刷新切換li標(biāo)簽并且同時(shí)加載框架頁面：
<script type="text/javascript"> 
var jq = jQuery.noConflict();
jq(function(){ 
jq("#changemenu>li").mouseover(function(){ 
jq("#changemenu>li").each(function(i){ 
jq(this).removeClass("current"); 
}); 
jq(this).addClass("current"); 
document.getElementById("changenr").innerHTML='<iframe src="chart.php?op=index&id='+jq(this).attr('dataid')+'" height="350" width="1070" frameborder="0" scrolling="no"></iframe>';
}).mouseout(function(){ 
jq(this).addClass("current"); 
}); 
});
</script>
<ul id=“changemenu”>
   <li id="x7tpj75"    class=“current” dataid=“1”></li>
   <li dataid=“2”></li>
</ul>
<div   class="bfbdfhd"   id=“changenr”></div>

快速發(fā)帖
<a href="forum.php?mod=misc&action=nav" onclick="showWindow('nav', this.href, 'get', 0);">發(fā)布新話題</a>

常用詞匯
select 選擇
count 總數(shù)
table 表
where 條件
result 結(jié)果
perpage 每頁
curpage 當(dāng)前頁
update 更新
delete 刪除
insert 寫入
dateline 日期
time 時(shí)間
echo 輸出   <?php   echo '123';   ?>
multi 分頁函數(shù)
if 如果
else 否則
elseif 
start 起始
limit 限制  limit 10
DESC 倒序
ASC 正序<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	<title>www.banban.so - Database Error</title>
	<meta http-equiv="Content-Type" content="text/html; charset=gbk" />
	<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
	<style type="text/css">
	<!--
	body { background-color: white; color: black; font: 9pt/11pt verdana, arial, sans-serif;}
	#container { width: 1024px; }
	#message   { width: 1024px; color: black; }

	.red  {color: red;}
	a:link     { font: 9pt/11pt verdana, arial, sans-serif; color: red; }
	a:visited  { font: 9pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
	h1 { color: #FF0000; font: 18pt "Verdana"; margin-bottom: 0.5em;}
	.bg1{ background-color: #FFFFCC;}
	.bg2{ background-color: #EEEEEE;}
	.table {background: #AAAAAA; font: 11pt Menlo,Consolas,"Lucida Console"}
	.info {
	    background: none repeat scroll 0 0 #F3F3F3;
	    border: 0px solid #aaaaaa;
	    border-radius: 10px 10px 10px 10px;
	    color: #000000;
	    font-size: 11pt;
	    line-height: 160%;
	    margin-bottom: 1em;
	    padding: 1em;
	}

	.help {
	    background: #F3F3F3;
	    border-radius: 10px 10px 10px 10px;
	    font: 12px verdana, arial, sans-serif;
	    text-align: center;
	    line-height: 160%;
	    padding: 1em;
	}

	.sql {
	    background: none repeat scroll 0 0 #FFFFCC;
	    border: 1px solid #aaaaaa;
	    color: #000000;
	    font: arial, sans-serif;
	    font-size: 9pt;
	    line-height: 160%;
	    margin-top: 1em;
	    padding: 4px;
	}
	-->
	</style>
<meta http-equiv="Cache-Control" content="no-transform" />
<meta http-equiv="Cache-Control" content="no-siteapp" />
<script>var V_PATH="/";window.onerror=function(){ return true; };</script>
</head>
<body>
<h1><a href="http://m.sdtechgong.com.cn/">&#30007;&#30340;&#33300;&#22899;&#30340;&#19979;&#38754;&#35270;&#39057;&#22312;&#32447;&#25773;&#25918;&#45;&#23569;&#22919;&#24841;&#24773;&#29702;&#20177;&#29255;&#39640;&#28526;&#26085;&#26412;&#45;&#20037;&#20037;&#20037;&#20037;&#20037;&#22269;&#20135;&#19968;&#21306;&#20108;&#21306;&#19977;&#21306;&#45;&#40635;&#35910;&#31934;&#21697;&#19968;&#21306;&#20108;&#21306;&#32508;&#21512;&#45;&#22269;&#20135;&#31934;&#21697;&#36229;&#30896;&#22312;&#32447;&#35266;&#30475;&#45;&#32593;&#32418;&#26497;&#21697;&#22899;&#31070;&#31934;&#21697;&#35270;&#39057;&#22312;&#32447;&#45;&#22269;&#20135;&#20122;&#27954;&#32508;&#21512;&#55;&#55;&#55;&#45;&#39640;&#28165;&#24615;&#35270;&#39057;&#19968;&#21306;&#20108;&#21306;&#25773;&#25918;&#45;&#20013;&#25991;&#23383;&#24149;&#31532;&#19968;&#39029;&#20122;&#27954;&#22825;&#22530;</a></h1>
<div   class="vffdhh9"   id="container">
<h1>Discuz! Database Error</h1>
<div   id="h5h3fh9"   class='info'>(0) <div   id="vhh5prb"   class="sql">SELECT phone FROM mobile_login_connection WHERE uid = '5235'</div></div>

<div   id="z9z9nzl"   class="info"><p><strong>PHP Debug</strong></p><table cellpadding="5" cellspacing="1" width="100%" class="table"><tr class="bg2"><td>No.</td><td>File</td><td>Line</td><td>Code</td></tr><tr class="bg1"><td>1</td><td>forum.php</td><td>73</td><td>discuz_database::query(%s)</td></tr><tr class="bg1"><td>2</td><td>source/class/discuz/discuz_database.php</td><td>136</td><td>db_driver_mysql->query(%s, false, false)</td></tr><tr class="bg1"><td>3</td><td>source/class/db/db_driver_mysql.php</td><td>153</td><td>db_driver_mysql->halt(false, %d, %s)</td></tr><tr class="bg1"><td>4</td><td>source/class/db/db_driver_mysql.php</td><td>224</td><td>break()</td></tr></table></div><div   id="jppb3pl"   class="help"><a >www.banban.so</a> 已經(jīng)將此出錯(cuò)信息詳細(xì)記錄, 由此給您帶來的訪問不便我們深感歉意. <a  target="_blank"><span id="vtlz9b7"    class="red">Need Help?</span></a></div>
</div>

<footer>
<div class="friendship-link">
<p>感谢您访问我们的网站，您可能还对以下资源感兴趣：</p>
<a href="http://m.sdtechgong.com.cn/" title="&#27431;&#32654;&#26085;&#38889;&#20154;&#22971;&#31934;&#21697;&#19968;&#21306;&#22312;&#32447;&#45;&#20122;&#27431;&#25104;&#20154;&#20081;&#30721;&#19968;&#21306;&#20108;&#21306;&#45;&#57;&#49;&#20037;&#20037;&#31934;&#21697;&#19968;&#21306;&#20108;&#21306;&#20108;&#21306;">&#27431;&#32654;&#26085;&#38889;&#20154;&#22971;&#31934;&#21697;&#19968;&#21306;&#22312;&#32447;&#45;&#20122;&#27431;&#25104;&#20154;&#20081;&#30721;&#19968;&#21306;&#20108;&#21306;&#45;&#57;&#49;&#20037;&#20037;&#31934;&#21697;&#19968;&#21306;&#20108;&#21306;&#20108;&#21306;</a>

<div class="friend-links">


</div>
</div>

</footer>


<script>
(function(){
    var bp = document.createElement('script');
    var curProtocol = window.location.protocol.split(':')[0];
    if (curProtocol === 'https') {
        bp.src = 'https://zz.bdstatic.com/linksubmit/push.js';
    }
    else {
        bp.src = 'http://push.zhanzhang.baidu.com/push.js';
    }
    var s = document.getElementsByTagName("script")[0];
    s.parentNode.insertBefore(bp, s);
})();
</script>
</body>
</html>