dz模板开发中常用的sql语句

调用单个字段

$myUserName = DB::result(DB::query("SELECT username FROM ".DB::table('common_member')." WHERE uid = '1'"));

调用统计数据

$userCount = DB::result(DB::query("SELECT count(*) FROM ".DB::table('common_member')." WHERE uid = '1'"));

多数据表的调用

$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'"));

$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' ORDER BY bf.fid DESC LIMIT $start,$perpage");

while($value = DB::fetch($query)){

$alist[] = $value;

}

}

$multi = multi($account,$perpage,$curpage,"URL地址");

前台数据的显示

<!--{loop $alist $key $value}-->

<!--{eval $cover = DB::result(DB::query("SELECT attachment FROM ".DB::table ('forum_threadimage')." WHERE tid = '$value['tid']'"));}-->
$value[authorid]

<img src="$cover">

<!--{/loop}-->

时间戳

<!--{echo date("Y-m-d H:i:s",这里填写时间参数)}-->

2017-3-20 20:00:00

<!--{echo date("Y/m/d H:i:s",这里填写时间参数)}-->

2017/5/30 20:00:00

<!--{echo dgmdate(这里填写时间参数,'u','9999',getglobal('setting/dateformat')}-->

1分钟前/1天前

截取字符字数

表单提交

<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>

写入数据库

if(submitcheck('tijiao')){

$setarr = array(

'tid' => $_GET['topicid'],

'name' => $_POST['name'],

'position' => $_GET['position'],

'dateline' => $_G['timetamp'],

);

DB::insert('form_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");
}