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

This article mainly introduces how to call the corresponding content statistics in the dedecms page, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor with you to understand.

Test the success in person under DEDECMS 5.7sp2 and call the specified dedecms fragmentary column corresponding to the number of posts.

Code:

{dede:sql sql= "SELECT count (ID) AS c FROM dede_archives where typeid = 1"} [field:c /] {/ dede:sql}

Count the number of articles in ID=1 in the corresponding article table "dede_archives" in DEDECMS.

Suppose your column: audio, corresponding to id is 2, and this column announces 31 articles. When you build a dedecms database with the prefix abc, then the code:

A total of {dede:sql sql= "SELECT count (ID) AS c FROM abc_archives where typeid = 2"} [field:c /] {/ dede:sql} articles

After being born with HTML, it appears:

Total static columns: 31 articles

Note: for the above examples, blue and red correspond, one is your table prefix, the other is that you want to misappropriate the column corresponding to id.

Thank you for reading this article carefully. I hope the article "how to call the corresponding content statistics in the dedecms page" shared by the editor will be helpful to everyone. At the same time, I also hope you can support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.