登录
8 z3 B& d" i$ \<a href="member.php?mod=logging&action=login" title="登录">登录</a>
& q; i5 A# k3 u) j- Y2 g* w1 E q4 I1 s2 O: }" t* k" D+ z% w
注册
5 ~6 w7 H( I) L6 j$ I<a href="member.php?mod=register" title="立即注册">立即注册</a>
: C( ] b) R2 }# l- r& U
# x; |1 ?; y3 [* y! q) f& H
忘记密码
1 v; @1 q7 i2 P) B' P2 \9 ^4 f+ q<a href="javascript:;" title="找回密码">找回密码</a>
4 y2 P& y- [5 f/ [/ ]) S
8 f5 ^+ ~9 n; z' w1 g) v购买邀请码
; x6 f8 d9 u& y9 ~ m
misc.php?mod=buyinvitecode
. t/ W3 c" E8 B" U2 C
0 y# y# g% f: ~
JS跳转
9 o& _' r* e3 Q1 W+ p6 \/ ronclick="window.location.href='home.php?mod=mobile&do=friend';"
! W, q8 ^- a! R3 V
7 j' G: S) W% A' f; cJS更换class的名称
9 r9 L5 W4 Z( n6 H4 W5 T. {: r0 H
document.getElementById('idname').className='a';
) u2 c" @, O- p: q' R# z r
document.getElementById('idname').style.display='block';
* v5 q* _, f' R% g5 I+ {# a) B; t
document.getElementById("idname").style.marginTop="30px";
. w' {: x, Q# O5 R
, y7 e) A% x8 s, B批量替换超链接:
/ C- @7 m; ?5 @" a u2 b& \
href="[^"]*"
. m, {% Q: A+ J
- u1 b9 H X& S. z+ Z) b2 Q p过滤DZ代码:
/ t7 p" W! T( |, k% K5 X- o9 |- a
preg_replace ("/\[[a-z][^\]]*\]|\[\/[a-z]+\]/i",'',preg_replace("/\[attach\]\d+\[\/attach\]/i",'',$message));
/ P r! _5 \4 |" t. D6 {$ ]3 b/ D" M
调用单个数据
& _3 Z P( K, M* z' K
$a = DB::result(DB::query("SELECT qi FROM ".DB::table('abc')." WHERE id = '1'"));
2 I2 c' d4 X. d' t' k
' @2 p7 E7 V9 j& ` @) Z调用统计数据
/ d# f; Q( S& Z9 Q# S# y6 i# W$a = DB::result(DB::query("SELECT count(*) FROM ".DB::table('abc')." WHERE id = '1'"));
6 S a, l' v4 S. l8 t5 k5 e0 O
# ?3 |8 `" P! t! a/ D
单数据表调用
0 o( R9 n; y2 O6 V+ M$perpage = 20;
9 [5 t' ^5 ^4 O1 X: O4 ~9 o$curpage = empty ( $_GET['page'] ) ? 1 : intval ( $_GET['page'] );
Q2 [3 @* k" x" e! l1 D$start = ($curpage-1)*$perpage;
0 N1 X, H+ y& p( B3 s
$askcount = DB::result(DB::query("SELECT COUNT(*) FROM ".DB::table('forum_thread')." WHERE fid = '2' AND authorid > 1"));
! {6 o2 A! e% X7 S! j- j4 N
//$asklist
& i6 z8 F0 D7 N1 f. g) {) J5 X$asklist = array();
" G9 A" l5 }2 y6 Eif ($askcount) {
+ P! [) S' x8 h9 ?9 A# }# z
$query = DB::query("SELECT * FROM ".DB::table('forum_thread')." WHERE fid = '2' AND displayorder > -1 ORDER BY tid ASC LIMIT $start,$perpage");
0 {+ }/ h6 W; u7 V+ \4 h) w
while ($value = DB::fetch($query)) {
5 M! ?! J6 m& a; \ $asklist[] = $value;
& r+ f- T. I. f: t; \3 H }
' }, I. B% c! c/ d" p}
: F e3 M* k$ P! g
$multi = multi($askcount, $perpage, $curpage, "这里填写跳转地址");
- S% Y, M, C+ Y& Y; p! s1 R s6 J# j5 {
, [# J! h3 `8 V$ r3 t* M& B
- e F" S6 X( B4 d. k* u多数据表调用
2 C( C& A" L5 _7 Y" h* r$perpage = 40;
! R, q! w' R: D) g8 F! d. v5 D$curpage = empty ( $_GET['page'] ) ? 1 : intval ( $_GET['page'] );
+ d/ v( K; G# S$start = ($curpage-1)*$perpage;
L( J& M. B! C# {9 t$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 != ''"));
- K! u0 s( B. W4 S8 S" N
//$alist
4 _9 d! I- C O6 O
$alist = array();
" R8 f u) ?( ]
if ($acount) {
5 A5 U9 ^! k9 ] b& `+ ^) G" Z5 o
$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");
/ W: ]& ?. M* V
while ($value = DB::fetch($query)) {
7 w8 |. [+ G% F% R $alist[] = $value;
5 G7 p A3 s$ f0 H- q& g }
! z& T' I* r0 A! R! }- N5 P
}
& q1 x! p$ O9 X0 H" i4 W& A( N1 d- E/ G$multi = multi($acount, $perpage, $curpage, "这里填写跳转地址");
7 {2 a' @4 D, O+ N
0 L3 K7 G5 G6 Q* {, N4 ]
: i$ v; V% L1 h1 x" @" K \; S4 n2 D; u; |( D( {" K
前台数据显示
0 B; r& R7 G7 w2 a, A. S# G<!--{loop $alist $key $value}-->
! x s7 a9 ]1 s% [
<!--{eval $tupianfm = DB::result(DB::query("SELECT attachment FROM ".DB::table('forum_threadimage')." WHERE tid = '$value[tid]'"));}-->
, v L- P" I" W/ _+ m
<img src="$tupianfm"><br>$value[authorid]
) i; G/ R* |6 v1 ?* l% G
<!--{/loop}-->
: H1 b) L% @: t8 g; \1 i* g9 [4 b/ e7 T
1 b4 t2 ~/ a( {( T/ l3 z9 {3 o' \! \
取数据表中符合条件的第一条数据
1 J: S# \6 R5 N/ F, m( x$app=array();
; }8 `* U8 S* h% z/ C$app=DB::fetch_first("select * from ".DB::table('abc')." where id='{$id}'");
: i. _0 S! X3 s& A" X
) m; P0 C9 d( Z t: @+ A
7 Q+ e# l! X/ _( ?) J8 k% n
& w- Q* V% p% d: ^/ ?人性化时间戳
0 H. W2 Y9 N4 A# ]- d& w* {1 K2 i<!--{echo dgmdate(这里填写时间参数, 'u', '9999', getglobal('setting/dateformat'))}-->
" f" Q( R1 ?% {" ~9 P
<!--{echo date("Y-m/d H:i:s",这里填写时间参数)}-->
- ^* w. n! m! u B) O
. v [1 Y* ]4 s3 e% f5 x6 J* w
1 y, v% o* k! o( `5 d( }/ m. F截取字符字数
3 ]# y6 Y0 n8 {& k! w" } R/ L<!--{echo cutstr(这里填写参数,40)}-->
^% ^/ q, c T( l* w2 I
7 i, c7 n0 b3 l$ J( B/ y) t4 k7 G' T2 e( a# Q# C
过滤DISCUZ代码
4 {3 y7 U& e* Dpreg_replace ("/\[[a-z][^\]]*\]|\[\/[a-z]+\]/i",'',preg_replace("/\[attach\]\d+\[\/attach\]/i",'',$message));
. a1 d5 n# E1 |1 f7 m% E( ~
7 ^! v5 p5 k0 Q$ B7 h
/ h& G5 f( Z- ]9 h: N, l$ ]$ l写入数据库
6 m8 h$ N8 n( G+ y$ Xif(submitcheck('tijiao')) {
5 n0 s7 E7 H- e; x
$setarr = array(
D$ u9 }3 Q/ }& _* t% q3 T% v- w
'tid' => $_GET['topicid'],
3 f1 ]" G8 H4 b: U* t. r 'name' => $_POST['name'],
, z6 p* u4 P( V5 r h 'position' => $_GET['position'],
- z8 L _/ D' a4 {& o. Z 'dateline' => $_G['timestamp'],
% J. N2 G% @* {, }) }) C' G8 Z );
3 E2 h4 w1 @- r. U& p) i6 p+ N" g DB::insert('abc', $setarr, 1);
6 x k4 h; x! E
$query = DB::query("UPDATE ".DB::table('abc')." SET stickreply='1' WHERE tid='$tid'");
5 X2 T: U$ g: a2 w/ a# b: Z4 J
$query = DB::query("DELETE FROM ".DB::table('abc')." WHERE pid='$pid'");
$ z6 |, {% N- } showmessage('成功的提示信息', "跳转地址");
( e8 f0 H( y2 ]; h; |. _+ Z; `}
) W/ j( t/ G/ l( U: e) c2 {( v4 H
) i/ l, \6 G; g
, X3 n" \+ p- v. [ t
$ E# _5 v: _% |7 Y) A; b2 [表单提交:
8 i" J$ |5 ]1 K X<form action="do.php" method="post" autocomplete="off">
4 E# _5 u Q [
<input type="hidden" value="{FORMHASH}" name="formhash" />
0 X% W: R9 W& B# x9 m
最低奖金:<input name="qi" type="text" value="" />
& R# T! k. ]9 O5 V
最高奖金:<input name="end" type="text" value="" />
! Y% i2 g) |% |3 {9 @& N8 O <button value="true" name="tijiao" type="submit">提交设置</button>
. x. F( S0 r9 a ? <input type="hidden" name="tijiao" value="true" />
3 T) y6 A: T0 @% U# R. q6 I% T</form>
6 C! ~2 h7 X: F& v! o. ?
/ y5 d5 O$ d" z$ G, t! m
+ {& m6 y: o0 D D9 E: d2 H/ H1 {9 V
& D! m5 c4 U* u! \8 z7 P
以下两个时间格式是对等关系
4 a% p9 [& x: r
date("Ymd",time()); 20150212
$ S' d$ B+ H- Z4 f: f/ ]& P0 u
FROM_UNIXTIME(dateline, '%Y%m%d')
! A( I: v6 ~ G/ N, p# w' _: T' o7 ~ Z% `) W
前者用于PHP,后者用于数据库调用的字段的格式化
, L7 m3 f/ W0 p
, ?; ?5 t; f m9 J1 [调用图片附件
* a! U$ S; G- A4 W. L7 ^3 C0 D<!--{eval $biaoid = substr($value[tid], -1); $cover = DB::result(DB::query("SELECT attachment FROM ".DB::table('forum_attachment_'.$biaoid.'')." WHERE tid = '$value[tid]'"));}-->
& W4 U, F# G6 n( W8 u4 q6 q a. c/ T1 I" ~0 X! d2 }
8 V* n3 M$ `/ I
数据库循环嵌套调用
2 Z8 b8 \) \5 A! V7 d<!--{eval $slides = DB::fetch_all("SELECT * FROM ".DB::table('a')." WHERE `uid`= $_G[uid] ORDER BY `id` DESC");}-->
; K* a1 ?% x7 ?4 k( c<!--{loop $slides $slide}-->
7 B5 S" l& q @/ w, n5 s
$slide[name]
& Z- m4 w! a# X& ]
<!--{/loop}-->
: b9 ?; O8 O& n0 r- ?2 E5 K* {
+ T; a/ t# P* }& e
/ N6 \- h- ?& u* o
ucenter无法登录:
8 \2 W6 K& A% C8 U: Y. B5 S; H/ S
打开uc_server/model/admin.php
% p) ^2 ^) T5 @" t" m5 ^9 z找到第22行的
( \$ v6 z+ _& C6 o3 p/ Y* |$this->cookie_status = 0;
q9 I+ p; ^, ^% D8 L5 j9 b
- p/ l- w a) s1 m J R& e" x# }+ X. e+ I% V$ f
改成
: ^0 P) L/ i) R$this->cookie_status = isset($_COOKIE['sid']) ? 1 : 0;
7 y7 y& B: ^+ }3 ~* s, j, v7 B& i" X Q! p
0 M0 j! h. `8 r) v: A
+ L( l& q9 A! g+ T2 A
无刷新切换li标签并且同时加载框架页面:
; ?& M# V# v& v' h, c, r
<script type="text/javascript">
. g5 A8 c5 |3 c ]var jq = jQuery.noConflict();
4 m* s8 N" p- T- V- N# y" K" x- s
jq(function(){
+ S2 {$ [- d k9 [5 C5 B
jq("#changemenu>li").mouseover(function(){
! H: ^* Y3 x) `" B
jq("#changemenu>li").each(function(i){
0 w. Q4 ? u) P- Q0 a3 L3 c
jq(this).removeClass("current");
q# @& E' D2 Y @; _5 f
});
/ q+ \; J( K5 q- {7 f
jq(this).addClass("current");
* P; R" h( q# udocument.getElementById("changenr").innerHTML='<iframe src="do.php?id='+jq(this).attr('dataid')+'" height="350" width="1070" frameborder="0" scrolling="no"></iframe>';
, Q& V+ u1 Z% H: F& s- n9 t1 T$ D6 ^, t
}).mouseout(function(){
* ^2 S! f0 b F' v
jq(this).addClass("current");
- S/ C9 u7 e7 |6 |5 ~1 \6 q! |$ V});
r8 R" d$ I+ q. l+ S0 i- P});
7 O! ^& e: X* g! x M1 m</script>
8 V4 u" g% h: ~# m# {
<ul id="changemenu">
2 j( n- _# x4 z <li class="current" dataid="1"></li>
7 C' M8 u' W- F1 C0 L <li dataid="2"></li>
2 e) T2 S0 f2 ]/ K+ [$ h' \. e</ul>
4 L4 |% f: T5 K. `! i/ N+ B<div id="changenr"></div>
+ f0 A5 b# c2 X7 H( n0 x O- [5 p6 t7 W
* s1 F0 m8 j; i Q8 ?; V
$ g3 u: \: Z! j* J2 h2 H& Z快速发帖
3 F- Y4 B0 h9 n5 @<a href="forum.php?mod=misc&action=nav">发布新话题</a>
% o; F2 R, H% o# L
5 P2 x& U8 y7 b: n' w; p
: n3 ^! W# |0 M2 B! L7 L4 D, u% o4 `; r3 X. z
DISCUZ JSON数据解析获取
/ S/ M9 u! S3 Z8 g3 a Y+ e+ ^6 k6 }$str = 'a:2:{s:8:"sitename";s:8:"源码哥";s:3:"pic";s:12:"ymg6.jpg";}';
" J' ` `# k' x, c
$newstr = str_replace("\","",$str);
- @2 z) f- u; J6 ?2 Y8 {6 C. y
$data = unserialize($newstr);
- d8 t- W. g3 s' L+ U+ g! Z2 l4 wecho $data[sitename];//输出结果为源码哥
9 w6 J! l9 j$ K6 @2 R" u
/ e/ t9 C+ A5 J6 K: s7 R
9 X( ?% o% I4 u4 |6 p+ ]
~; h' l0 ?" D9 M- w6 Z$ \DISCUZ云平台站点同步提示DNS错误解决方法:打开source\plugin\manyou\Service\Client\Restful.php,找到代码:
. p% }! `4 a' p8 d
$result = $this->_fsockopen($url, 0, $data, '', false, $ip, 5);
: } |8 Y: V- o. r0 G1 _7 [" j
8 o6 I7 w2 T' \4 z x
3 Y, p! }9 E, k Q' d) |4 G修改为:
3 j5 p! |$ a: Y, e. e! _! |$result = $this->_fsockopen($url, 0, $data, '', false, $ip, 30);
8 Q: }! s4 V$ c! E2 G5 q" H) G% R5 Q
; @2 H1 r# e! ]/ K6 |/ q! F, {$ }
1 F+ b' A. D7 E
8 [( b( e! \, t# s7 d: iLI标签列表自适应宽度JS实现代码(去除每行最后一个li标签的右边距):
) N7 ~& ^" i. W0 E" z+ x
<script type="text/javascript" src="http://www.banban.so/new/bang/uploads/146383669567393.js"></script>
. D ]/ M; c. _7 n, t
<style>ul,li{margin:0; padding:0; list-style:none;}.list{width:100%; margin:0 auto;}.list li{width:32%; float:left; margin-right:2%; background:#0092B9; text-align:center; color:#fff; height:300px; line-height:300px; margin-bottom:10px;}</style>
" A4 K; s4 C5 D7 G) g; L; o0 g6 U<div class="list">
8 u4 a) }0 d. d! p <ul>
h' z$ _( E0 a/ y$ l) b <li>源码哥</li>
$ t7 H0 c( j4 x) u
<li>源码哥</li>
) c! Z% S$ Q3 V% i <li>源码哥</li>
! c4 ^) {) T( c. Z; b <li>源码哥</li>
1 ?( g) t, w& Q <li>源码哥</li>
- |& M" M/ ?2 ]6 Z8 k <li>源码哥</li>
: M/ f- }4 ?1 ]* K R/ [' ]6 Q </ul>
3 D: G. V2 y V9 n1 u" N</div>
9 T) N' x! P. [ m7 o3 k, a1 V" Q
<script type="text/javascript">
- G) d# J3 i. ?& |; h
$('.list li:nth-child(3n)').css('marginRight', '0');
* C9 [' i' D; a/ e5 d; H! O
</script>
; Q* K1 n( o% @ t2 d5 m: e2 e2 S6 A3 G% ]
5 ~* F" Q* j9 g
' a' Q# k$ ~6 L! R常用词汇
0 U5 H: N$ L/ J0 w' d# I
select 选择
+ G+ E0 N& ] f1 G" Ecount 总数
( L2 x; D3 ^ Y! D D, Ctable 表
4 B) e- n! z% H3 O- ^+ K( O2 B I$ M
where 条件
' h/ _" c* n# eresult 结果
* k; S; }& J( e$ b2 U9 k$ K* Q
perpage 每页
' d" k/ Q7 I4 D1 n6 C5 Ccurpage 当前页
5 A/ Q% p r |. M3 \4 ?
update 更新
/ H4 u7 \& A4 \8 q* t
delete 删除
* Z$ e) d9 q0 S4 v5 A
insert 写入
6 j$ B/ d- S3 D4 D# H* e7 ddateline 日期
$ N2 ^2 L5 P" m4 |; C/ H: h4 [/ Z1 `time 时间
" W& w! ~' W; n( Z: pecho 输出 <?php echo '123'; ?>
6 u( J. ? c$ y2 b B0 F
multi 分页函数
1 C5 E, V) j4 ~& g9 L# m' H2 D' g
if 如果
$ l E9 v- w+ b0 y% n5 g
else 否则
; A Z; V+ V% Jelseif
' n% H* s6 f$ Ystart 起始
& E& Y6 M t" [limit 限制 limit 10
3 Y8 Y! F6 j/ |3 g7 TDESC 倒序
m: y8 Z4 f0 ZASC 正序
- n* A: w9 w- x! H% C9 W4 E/ ^- j. ^
# B0 R! N$ X' @0 W# B
, a. [. @. T: H1 F3 ^1 {
$ V+ }$ D! a/ d) W: S) F6 s( _4 n活动帖发布页面核心处理文件:
% P0 M( {+ o5 O% S4 Z
source\class\extend\extend_thread_activity.php
4 r6 ]) U8 _# b8 W; Q! t n
6 g/ c$ E ]$ j! l, L) h6 F
分类信息解析文件
0 |2 m% e0 [7 i& t" B* `3 Qsource\function\function_threadsort.php
5 u+ d( \; P! }9 h
Discuz模版运行php代码
4 G' B" {- R: {, L. z" n1 F+ i<!--{eval echo'源码哥';}-->
% W( f7 ^$ y2 }$ x2 A& t% p: _3 q或
* r* D/ V. K) [ l1 w- ?+ R<!--{eval}-->
* f) ?/ } k: Z8 |" H$ k- [
echo'源码哥';
* j, E" R1 H& j9 t
<!--{/eval}-->
9 v/ G# P# n& ?: Y
标签获得焦点后触发js
; ]$ O3 ^1 |( y6 h" x% j
onfocus="ymgcom()"
5 w) Z# ]6 `% K& i( m$ i e8 R. h5 l. B
8 u% e" M- p4 Y. _, G2 y
标签失去焦点后触发js
3 |% k# A1 j; |3 x
" @0 F* G( g8 }0 monblur="ymgcom();"
# P. e3 O; E, h/ k7 s
" J7 q7 y# ?- o! h- H. D6 l- b# h9 A9 P5 N2 j
密码输出1*****6
+ i8 R- l! y9 Y. q//原密码为$_GET['password']
( A9 F* w+ `, K" T# D5 [* R$password = preg_replace("/^(.{".round(strlen($_GET['password']) / 4)."})(.+?)(.{".round(strlen($_GET['password']) / 6)."})$/s", "\\1***\\3", $_GET['password']);
" s; o: h2 j! ^" N) P4 Pecho $password;
% [& p R* J# M/ s! O3 N