Shulou(Shulou.com)06/02 Report--

Editor to share with you what Imperial CMS custom list SQL call methods have, I hope you can learn a lot after reading this article, let's discuss it together!

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

Custom list usage:

Users go to backend-> template Management-> Custom list-> (upper right corner) add custom list

1. The list name is the list name seen by the background administrator.

two。 The title name is the title, which can be displayed in the template with the global tag [!-- pagetitle--]. It is convenient for multiple custom lists to share the same list template.

3. File storage directory is a storage directory, which supports symbols such as'_','- 'and so on.

4. The file extension is an extension. Html is recommended.

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

Note: this sentence SQL means to find and count the column id=1 and the total number of audited information located in the phome_ecms_news news data table.

6. Query record: (e.g. select * from phome_ecms_news where classid=1 and checked=1 order by id)

Note: this sentence SQL means to query * (this symbol represents all field information) from phome_ecms_news this data table condition is that column ID=1 and audit = 1 (meaning approved) by id is sorted by the ID of the information. (if you add a desc in reverse order, for example: by id desc)

Common Imperial 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 (3jorie 18pr 32jort 44pr 71)

Note: query the columns under the news data table ID as follows: 3, 18, 32, 44, 71, total number of messages.

2. SQL statement 2:

The code is as follows:

Select * from [! db.pre!] ecms_news where classid in (3meme 18pr 32jue 44jue 71) order by id desc

Note: call the column under the news data table ID as follows: 3, 18, 321, 44, 71

3. SQL statement 3:

The code is as follows:

Select * from [! db.pre!] _ ecms_news where classid=59 and checked=1 order by id

Note: call the information under the news data table whose ID is 59 and approved.

After reading this article, I believe you have a certain understanding of the Imperial CMS custom list SQL call method, want to know more related knowledge, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.