登录
) a; q" }+ {8 F2 N# b1 t7 h H0 f( i<a href="member.php?mod=logging&action=login" title="登录">登录</a>
, u) _5 I5 @/ S& R- J* |4 r/ F
& I0 z( F8 c: h& N4 _" o( W$ ^注册
, }, D1 f) X% L/ j4 b6 x
<a href="member.php?mod=register" title="立即注册">立即注册</a>
. |, t6 I- [# h( x) f8 ]
6 T( j0 C a! s% P9 k忘记密码
- L. W0 p5 M! G9 ~; w& m. Q0 O1 |
<a href="javascript:;" title="找回密码">找回密码</a>
/ v# Z% y6 n" R) D" n. j& y
" r3 h3 u8 i1 x
购买邀请码
3 f$ t0 G7 _. ^+ M) I2 F3 Z/ v
misc.php?mod=buyinvitecode
. n" Q9 Q" h* J
. K6 G( J2 i' R4 ?JS跳转
# b* C! s/ J/ X0 n% uonclick="window.location.href='home.php?mod=mobile&do=friend';"
}7 [% Z" v, Q1 V* Q% [; {' `3 |4 [* e5 g# z. ~2 a0 f9 J& U3 U
JS更换class的名称
+ O& P& ^/ C7 s7 c8 q3 K8 a8 s
document.getElementById('idname').className='a';
# G u4 A! R; d. T% ^: z
document.getElementById('idname').style.display='block';
Y: |, [4 ?* y! @1 \3 Fdocument.getElementById("idname").style.marginTop="30px";
1 w6 f8 E/ k5 {; k1 `, M6 @
: T& D( ~6 q7 w批量替换超链接:
) O: O& ~: C% B. @5 ^9 _
href="[^"]*"
# u6 H6 `- L L3 Y2 g/ y8 d( z3 H* ~) i- y
过滤DZ代码:
2 {# x5 v! N/ L5 f& T& t. K9 ?4 V* Q7 {preg_replace ("/\[[a-z][^\]]*\]|\[\/[a-z]+\]/i",'',preg_replace("/\[attach\]\d+\[\/attach\]/i",'',$message));
, V/ ?8 |8 w5 Y8 e1 k9 {
& M( H ?( y- B4 _! y5 z, i调用单个数据
( I% ]: @7 ?# i( C, V( w# A$a = DB::result(DB::query("SELECT qi FROM ".DB::table('abc')." WHERE id = '1'"));
3 _: c/ t% E* a( z
% H' ?8 y* K g
调用统计数据
% m" L) w$ h7 t5 L# U' M5 F, f c$a = DB::result(DB::query("SELECT count(*) FROM ".DB::table('abc')." WHERE id = '1'"));
c6 ]+ U7 X) [
l' b! _* K& o3 ?9 U
单数据表调用
8 r! x; c; p: I$perpage = 20;
' v2 T; X$ x5 I6 W' E: g
$curpage = empty ( $_GET['page'] ) ? 1 : intval ( $_GET['page'] );
, h/ P* u. c, r) h/ o/ K% s
$start = ($curpage-1)*$perpage;
; {3 O& n" s: y* \! `- i& Y$askcount = DB::result(DB::query("SELECT COUNT(*) FROM ".DB::table('forum_thread')." WHERE fid = '2' AND authorid > 1"));
% @" ]( H! z: ]# q' L( O4 X1 v( Y//$asklist
' t2 i m, d' [: D" g/ b& y% Y$asklist = array();
0 N7 j, `8 [/ ?! I- G
if ($askcount) {
+ i7 o: x( J/ P $query = DB::query("SELECT * FROM ".DB::table('forum_thread')." WHERE fid = '2' AND displayorder > -1 ORDER BY tid ASC LIMIT $start,$perpage");
4 V2 S2 R& W- O) ?* e while ($value = DB::fetch($query)) {
W; O3 C m+ |' p) _
$asklist[] = $value;
; C9 I7 u* T% u9 w5 o
}
. {' A. o( E P# n% Q
}
0 p1 [: y) D4 H! ^$ o; v: O$multi = multi($askcount, $perpage, $curpage, "这里填写跳转地址");
# q: ^9 P4 g& N- c4 l ` N) X9 H
# T: t( `6 w$ ~, j' B
) I* _: N, e6 E
1 x% ~) r* T; M6 C: L多数据表调用
* o* C6 i+ v1 V0 L: {2 C$perpage = 40;
^2 Q9 o2 H E# X$curpage = empty ( $_GET['page'] ) ? 1 : intval ( $_GET['page'] );
. C+ W& h, s& f& ]5 [
$start = ($curpage-1)*$perpage;
! e0 q# O% ^6 m! A) n
$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 != ''"));
4 M% B! |+ A' ?//$alist
& q; G. N6 p+ n% C
$alist = array();
+ o1 R' d3 V! C8 q- i
if ($acount) {
) G4 g) B( o2 t# W $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");
. Q$ D1 W: Z3 i0 Y4 r
while ($value = DB::fetch($query)) {
4 H6 ~8 p( w% O V) J( D
$alist[] = $value;
. h2 g/ ]( f9 r8 O4 x$ A0 Y. T% C }
1 e5 S! R @/ I8 Q. j' R- D& V
}
' N+ O: d+ I1 x
$multi = multi($acount, $perpage, $curpage, "这里填写跳转地址");
o9 F# H4 P# o- b( b" C) U' r& G8 h1 |9 Q m& B
2 T: A! C9 f# A9 r* h3 a' v' t5 O0 {/ e2 e; Q0 G& z
前台数据显示
) E8 U3 j2 O& M. D& O; A<!--{loop $alist $key $value}-->
/ a# k G, _5 H8 j<!--{eval $tupianfm = DB::result(DB::query("SELECT attachment FROM ".DB::table('forum_threadimage')." WHERE tid = '$value[tid]'"));}-->
$ U( q2 E7 L" [! @4 H/ y0 q& Y) Z$ y
<img src="$tupianfm"><br>$value[authorid]
. M/ @) M7 |: j4 Y1 F) L% i<!--{/loop}-->
/ Z( w1 O* A) _7 U9 t
- v& N0 ^4 |, U0 j/ ?) f# Y
/ m1 C" K9 U/ q- `- }
取数据表中符合条件的第一条数据
5 i5 l/ ?* S+ t; _) D" V! h7 i; W$app=array();
3 W2 x' @2 @3 E$app=DB::fetch_first("select * from ".DB::table('abc')." where id='{$id}'");
7 _" n+ K% ~$ P" t
+ L+ q: l! h N$ s% q: l
0 j: t! a2 X) `7 Y
T' v0 S, x6 _: ^ e人性化时间戳
& B* J2 w' G3 M2 N3 s, e8 `<!--{echo dgmdate(这里填写时间参数, 'u', '9999', getglobal('setting/dateformat'))}-->
) a4 R( G8 v* S: N1 o# n4 l<!--{echo date("Y-m/d H:i:s",这里填写时间参数)}-->
* ?3 A/ e$ M. ?7 f- H
* B2 @9 h" W$ r; E
' l1 L0 s( P8 Q; A+ n截取字符字数
; v% C$ p% H4 F K& i<!--{echo cutstr(这里填写参数,40)}-->
# e8 m1 J! l6 Y) ]# Z$ i
+ H, K5 X6 i) A( H* u) P! @. z2 |* M. W4 _5 }" ?" t# D/ _3 D5 D
过滤DISCUZ代码
0 r9 s7 b+ \) P0 C8 n, ^) P5 L: K
preg_replace ("/\[[a-z][^\]]*\]|\[\/[a-z]+\]/i",'',preg_replace("/\[attach\]\d+\[\/attach\]/i",'',$message));
: j; n8 q) a9 n/ I! P8 x* ]! n- c. `: p& I
& R1 W' _0 | X1 n$ P; Q写入数据库
; \+ K2 e: T9 X v) Mif(submitcheck('tijiao')) {
1 r* U9 n+ w. S! ^$ K' p $setarr = array(
4 t" Q6 U1 Y, G- c7 S4 A 'tid' => $_GET['topicid'],
+ D7 }4 z+ Q: a0 H" | 'name' => $_POST['name'],
9 e0 m* t& Y: i' X1 S- } 'position' => $_GET['position'],
5 j- [ v6 `; d/ ? q 'dateline' => $_G['timestamp'],
1 M& f2 m, J, x4 @! Z5 o" b0 n
);
6 }. K3 r* w! L- [/ b
DB::insert('abc', $setarr, 1);
; {& y, T5 n3 ]! C5 J& L
$query = DB::query("UPDATE ".DB::table('abc')." SET stickreply='1' WHERE tid='$tid'");
7 n2 p' p: W( t; w $query = DB::query("DELETE FROM ".DB::table('abc')." WHERE pid='$pid'");
4 i! h) P2 I, g6 |' S3 X
showmessage('成功的提示信息', "跳转地址");
& H. v: p: V* u3 U
}
# u) l( v# h/ ?" e1 {, G
s' T" ^4 |, |- Z. K- J# F8 D: V& s: h* x# T: V
4 n) y) c' {' P4 R- p6 _表单提交:
) f% V, J, a7 \
<form action="do.php" method="post" autocomplete="off">
, c( I) v9 s- z( f1 @4 W7 x
<input type="hidden" value="{FORMHASH}" name="formhash" />
( h% K( c* _( N5 C; ` d 最低奖金:<input name="qi" type="text" value="" />
, i |; J r& q8 ^ 最高奖金:<input name="end" type="text" value="" />
: Q% k7 C7 v' s& A4 _ <button value="true" name="tijiao" type="submit">提交设置</button>
: `8 v- |5 `( u3 c0 u& y
<input type="hidden" name="tijiao" value="true" />
' X& J- M$ Y3 X0 r2 \/ ]
</form>
- G+ H% e& }5 J, p5 z" u
5 b7 a2 T6 m& D
+ I& W$ Y: ]: I; }4 Z _
% ] @ \8 [: H( ]& x
以下两个时间格式是对等关系
1 B( A! o- R% Ddate("Ymd",time()); 20150212
5 n1 H" i6 O) n7 V
FROM_UNIXTIME(dateline, '%Y%m%d')
- h y3 ], h& x0 T% l- I
7 ~1 c1 b/ i( \ \) }7 j9 U9 a
前者用于PHP,后者用于数据库调用的字段的格式化
0 Q0 W! H0 ]7 Y% u' W; G2 S
2 c& W% Z2 b: o( d, h. ]. l4 D' l调用图片附件
9 w# T% X9 m, x, r<!--{eval $biaoid = substr($value[tid], -1); $cover = DB::result(DB::query("SELECT attachment FROM ".DB::table('forum_attachment_'.$biaoid.'')." WHERE tid = '$value[tid]'"));}-->
0 ?4 ?- Y7 D9 L9 z& E( `
% R) m- B- M. c% b0 N1 U/ r# q9 A3 g# w5 N5 F$ b G- u4 |
数据库循环嵌套调用
& i, t3 q5 l* `
<!--{eval $slides = DB::fetch_all("SELECT * FROM ".DB::table('a')." WHERE `uid`= $_G[uid] ORDER BY `id` DESC");}-->
% H0 |' Y, d6 J& b u
<!--{loop $slides $slide}-->
8 @, u; k- d7 ~2 K A* e
$slide[name]
0 P5 B4 }% x% b2 R5 j- z$ m
<!--{/loop}-->
9 W. ]2 z- C. _" q p- L: \/ e7 Q- ^0 a4 t- n1 O
8 J5 a! a: p. H7 iucenter无法登录:
6 G! N1 I6 B5 o" C* }" P打开uc_server/model/admin.php
% [; \( U; E3 g2 L找到第22行的
- ^) p3 F3 N0 e' {7 g0 Z$this->cookie_status = 0;
$ i4 p$ P, f3 m
: E7 V* i/ E# }( j+ a6 b- t- u4 D" @$ ~) |8 e* j2 ?
改成
! F4 h4 m! C6 `/ V
$this->cookie_status = isset($_COOKIE['sid']) ? 1 : 0;
$ m4 d0 _* ~1 {& l4 Z/ G8 s5 d
6 f$ v! h X3 z9 Q# ^9 W w0 S) G, [; Q# `! L6 V M
2 z: G) s0 ?! E4 G
无刷新切换li标签并且同时加载框架页面:
}+ o2 S* b7 w8 }% M3 H! K$ K<script type="text/javascript">
" H! X0 q4 @% X: H- H2 E9 h
var jq = jQuery.noConflict();
8 F0 ]1 I" C; K
jq(function(){
, `! N6 C, W! l4 x$ Vjq("#changemenu>li").mouseover(function(){
A, t6 p- w, g1 M8 P9 [' q4 b
jq("#changemenu>li").each(function(i){
6 |% b7 ]+ s, O0 g" Fjq(this).removeClass("current");
y& Y4 l: h2 [});
3 h7 |2 u# V5 n
jq(this).addClass("current");
0 [4 M5 G' W0 e& F+ p9 y
document.getElementById("changenr").innerHTML='<iframe src="do.php?id='+jq(this).attr('dataid')+'" height="350" width="1070" frameborder="0" scrolling="no"></iframe>';
$ s) @" V6 a: ?7 L" C$ ~8 [}).mouseout(function(){
+ b, C0 z5 T" s1 l( W* s; Xjq(this).addClass("current");
) @) \1 g) E% A+ h7 U7 Z) K});
4 A( f f8 K* m* S m
});
5 x) D7 ^" d4 \ z</script>
: y3 o, w+ K& N; h# q2 p$ B<ul id="changemenu">
+ t! z% K2 i N9 s" N: r, F <li class="current" dataid="1"></li>
# f, c9 ~2 D) c. T& b! Q <li dataid="2"></li>
& O# s" K) \' J. _: @9 T</ul>
( ^0 j+ G9 n( B# F$ T: j<div id="changenr"></div>
5 C. M2 U6 a# e- f$ n, q1 j+ V5 n) L* F2 C7 j
/ c+ [" U' M" ^2 L! t$ _% \ S c, E. J8 ~8 g
快速发帖
/ h3 |, v" G: ?9 y, J<a href="forum.php?mod=misc&action=nav">发布新话题</a>
2 b+ |0 p' t5 `: X% P# i# k
; n q) n3 A* h
4 f# v* L) m$ Q1 a7 X
, x7 _2 }$ C w% r# d' ZDISCUZ JSON数据解析获取
3 U( b9 H, O. ~' ?7 D9 M# c- O3 P7 g
$str = 'a:2:{s:8:"sitename";s:8:"源码哥";s:3:"pic";s:12:"ymg6.jpg";}';
: {* d7 J# o- ~ K, L$ |
$newstr = str_replace("\","",$str);
. V5 W; o' P) f4 F5 c3 e, b$data = unserialize($newstr);
' }4 o% o( ]: Y) C' L8 S
echo $data[sitename];//输出结果为源码哥
7 m4 R# m% G: c2 K' u% K
* n5 F0 x+ X( e* d/ y/ m1 A/ D) Y9 M7 o/ d3 p
6 t n0 C- N6 K# n
DISCUZ云平台站点同步提示DNS错误解决方法:打开source\plugin\manyou\Service\Client\Restful.php,找到代码:
6 X& N: S& U+ k# s" L( }$ c6 z$result = $this->_fsockopen($url, 0, $data, '', false, $ip, 5);
9 n4 y. J2 ]- t6 p! o9 v" n7 q, h( r1 m/ J2 ?& F4 N; A
4 N9 \$ {, `( l$ s' D. e5 T
修改为:
8 o' y7 C9 P* H2 D$result = $this->_fsockopen($url, 0, $data, '', false, $ip, 30);
+ D/ z- R; `9 R" M5 O3 l( V$ D/ j! Y0 Z# U W/ u+ A$ q6 n% w
2 k7 p/ E$ x# N0 I
+ j( r5 a) N2 g: D
LI标签列表自适应宽度JS实现代码(去除每行最后一个li标签的右边距):
4 ~# d: w: j% M2 L! H0 i<script type="text/javascript" src="http://www.banban.so/new/bang/uploads/146383669567393.js"></script>
* l8 F$ E8 w! w<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>
0 M5 u8 Q* M2 S5 i2 e<div class="list">
b) G/ l7 z, q% D* U/ C6 l
<ul>
9 _- _" f- f% v, j/ |& f1 E0 p( U <li>源码哥</li>
/ q4 o% `- f @* [9 c, o <li>源码哥</li>
. B* L7 X) u o; r @3 o" w <li>源码哥</li>
* ?) B) c. a9 l8 \ R% s4 A
<li>源码哥</li>
2 b0 M D0 B, g5 l* h0 t <li>源码哥</li>
9 `- x: [7 D1 W& J) @" b, i6 b" ~
<li>源码哥</li>
& |9 G* l: K/ K# W y
</ul>
* e0 k1 H+ s, C, }# G4 s- s</div>
v9 s3 E) ~. n' q/ ^
<script type="text/javascript">
+ ~8 @% J$ p9 }; D1 b! j
$('.list li:nth-child(3n)').css('marginRight', '0');
5 H1 }+ V. } |" G7 P$ i
</script>
2 ]( n. _- l2 n
, V# S- e4 i3 U: v0 X# h- ]+ K- W) m6 W
$ [- y, g& K& f常用词汇
& R! o o# n8 T
select 选择
$ x5 i8 R: u1 R5 o9 p! a" _4 g4 H
count 总数
) x# y, _' B+ `9 U9 g4 H" K$ N' Z8 ?8 {table 表
E( ^1 s" E/ p. Q; P. n
where 条件
! C# ?) ^; U0 W# b3 H7 p
result 结果
/ ?0 F" K( N5 e* g' H" }& {3 Rperpage 每页
- K: S& P# h9 c5 u: L$ f
curpage 当前页
/ t. t, f+ Z5 Q$ v
update 更新
3 d0 A1 d+ S2 f
delete 删除
* V% Y7 v/ ^5 O2 ?4 ]: U
insert 写入
) x0 `9 _$ f0 a, \) ldateline 日期
& ~5 h) F' J$ _% l/ I5 n6 R
time 时间
9 U$ z1 P* l0 r# [: L
echo 输出 <?php echo '123'; ?>
% [% h5 Y) ^( p/ ]! B5 y/ |; xmulti 分页函数
1 k/ @* A# A# t8 N w V: z
if 如果
1 D! I, @0 s: L6 v, u W% C( Welse 否则
5 b: E0 R6 e( i* }: uelseif
7 Q1 d, R% P8 gstart 起始
) b. t& D0 s, w0 f4 g1 g
limit 限制 limit 10
* [3 B. y/ ?6 M& r
DESC 倒序
% p4 A8 C& i/ I+ I# @' _ASC 正序
9 `% Y; l; @1 E) ]: e. y8 Z) e8 |) H- j
1 t) b. J2 J; N9 F0 N s" d# c9 Q$ \
- q5 g) c0 Z! M% q" M& q5 M$ e7 O' K1 {
$ R7 M: `- r; {. P- P$ a
活动帖发布页面核心处理文件:
) I6 V: o5 L3 `- V; Y r
source\class\extend\extend_thread_activity.php
" T& u! y& s$ ~+ s8 j A6 z. k# v6 ]/ g
分类信息解析文件
, }' Z/ g4 G" G- u# I( L0 S+ Y7 Y% x
source\function\function_threadsort.php
. E6 M6 {& I# f0 F' C. Y
Discuz模版运行php代码
6 ?( C9 n0 y1 r! Z( d! a8 J7 J
<!--{eval echo'源码哥';}-->
E3 c3 }. o0 C# L4 \) ^或
4 b3 [$ i, q+ p, S2 z# A* J* a
<!--{eval}-->
$ t& }" _. v, Q; B% s: Z7 v8 l9 i8 g
echo'源码哥';
; G) K, Z6 ]+ x& p3 d* q8 A% E
<!--{/eval}-->
/ O5 w* Y7 j" |. G, U# S* i5 ~ m
标签获得焦点后触发js
F/ B3 i6 L C/ h3 p, G# ~onfocus="ymgcom()"
2 h: K6 U! H( J& w/ h
" j) c1 M- [- a# g5 @" y
$ `4 y+ G$ q! ]8 g3 l标签失去焦点后触发js
! Y* g+ D2 U4 [2 |* \& s6 ^/ L
( o4 b; ^6 P. R, ^7 p0 oonblur="ymgcom();"
! G6 _( p0 Z7 Y* \
: D( J2 D4 g$ A. P& M
+ [% e2 @4 Z0 I* }( q1 }
密码输出1*****6
$ m. ^4 w9 R9 \9 p6 v! i
//原密码为$_GET['password']
7 n+ c1 E$ r0 I9 t+ D9 m
$password = preg_replace("/^(.{".round(strlen($_GET['password']) / 4)."})(.+?)(.{".round(strlen($_GET['password']) / 6)."})$/s", "\\1***\\3", $_GET['password']);
0 |. {6 J% j2 s4 uecho $password;
% X5 U8 u! x- t( M2 a