在首页或者频道列表页面中,我们经常需要调用附加表字段,将需要调用的字段,换成如下格式放在arclist标签内即可.
[field:id runphp="yes"]
$dsql = new DedeSql(false);
$a="SELECT mb5u.新增字段名 FROM dede_附加表名 as mb5u where mb5u.aid=@me";
$arcRow = $dsql->GetOne($a);
@me=''.$arcRow[新增字段名].'';
[/field:id]
具体实例代码:
{dede:list perpage='20'}
<div class="f-con01">
<div class="f-con01-l">
<a><img src="/templets/qiba/images/con01-f.jpg"></a>
</div>
<div class="f-con01-r">
<p class="a6"><a href="[field:arcurl/]" target="_blank">[field:title/]</a></p>
<p><a>[field:description/]...</a></p>
<dl>
<dt>地址:</dt>
<dd>[field:id runphp="yes"]
$dsql = new DedeSql(false);
$sql="SELECT qiba.address from `dede_addonqiba` as qiba where qiba.aid=@me";
$arcRow = $dsql->GetOne($sql);
@me=''.$arcRow['address'].'';
[/field:id]</dd>
<dt>乘车路线:</dt>
<dd>[field:id runphp="yes"]
$dsql = new DedeSql(false);
$sql="SELECT qiba.roadline from `dede_addonqiba` as qiba where qiba.aid=@me";
$arcRow = $dsql->GetOne($sql);
@me=''.$arcRow['roadline'].'';
[/field:id]</dd>
</dl>
<dl>
<dt>电话:</dt>
<dd>[field:id runphp="yes"]
$dsql = new DedeSql(false);
$sql="SELECT qiba.telephone from `dede_addonqiba` as qiba where qiba.aid=@me";
$arcRow = $dsql->GetOne($sql);
@me=''.$arcRow['telephone'].'';
[/field:id]</dd>
</dl>
</div>
<div class="f-con01-b">
<div class="star">
<p>评分:</p>
[field:id runphp="yes"]
@me=rating_bar(@me,5);
[/field:id]
</div>
</div>
<div class="clear"></div>
</div>
{/dede:list}