phpcms v9用get-sql调用数据表中的图组图片示例代码

{pc:get sql="SELECT pictureurls FROM phpcms_picture_data where id = $id" start="0" num="30" return="pictureurls" } 
{loop $pictureurls $pic_k $r} 
{php $a=string2array($r[pictureurls])} 
{loop $a $pic_l $v} 
<img src="{$v['url']}" longdesc="{$v['url']}" alt="{$v['alt']}" /> 
{/loop} 
{/loop} 
{/pc}

 还有另外一种，列表栏目组图调用的标签写法：

{pc:content action="lists" catid="$catid" num="10" order="listorder DESC" moreinfo="1" page="$page"}
<div>
{loop $data $n $r}
<ul>
<li><a href="{$r[url]}">{$r[title]}</a></li>
</ul>
<div class="col-auto">
{loop string2array($r['pictureurls']) $pic_k $v}
{if $pic_k>3}
{php break}
{/if}
<a href="{$r[url]}"><img src="{thumb($v[url],175,120)}" width="175" height="120" alt="{$v[alt]}"/></a>
{/loop}
</div>
{/loop}
</div>
{/pc}