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

This article is about how dede calls SQL statements. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

How to call the sql statement of dede?

Sql statement call still has its advantages in some special cases. The following is an introduction to the wonderful use of dede's sql statement call method. Interested friends should not miss it.

The code is as follows:

{dede:sql sql='Select content from dede_arctype where id=1'} [field:content function= "cn_substr ('@ me',700)" /]. {/ dede:sql}

A seemingly simple piece of code, but the function is very powerful.

Dede_arctype column content table

Content column content field name

Cn_substr (), a commonly used string interception function in dede

Thank you for reading! On the method of dede calling SQL statement to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

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.