操作数据

输出数据库PHP代码

//全表数据
{php $str = D('all_content')->field('allid,modelid,catid,id,userid,username,title,inputtime,updatetime,url,thumb')->select();var_export($str);}

//文章数据
{php $str = D('article')->field('id,catid,userid,username,nickname,title,inputtime,updatetime,description,click,content,copyfrom,thumb,url,flag,listorder')->select();var_export($str);}

//轮播数据
{php $str = D('banner')->field('id,title,image,url,inputtime,listorder,typeid,status')->select();var_export($str);}

//轮播分类数据
{php $str = D('banner_type')->select();var_export($str);}

//导航数据
{php $str = D('category')->field('catid,catname,modelid,parentid,arrparentid,arrchildid,catdir,catimg,type,listorder,target,pclink,entitle,subtitle,mobname,category_template,list_template,show_template')->select();var_export($str);}

//单页数据
{php $str = D('page')->field('catid,title,content,updatetime')->select();var_export($str);}

//商品数据
{php $str = D('product')->field('id,catid,userid,username,nickname,title,inputtime,updatetime,description,click,content,copyfrom,thumb,url,flag,listorder,pictures,price,unit,stock')->select();var_export($str);}

统计数据总量->total()

{php $ztdata = D('zt')->where(array('status'=>1,'typeid'=>1))->total();}

读取数据列表->select()

{php $ztdata = D('zt')->where(array('status'=>1,'typeid'=>1))->order('id DESC')->limit(4)->select();}
{loop $ztdata $s=>$v}
	<div>
		<a target="_blank" href="{U('zt/index/lists',array('id'=>$v['id']))}" title="{$v[title]}">
			<img src="{if !empty($v['catimg'])}{$v[catimg]}{else}{STATIC_URL}images/nopic.jpg{/if}" width="270" height="135" alt="{$v[title]}" />
			<div class="bar"><div class="title">{$v[title]}</div></div>
		</a>
	</div>
{/loop}

精准查找某个数据->find()

{php $tj = D('download')->field('id,catid,title,thumb,url,version,filesize')->where(array('id'=>$appid))->find();}
{if $tj}
	{$v[title]}
	{$v[catid]}
	{$v[version]}
{/if}