Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What are the considerations for the Imperial CMS 70000 label SQL call?

2025-03-17 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

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

Xiaobian to share with you what are the precautions of the Empire CMS7.0 universal label SQL call, I believe most people still do not know how, so share this article for your reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

Empire CMS universal label SQL statement call is more flexible, is a lot of use empire CMS webmaster prefer a call way, however empire cms7.0 version and before version 6.6 but because of the adjustment of the data table structure and there are some differences.

Take the database phome_ecms_news that comes with the Empire CMS version 6.6 as an example. Its foreign news classid is 35. The following methods can be used to call the latest 5 pieces of data:

The code is as follows:

[ecmsinfo]'select * from [! db.pre!] ecms_news where checked=1 and classid=35 order by newstime desc limit 5 ' ,5,24,0,24,2,0[/ecmsinfo]

By analogy, the following statements can be used to call the latest data items 6 to 10:

The code is as follows:

[ecmsinfo]'select * from [! db.pre!] ecms_news where checked=1 and classid=35 order by newstime desc limit 5,5 ' ,5,24,0,24,2,0[/ecmsinfo]

However, if you use Imperial CMS 7.0, the above statement will be incorrect! The reason is that Empire CMS 7.0 separates out unaudited information, so there is no checked field in the table. At this time, the latest 5 pieces of information can be called with the following statement:

The code is as follows:

[ecmsinfo]'select * from [! db.pre!] ecms_news where and classid=35 order by newstime desc limit 5',5,24,0,24,2,0 [/ecmsinfo] The above is Empire CMS7.0 universal label SQL call notes what all the content, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Servers

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report