How does DreamWeaver SQL call the article and obtain the static address?

How does Dreamweaver SQL call the article and obtain the static address?

How to call the DreamWeaver SQL article and obtain the static address

Recommended learning: DreamWeaver cms

As we all know, in the Dede system In the method of SQL calling the article and obtaining the static address, I can freely use the SQL statement of the method of SQL calling the article and obtaining the static address to cooperate with the method of SQL calling the article and obtaining the static address of the Dreamweaver tag to make more personalized calls. The basic reference format is:

{dede:sql sql='select  字段 From 表名称 where 条件语句'}
[field:字段名/]
{/dede:sql}

From the above basic format, we can basically convert a call tag that calls the document list. The code SQL method to call the article and obtain the static address is:

{dede:sql sql='select  * From dede_archives  limit 10'}
<a href="/plus/view.php?aid=[field:id/]">[field:title/]</a>
{/dede:sql}

You have seen that the underlying template address of the document link above is dynamic, so how do we convert it?

Let it be linked to a static address. Here we only need to [field:id /]Convert it, the complete code after conversion is:

{dede:sql sql="SELECT * FROM dede_archives limit 10"} 
<li>·<a href=&#39;
[field:id runphp=&#39;yes&#39;] $id=@me;@me=&#39;&#39;;$url=GetOneArchive($id);@me=$url[&#39;arcurl&#39;];[/field:id]&#39; >[field:title/]</a>
</li>
{/dede:sql}

If it is a dede:php tag, it is almost the same, mainly using the GetOneArchive method, for example:

{dede:php}
$dsql->SetQuery("SELECT * FROM dede_archives limit 10");
$dsql->Execute();
while($arr = $dsql->getArray()){
$arcurl = GetOneArchive($arr['aid']);
echo &#39;<li>·<a href=“&#39;.$arcurl[&#39;arcurl&#39;].&#39;”>[field:title/]</a></li>&#39;;
}
{/dede:php}

The above is the detailed content of How does DreamWeaver SQL call the article and obtain the static address?. For more information, please follow other related articles on the PHP Chinese website!