Tools Tags
Backend Development
PHP
Empire CMS website management system-secondary development manual
Development example: display the latest 10 news
directory
Tools Tags
Development example: display the latest 10 news
|
|
| <?php require('../../class/connect.php'); //Introduce database configuration files and public function files require('../../class/db_sql.php'); //Introduce database operation files require('../../data/dbcache/class.php'); //Introduce column cache files $link=db_connect(); //Connect to MYSQL $empire=new mysqlquery(); //Declare database operation class $editor=1; //Declare directory hierarchy $sql=$empire->query("select * from
{$dbtbpre}ecms_news order by newstime limit 10"); //Query the latest 10 records in the news table db_close(); //Close the MYSQL link |
| <?php if(!defined('InEmpireCMS')) { exit(); } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="Content- Type" content="text/html; charset=gb2312"> <title>Display the latest 10 news examples</title> </head> <body> <br> <br> <br> <table width="500" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC"> <tr> <td height="25"><strong>Display the latest 10 news: </strong></td> </tr> <tr> <td height="25" bgcolor="#FFFFFF"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> //Loop to obtain query records $titleurl=sys_ReturnBqTitleLink($r); //Title link ?> height="25">·<a href="<?=$titleurl?>" target="_blank"> <?=esub(stripslashes($r[title]),32)?> <td width="33%"><div align="center">[<?=date('Y-m-d',$r[newstime])?>]</div></td> } ?> </td> </tr> </table></body> </html> | Note: The template can be visually produced with Dreamweaver. The blue part of the code does not allow direct access to the template file.
Hot AI Tools
Undress images for free
Online AI tool for removing clothes from photos.
AI-powered app for creating realistic nude photos
AI image generator for creative art from text prompts.
AI powered investment research for smarter decisions
Hot Article
Hot Topics
20462
7
13602
4
Popular tool
Easy-to-use and free code editor
Chinese version, very easy to use
Powerful PHP integrated development environment
Visual web development tools
God-level code editing software (SublimeText3)














![Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]](https://img.php.cn/upload/course/000/000/035/5d27fb58823dc974.jpg)