Example of implementing multi table query in Destoon
- 2021-07-16 01:57:54
- OfStack
The example in this article can implement Destoon multi-table query. It has high practical value when developing destoon2. The specific implementation method is as follows:
1. Template file section
The specific code is as follows:
<!--{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 code part
The code for implementing destoon multi-table query is as follows:
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;
}
I hope the examples in this article will be helpful to everyone's destoon development.