以下代码加到帝国cms模板里面,比如首页模板ul[e:loop={select userid as userid,truename as title,userpic as titlepic from [!db.pre!]enewsmemberadd order by userid desc limit 8,10,24,0}]lia href=/e/space/us
列表内容模板(list.var)代码:$uid=$empirefetch1(select * from {$dbtbpre}enewsmemberadd where userid={$r[userid]});$usql=$empirefetch1(select * from {$dbtbpre}enewsmember where userid = {$r[userid]});$use
$members=$empiregettotal(select count(*) as total from phome_enewsmember);$newmember=$empirefetch1(select userid,username from phome_enewsmember order by userid desc limit 1);$tzcount=$empiregettotal(
在后台系统执行sql语句update phome_ecms_download set titleurl=replace(titleurl,http:www.daixiao360.cn,http:127.0.0.1);update phome_ecms_download set titlepic=replace(titlepic,http:www.daixiao360.cn,htt
以下代码加到自定义页面即可运行生成新闻标题的首字母$sql=$empirequery(select id,title from {$dbtbpre}ecms_news where id5000 order by id limit 1000);while($r=$empirefetch($sql)){if($r[title]){$zm=GetInfo
帝国CMS不同会员组查看文章权限判断在静态页面的实现方法require(clas/connect.php);include(clas/db_sql.php);include(clas/config/config.php);include(data/dbcache/clas.php);$link=db_connect();$empire=new my
以下代码适合放到封面模板,列表模板和内容页模板$clas_sql=$empirefetch1('select clasid,clasname,bname from '.$dbtbpre.'enewsclas where clasid='.$GLOBALS[navclasid].'');$bname=$clas_sql[bname];
新增自定义列表页:查询SQL语句:统计记录:select count(*) as total from [!db.pre!]enewsmember查询记录:select u.*,ui.* from [!db.pre!]enewsmember u LEFT JOIN [!db.pre!]enewsmemberadd ui ON u.userid=ui.useri