cms系统数据调取方法
2022-07-28 15:28:32
168
{{single.collect_count}}

当前样式

function meun_on_con($url) {$self = explode('/', $_SERVER['SCRIPT_NAME']);if ($self[1] == $url) {return "class='on'";} else {return "";}}<li <{"news.php"|meun_on_con}>><li <{if $smarty.server.SCRIPT_NAME == "/club.php"}>class="on"<{/if}>>

推荐、限制

Trs("newstwo_i", "news_page", "del!=1 and tid=93 and bdid=12 and recommended<>0 order by recommended desc , time desc limit 8");Trs("newsthree_i", "news_page", "del!=1 and tid=93 and bdid=13 and recommended<>0 order by recommended desc , time desc limit 8");

调用公共内容

调取公共内容<{include file = "`$app_tpl_w`public/head.tpl"}>//通过获取idif ($_GET['id']){$sql = " and id={$_GET['id']}";}//抛到页面的名称:pic//获取的数据库:index_picTrs("pic","index_pic","del!=1 and tid=67");//给获取的数据指定一个名称$index_pic = Dgs("index_pic","del!=1 and tid=67");$type = Dgs("classify","del!=1 and tid=75 and bdid={$_GET['city']} and bdtid=68");$champion = Dgs("details","del!=1 and tid=69 and region={$_GET['city']} and title={$type[0]['id']}");Tr($champion,'details');foreach ($champion as $key => $value){$spic = Dgs('spic',"del!=1 and tid=76 and bdid={$value['id']} and bdtid={$value['tid']}");$hpic = Dgs('hpic',"del!=1 and tid=77 and bdid={$value['id']} and bdtid={$value['tid']} limit 2");$champion[$key]['spic'] =$spic;$champion[$key]['hpic'] =$hpic;}//通过推荐字段推荐到首页,通过时间排序Trs("i_dynamic","dynamic","del!=1 and tid=77 and recommend<>0 order by recommend desc , time desc limit 6");//在页面上限制文档显示的字数<{$details.advantage|clearhtml|cutstr:'160'}>

Dgs

$financial = Dgs("financial","del!=1 and tid=79");title={$financial[0]['id']}$share = Dgs("dynamic","del!=1 and tid=93");$f_share = Dgs("share","del!=1 and tid=94 and classify={$share[0]['id']}");Tr($champion,'details');Tr($today,"today");

修改翻页样式

<{if $typeone}><{$pages}><{/if}>fy($param = array('result' => 'typeone',//命名'table' => 'pic', //数据库'condition' => "del!=1 and tid=75", //判断条件'perpage' => 4, //显示多少个项目'type' => 4,//翻页的样式'nav' => 'pages', //样式命名//'debug' => 1//查看属性));修改翻页路径:includes/classes/lm_pape.php
回帖
全部回帖({{commentCount}})
{{item.user.nickname}} {{item.user.group_title}} {{item.friend_time}}
{{item.content}}
{{item.comment_content_show ? '取消' : '回复'}} 删除
回帖
{{reply.user.nickname}} {{reply.user.group_title}} {{reply.friend_time}}
{{reply.content}}
{{reply.comment_content_show ? '取消' : '回复'}} 删除
回帖
收起
没有更多啦~
{{commentLoading ? '加载中...' : '查看更多评论'}}