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!