本文示例可实现Destoon多表查询。在进行destoon二次开发的时候有很高的实用价值。具体实现方法如下:
1.模板文件部分
具体代码如下:
1 2 3 4 5 6 | <!--{php $tags =tag( "table=destoon_member m,destoon_company c&prefix=&condition=m.userid=c.userid and c.groupid=17&pagesize=10&template=null" );}-->
{loop $tags $v }
<li>
<div class = "dk1bb_t" ><a href= "#" rel= "external nofollow" rel= "external nofollow" ><img src= "/static/imghw/default1.png" data-src= "{$v['thumb']}" class = "lazy" thumb ']}" border="0" style="max-width:90%" style="max-width:90%" / alt="Destoon实现多表查询示例_php实例" ></a></div><div class="dk1bb_b"><a href="#" rel="external nofollow" rel="external nofollow" >{dsubstr($v[' company'],18)}</a></div>
</li>
{/loop}
|
Copy after login
2.php代码部分
实现destoon多表查询代码如下:
1 2 3 4 5 6 7 8 9 | function getSell( $uname ){
global $db ;
$lists = array ();
$result = $db ->query( "SELECT * FROM {$db->pre}sell WHERE username='$uname' limit 0,6" );
while ( $r = $db ->fetch_array( $result )) {
$lists [] = $r ;
}
return $lists ;
}
|
Copy after login
希望本文示例对大家的destoon开发有一定的帮助作用。