Hongmu Notes
Home Program Notes EmpireCMS Special Call and Database Table
Program Notes Empire cms

EmpireCMS Special Call and Database Table

EmpireCMS Special Call and Database Table

List Call

The template includes the following predefined thematic fields:

Special Topic ID: [!--self.classid--]

Special Topic Title: [!--pagetitle--]

Special Feature Introduction: [!--class.intro--]

Special Topic Thumbnail URL: [!--class.classimg--]

20231221114300943-图片

Call the special topic list using the Dynamic Index Tag:

[e:loop={"select * from [!db.pre!]enewszt where ztid='$GLOBALS[navclassid]' order by ztid desc limit 20",0,24,0}]
    专题id:<?=$bqr[ztid]?>
    专题名称:<a href="<?=$public_r[newsurl]?><?=$bqr['ztpath']?>/"><?=$bqr['ztname']?></a>
    专题图片:<img src="<?=$bqr[ztimg]?>" />
    专题简介:<?=$bqr['intro']?>
    关键词:<?=$bqr[ztpagekey]?>
    创建时间:<?=date('Y-m-d',$bqr[addtime])?>
    [/e:loop]

The article content page displays the associated topic.

[e:loop={"select * from [!db.pre!]enewsztinfo where classid='$navinfor[classid]' and id='$navinfor[id]'",0,24,0}]
当前文章来自专题:<a href="<?=$public_r[newsurl]?><?=$class_zr[$bqr[ztid]][ztpath]?>/"><?=$class_zr[$bqr[ztid]][ztname]?></a><br>
 [/e:loop]

data sheet

20231221123353790-图片

 

微信赞赏

WeChat

支付宝赞赏

Alipay

✍️ Author: Hong Mu

webmaster · Thanks for reading, stay tuned for more exciting content

Author homepage View home page →

Related articles

Empire CMS database statement & SQL statement format

Empire CMS database statement & SQL statement format Program Notes Empire cms

Introduction to Imperial CMS extended SQL program writing, basic examples of Imperial CMS database statements & SQL statement formats: Note: The following examples are based on placing PHP files in the system root directory. Example 1: Connect to MYSQL program. (a.php)<?php require('e/class/connect.php'); //Introduce database configuration files and public function files requ…
👁 351
Empire CMS obtains the system COOKIE variable function getcvar()

Empire CMS obtains the system COOKIE variable function getcvar() Program Notes Empire cms

Get the system COOKIE variable function syntax: getcvar($var,$ecms) Description: $var: is the variable name $ecms: 0 is to set the foreground COOKIE variable, 1 is to set the background COOKIE variable. This parameter can be omitted and defaults to 0. Usage example: getcvar('mlusername'), get the user name of the front-end login member getcvar('loginu...
👁 295
Empire CMS smart label call field collection

Empire CMS smart label call field collection Program Notes Empire cms

Collect and classify all fields that support smart tag calls into Empire CMS smart tags: [e:loop={column ID/topic ID, number of items displayed, operation type, only display pictures with titles, additional SQL conditions, display sorting}] Template code content [/e:loop] Calling time: <?=date('m-d',$bqr[newstime])?> <?=dat…
👁 3748

Recommended reading

(PC + WAP) New Energy Vehicle Charging Station Website – pbootCMS Template; Download Source Code for Automotive Charging Station Websites – 0054

(PC + WAP) New Energy Vehicle Charging Station Website – pbootCMS Template; Download Source Code for Automotive Charging Station Websites – 0054 Practical Collection pbootcms Template

This PbootCMS template is designed for the new energy vehicle charging station and supporting infrastructure industry, supporting both PC and mobile devices. Its modern, tech-driven design effectively showcases charging station products and smart charging solutions. It serves as a powerful tool for new energy technology companies to create branded official websites and promote their green mobility initiatives. Template Preview | Installation Instructions | Website Backend: /admin.php | Username: admin | Password: admin | Extraction Password: w...
👁 48
QQ Personal Space Blog & News Website Template 0765

QQ Personal Space Blog & News Website Template 0765 Practical Collection Yiyou template

An eYouCMS template designed for QQ Personal Space, blog/chronicle websites, and news/information platforms. Its fresh and artistic design makes it ideal for hosting emotional journals, personalized signatures, engaging blog posts, and real-time updates. This template helps individual webmasters or bloggers build personalized content-sharing platforms. Template Preview | Installation Instructions | Website Backend: /login.php | Username: admin | Password: admin | Related Articles: Summary of Common Installation Issues for eYouCMS | eYou...
👁 47
Responsive AI Chip Website Template 0128

Responsive AI Chip Website Template 0128 Practical Collection Yiyou template

An eyouCMS responsive website template designed for the artificial intelligence and AI chip industry. Its futuristic design style effectively showcases AI chip products, R&D initiatives, and real-world application scenarios. This template helps chip design companies build their brand image online and attract investment and customers. Template Display | Installation Instructions | Website Backend: /login.php | Username: admin | Password: admin | Related Articles: Summary of Common Installation Issues for YouyouCMS...
👁 69
(Adaptive mobile version) Responsive black premium brand footwear supply information website – PBootCMS template; Download source code for footwear wholesale website – 0675

(Adaptive mobile version) Responsive black premium brand footwear supply information website – PBootCMS template; Download source code for footwear wholesale website – 0675 Practical Collection pbootcms Template

A responsive black branded footwear e-commerce platform and wholesale shoe sales website template (PbootCMS), compatible with both PC and WAP devices. Featuring a trendy and modern design, this template is ideal for footwear wholesalers and supply chain information websites to showcase products and industry trends. It helps footwear traders attract distributors and retailers online. Template Preview | Installation Instructions | Website Backend: /admin.php | Username: admin | Password: admin | Extraction Password: ww...
👁 50
(PC+WAP) Smart Vehicle Management Intelligent Access Control System – PbootCMS Website Template; Download Source Code for Smart Technology Company Websites – 0055

(PC+WAP) Smart Vehicle Management Intelligent Access Control System – PbootCMS Website Template; Download Source Code for Smart Technology Company Websites – 0055 Practical Collection pbootcms Template

A PbootCMS website template designed for smart vehicle management and intelligent access control systems, compatible with both PC and WAP devices. The design features a predominantly blue color scheme that highlights a modern, tech-driven aesthetic. This template is ideal for showcasing products and solutions such as facial recognition systems, vehicle management solutions, and access control gates, helping smart technology companies establish a professional online presence. Template Display | Installation Instructions | Website Backend: /admin.php | Username: admin | Password: admin...
👁 53