Discuz数据库调用:DZ模板调用常用代码手册
来源:互联网 发布:火车票刷屏软件 编辑:程序博客网 时间:2024/06/12 21:17
登录
1
<a href=
"member.php?mod=logging&action=login"
onclick=
"showWindow('login', this.href);return false;"
title=
"登录"
>登录</a>
注册
1
<a href=
"member.php?mod=register"
title=
"立即注册"
>立即注册</a>
忘记密码
1
<a href=
"javascript:;"
onclick=
"showWindow('login', 'member.php?mod=logging&action=login&viewlostpw=1')"
title=
"找回密码"
>找回密码</a>
购买邀请码
1
misc.php?mod=buyinvitecode
JS跳转
1
onclick=
"window.location.href='home.php?mod=mobile&do=friend';"
JS更换class的名称
1
2
3
document.getElementById(
'idname'
).className=
'a'
;
document.getElementById(
'idname'
).style.display=
'block'
;
document.getElementById(
"idname"
).style.marginTop=
"30px"
;
批量替换超链接:
1
href=
"[^"
]*"
过滤DZ代码:
1
preg_replace (
"/\[[a-z][^\]]*\]|\[\/[a-z]+\]/i"
,
''
,preg_replace(
"/\[attach\]\d+\[\/attach\]/i"
,
''
,
$message
));
………………………………………………………………………………………………………………………………………………………………
调用单个数据
1
$qishi
= DB::result(DB::query(
"SELECT qi FROM "
.DB::table(
'jiangchi'
).
" WHERE id = '1'"
));
调用统计数据
1
$qishi
= DB::result(DB::query(
"SELECT count(*) FROM "
.DB::table(
'jiangchi'
).
" WHERE id = '1'"
));
单数据表调用
1
2
3
4
5
6
7
8
9
10
11
12
13
$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"
);
多数据表调用
1
2
3
4
5
6
7
8
9
10
11
12
13
$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
,
"这里填写跳转地址"
);
前台数据显示
1
2
3
4
<!--{loop
$alist
$key
$value
}-->
<!--{
eval
$tupianfm
= DB::result(DB::query(
"SELECT attachment FROM "
.DB::table(
'forum_threadimage'
).
" WHERE tid = '$value[tid]'"
));}-->
$value
[authorid]
<!--{/loop}-->
取数据表中符合条件的第一条数据
1
2
$app
=
array
();
$app
=DB::fetch_first(
"select * from "
.DB::table(
'home_diy_center'
).
" where id='{$id}'"
);
人性化时间戳
1
2
<!--{
echo
dgmdate(这里填写时间参数,
'u'
,
'9999'
, getglobal(
'setting/dateformat'
))}-->
<!--{
echo
date
(
"Y-m/d H:i:s"
,这里填写时间参数)}-->
截取字符字数
1
<!--{
echo
cutstr(这里填写参数,40)}-->
过滤DISCUZ代码
1
preg_replace (
"/\[[a-z][^\]]*\]|\[\/[a-z]+\]/i"
,
''
,preg_replace(
"/\[attach\]\d+\[\/attach\]/i"
,
''
,
$message
));
写入数据库
1
2
3
4
5
6
7
8
9
10
11
12
13
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"
);
}
表单提交:
1
2
3
4
5
6
7
<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>
以下两个时间格式是对等关系
1
2
date
(
"Ymd"
,time()); 20150212
FROM_UNIXTIME(dateline,
'%Y%m%d'
)
前者用于PHP,后者用于数据库调用的字段的格式化
调用图片附件
1
<!--{
eval
$biaoid
=
substr
(
$value
[tid], -1);
$cover
= DB::result(DB::query(
"SELECT attachment FROM "
.DB::table(
'forum_attachment_'
.
$biaoid
.
''
).
" WHERE tid = '$value[tid]'"
));}-->
数据库循环嵌套调用
1
2
3
4
<!--{
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无法登录:
1
2
3
4
5
打开uc_server/model/admin.php
找到第22行的
$this
->cookie_status = 0;
改成
$this
->cookie_status = isset(
$_COOKIE
[
'sid'
]) ? 1 : 0;
无刷新切换li标签并且同时加载框架页面:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<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
class
=“current” dataid=“1”></li>
<li dataid=“2”></li>
</ul>
<div id=“changenr”></div>
快速发帖
1
<a href=
"forum.php?mod=misc&action=nav"
onclick=
"showWindow('nav', this.href, 'get', 0);"
>发布新话题</a>
常用词汇
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
select 选择
count
总数
table 表
where 条件
result 结果
perpage 每页
curpage 当前页
update 更新
delete
删除
insert 写入
dateline 日期
time 时间
echo
输出 <?php
echo
'123'
; ?>
multi 分页函数
if
如果
else
否则
elseif
start 起始
limit 限制 limit 10
DESC 倒序
ASC 正序
0 0
- Discuz数据库调用:DZ模板调用常用代码手册
- Dedecms模板常用调用标签代码整理
- Dedecms模板常用调用标签代码整理
- Discuz!模板开发手册
- 常用Intent调用代码
- wordpress常用调用代码
- WP模板常用调用函数
- asp调用数据库代码
- Discuz! 7.0 模块调用脚本范例程序 - 模板
- DZ论坛横排美化,代码详细分析[Discuz 7.0]
- dede调用非同一个数据库的DZ论坛的帖子
- dedecms首页调用代码大全+手册下载
- discuz 模板代码解释
- discuz 调用ucenter方法
- 心雨中调用Discuz论坛IE6中代码出现乱码
- 帝国cms和discuz论坛系统跨数据库查询调用
- WordPress常用代码调用大全
- phpcms常用个调用代码
- nim博弈
- 期中考试-C
- 主干(trunk)、分支(branch )、标记(tag) 用法示例 + 图解
- attach source(jdk)
- TensorFlow在Windows 10上安装手记
- Discuz数据库调用:DZ模板调用常用代码手册
- 通过DIVA了解APP安全问题
- material-design定制颜色
- 新手必须学习ABAP内容
- tmocate的闪退问题
- Web测试技术--Java平台
- 老北区小心眼的解放
- sharepoint 访问page 下面的页面突然404
- hdu2056 Rectangles