search
  • Sign In
  • Sign Up
Password reset successful

Follow the proiects vou are interested in andi aet the latestnews about them taster

Development example: display the latest 10 news

Display the latest 10 news program writing examples Program code writing Storage directory format:
Plug-in program storage directory: /e/extend/newnews/
Plug-in template storage directory uses: /e/extend/newnews/template/
Required program files:
/e/extend/newnews/index.php Main program file
/e/extend/newnews/template/index.temp.php Main program template file

Program Directory Template Directory
Main program file content(/e/extend/newnews/index.php):
<?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
require('template/index.temp.php'); //Import template file

db_close(); //Close the MYSQL link
$empire=null; //Cancel operation class variables
?>


Main program template file content(/e/extend/newnews/template/index.temp.php):
Note: The template can be visually produced with Dreamweaver. The blue part of the code does not allow direct access to the template file.
<?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>



Access the main program of the Hello World plug-in file: /e/extend/newnews/index.php
Hot AI Tools
Undress AI Tool
Undress AI Tool

Undress images for free

AI Clothes Remover
AI Clothes Remover

Online AI tool for removing clothes from photos.

Undresser.AI Undress
Undresser.AI Undress

AI-powered app for creating realistic nude photos

ArtGPT
ArtGPT

AI image generator for creative art from text prompts.

Stock Market GPT
Stock Market GPT

AI powered investment research for smarter decisions

Popular tool
Notepad++7.3.1
Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version
SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1
Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6
Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version
SublimeText3 Mac version

God-level code editing software (SublimeText3)