Home > CMS Tutorial > Empire CMS > body text

Empire CMS custom list SQL calling method

silencement
Release: 2019-11-27 13:48:10
forward
2180 people have browsed it

Empire CMS custom list SQL calling method

The example in this article describes the SQL calling method of the Empire CMS custom list. Share it with everyone for your reference. The specific methods are as follows:

Empire CMS custom lists can be used to implement specific information lists.

How to use custom lists:

Users enter the background->Template Management->Custom List->(upper right corner) to add a custom list

1 . The list name is the name of the list seen by the backend administrator.

2. The title name is the title, which can be displayed in the template using the global tag [!--pagetitle--], so that multiple custom lists can share the same list template

3 . The file storage directory is the storage directory, and the storage directory supports '_', '-' and other symbols

4. The file extension is the extension, and it is recommended to use html

5. Statistical records: ( For example: select count(*) as total from phome_ecms_news where classid=1 and checked=1)

Note: This SQL sentence means to find the statistics located in the data table phome_ecms_news column id=1 and review of the news data table Total number of information passed

6. Query records: (for example: select * from phome_ecms_news where classid=1 and checked=1 order by id)

Note: This SQL sentence means to query * (This symbol represents all field information) From phome_ecms_news, the data table conditions are column ID=1 and review=1 (which means review passed) by id, which is to sort according to the ID of the information. (If you add a desc in reverse order, for example: by id desc)

Recommended to study "Empire cms tutorial"

Commonly used empire CMS custom list syntax:

1. SQL statement 1:

The code is as follows:

select count(*) as total from [!db.pre!]ecms_news where classid in (3,18,32,44,71)
Copy after login

Note: The column ID under the query news data table is: 3, 18, 32, 44, 71 The total number of information

2. SQL statement 2:

The code is as follows:

select * from [!db.pre!]ecms_news where classid in (3,18,32,44,71) order by id desc
Copy after login

Note: The column ID under the news data table is called: 3, 18, 32, 44, 71 information

3. SQL statement 3:

The code is as follows:

select * from [!db.pre!]_ecms_news where classid=59 and checked=1 order by id
Copy after login

Note: Call the information whose column ID is 59 under the news data table and has passed the review.

The above is the detailed content of Empire CMS custom list SQL calling method. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:www.word666.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!