1：用户表
2：话题表
3：点赞表
用户在话题表里面添加话题，其他用户点赞该帖子，我要显示出该帖子点赞人的头像。
表结构如下：
1：用户表
2：帖子表
3：点赞表
最终要的效果如下图箭头所标注这样
现在我的问题是没法去用户表查出用户的头像！
几个好心人告诉我用递归方法，我就是不会！望大神帮忙下！！！！
public function loaddata(){
$villageid=session('villageid');
$dongtai=D('manage_dongtai_topic');
$where['villageid']=$villageid;
$count=$dongtai->where($where)->count();
$listRows=10;
$p=new Page($count,$listRows);
$list=$dongtai->where($where)->limit($p->firstRow.','.$p->listRows)->select();
foreach ($list as $k1 => $v1) {
$list[$k1]['pic']=substr($v1['pic'],1,strlen($v1['pic'])-2);
$list[$k1]['pic']=explode(',',$list[$k1]['pic']);//分割读出图片
$list[$k1]['userinfo']=D('wechat_user')->where('id='.$v1['uid'])->find();//根据动态表里的UID得出该用户的头像
$list[$k1]['zans']=D('manage_dongtai_zan')->where('did='.$v1['id'])->select();
/*
*这里要通过赞表里面的对于UID到用户表里面查出用户头像显示到模板中
*没法继续写了 大神指点下
*/
}
$html='';
foreach($list as $vo){
$create_time=formatTime($vo['create_time']);
$html.="<li id='topic-{$vo['id']}'>
<a class='topic-panel' rel='{$vo['id']}' author='{$vo['uid']}'><i class='fa fa-arrow-down'></i></a>
<div class='topic-head'>
<div class='item-avatar'>
<img src='{$vo['userinfo']['headimgurl']}'>
</div>
<div class='item-info'>
<div class='item-nickname'>
{$vo['userinfo']['nickname']} </div>
<span>{$create_time}</span>
<span>浏览 {$vo['view']}</span>
</div>
</div>
<div class='topic-content'>
<a class='item-name external' href='/Wap/tieba/bar/id/4.html'>#{$vo['userinfo']['village']}#</a>
<a class='item-title external' href='/Wap/tieba/detail/id/195.html'>{$vo['title']}</a>
<a class='item-text external' href='/Wap/tieba/detail/id/195.html'>{$vo['content']}</a>
<div class='item-photo'>";
foreach ($vo['pic'] as $vb) {
$html.="
<div class='pic'>
<div class='pic-holder'></div>
<span id='immg' style='background:url(/public/uploads/{$vb})'></span>
</div>
";
}
$html.="
</div>
</div>
<div class='topic-ctrl'>
<a class='external' href='/Wap/tieba/detail/id/195.html'><i class='fa fa-share'></i>转</a>
<a class='do-topic-review' rel='{$vo['id']}'><i class='fa fa-comment'></i>评<span>3</span></a>
<a class='do-topic-zan' rel='{$vo['id']}'><i class='fa fa-dig'></i>赞 <span>{$vo['zan']}</span></a>
</div>
<div id='show-zan-{$vo['id']}' class='topic-digs'>
<span><i class='fa fa-dig'></i></span>
<div class='dig-data'>";
/*此处读出点过赞的UID，通过UID去用户表查找用户头像*/
foreach ($vo['userimg'] as $ss) {
$html.="<a href='#'><img src='{$ss['headimgurl']}'></a> ";
}
$html.="</div>
</div>
";
}
echo $html;
$plist=I('get.p');
if ($plist >= $count) {
$html.="0";
echo $html;
}
} 最佳答案
