Find the data source under the module in the PHPCMS background first
There are two ways of data sources
1, internal data source
2, external data source
Only external data sources are done here. Add an external data source
1) must fill in the database link information, specify a data name (within the station call is used)
2) go to "tags", click on the Label Wizard, add a label to fill out the SQL statement to generate the following calling code
{pc:get sql= "select * from CDs" cache= "3600" page= "$page" dbsource= "dd" return= "Data"}
{Loop $data $n $r}
<li><a href= "{$r [' url ']}" title= "{$r [' title ']}" >{$r [' title ']}</a></li>
{/loop}
{/PC}
Cache Caching Time
page Specifies paging
Bsource Data Source Name
Return data
I have a few times the generated code contains spaces resulting in an error in the call, so here's the question of whitespace behind Dbsource
Phpcms v9 Data source