加入我们 登录
漫潮者,私有云,NAS,新媒体电商.软件开发,商乾 返回首页

北极孤星的泪的个人空间 https://www.aurrel.com/?1 [收藏] [复制] [分享] [RSS]

日志

discuz数据库常用语句

已有 882 次阅读2020-11-15 10:27 |个人分类:我的笔记——技术篇| discuz数据语句

常用词汇
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]'"));}-->
评论 (0 个评论)

facelist doodle 涂鸦板

您需要登录后才可以评论 登录 | 加入我们

商乾全球电商人、电商交流学习与电商实战技术分享、电商爬虫、生活交流专业网站
  • 官方手机版

  • 微信公众号

  • 商务合作