本文示例可实现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= "{$v['thumb']}" border= "0" width= "120" height= "92" /></a></div><div class = "dk1bb_b" ><a href= "#" rel= "external nofollow" rel= "external nofollow" >{dsubstr( $v [ 'company' ],18)}</a></div> </li> {/loop} |
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 ; } |
希望本文示例对大家的destoon开发有一定的帮助作用。