notorm->user ->select("id,user_nicename,avatar,avatar_thumb,sex,signature,province,city,birthday,age") ->where($where,$key,'%'.$key.'%',$uid) ->order("id desc") ->limit($start,$pnum) ->fetchAll(); foreach($result as $k=>$v){ $result[$k]['isattention']=(string)isAttention($uid,$v['id']); $result[$k]['avatar']=get_upload_path($v['avatar']); $result[$k]['avatar_thumb']=get_upload_path($v['avatar_thumb']); if($v['age']<0){ $result[$k]['age']="年龄未填写"; }else{ $result[$k]['age'].="岁"; } if($v['city']==""){ $result[$k]['city']="城市未填写"; } $result[$k]['praise']=getPraises($v['id']); $result[$k]['fans']=getFans($v['id']); $result[$k]['follows']=getFollows($v['id']); unset($result[$k]['consumption']); } if($result){ $last=array_slice($result,-1,1); $_SESSION['search']=$last[0]['id']; } return $result; } public function videoSearch($uid,$key,$p) { $pnum=50; $start=($p-1)*$pnum; $where="v.isdel=0 and v.status=1"; $where.=" and (v.title like '%".$key."%' or u.user_nicename like '%".$key."%')"; $prefix= DI()->config->get('dbs.tables.__default__.prefix'); $result=DI()->notorm->user_video ->queryAll("select v.*,u.user_nicename,u.avatar from {$prefix}user_video v left join {$prefix}user u on v.uid=u.id where {$where} order by v.addtime desc limit {$start},{$pnum}"); //敏感词树 $tree=trieTreeBasic(); foreach ($result as $k => $v) { $v=handleVideo($uid,$v,$tree); $result[$k]=$v; } return $result; } }