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

How does ecms get records by executing sql? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

How does ecms get the required records by executing sql?

The use of the ecms smart tag e:loop gets the required records by executing sql

Under certain conditions, we require the specified information to be displayed on a page of the website

But if this kind of specification is fixed and written to death in code, it will be a big trouble for future changes.

At this time, the advantage of the sql statement is highlighted. Using the SQL statement, you only need to change the numbers to completely replace the displayed content.

The code is as follows:

[eVlloop = {'select * from phome_ecms_news where id in (2452, 2697, 2299, 2267)', 4, 24, 0]

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.