How to call the content of a single-page document on the DreamWeaver homepage

How to call the content of a single-page document on the Dreamweaver homepage?

The homepage of DEDECMS calls the content of a single-page document

The implementation method of calling the content of a single-page document on the homepage of DedeCMS is as follows:

{dede:sql sql="SELECT body FROM `dede_sgpage` where aid = 3" }   
[field:body function="htmlspecialchars(cn_substr(@me,100))"/]   
{/dede:sql}

Among them:

{dede:sql sql="SELECT body FROM `dede_sgpage` where aid = 3" }

Recommended learning: dedecms tutorial

sql="SELECT body " The body here is the content of the article;

FROM `dede_sgpage` The dede_sgpage here is the data table for single-page document archiving. This is for Dreamweaver 5.6. Other versions need to be defined according to the name of the table;

where aid = 3" aid = 3 here is the id where our single-page document is located. If we need to call the content of which single-page document, just replace this with the id of the document!

[field:body function="htmlspecialchars(cn_substr(@me,100))"/]

field:body The body here is also the content of the article;

(cn_substr(@me,100) The 100 here is the number of words we plan to display the content. This can be adjusted.

When you do this, you will find a problem, html is also called. We need to filter it out, use the following method:

{dede:sql sql="SELECT body FROM `dede_sgpage` where aid = 3" }   
[field:body function="htmlspecialchars(cn_substr(Html2text(@me),100))"/]   
{/dede:sql}

Html2text() This function is the code to remove the html tag;

cn_substr(str,100) This function is to intercept the length of the string.

In this way we The content of a single-page document can be called.

The above is the detailed content of How to call the content of a single-page document on the DreamWeaver homepage. For more information, please follow other related articles on the PHP Chinese website!