最后二次开发完成后的效果

 

帝国cms调用关注我的列表查询代码

$totalquery="selectcount(*)astotalfrom{$dbtbpre}enewshywherefname='$username'".$a;$num=$empire->gettotal($totalquery);$query="select*from{$dbtbpre}enewshywherefname='$user[username]'".$a;$query.="orderbyfiddesclimit$offset,$line";$sql=$empire->query($query);$returnpage=page1($num,$line,$page_line,$start,$page,$search);

前台展示代码

 

<?phpwhile($r=$empire->fetch($sql)){$fuaddr=$empire->fetch1("selectuserpic,faxfrom{$dbtbpre}enewsmemberaddwhereuserid='$r[userid]'limit1");$fuaddr2=$empire->fetch1("selectuserfen,usernamefrom{$dbtbpre}enewsmemberwhereuserid='$r[userid]'limit1");?><li><imgsrc="<?=$fuaddr[userpic]?$fuaddr[userpic]:$public_r[newsurl].'e/data/images/nouserpic.gif'?>"width="60"height="60"><pclass="gz_info"><aclass="gz_name"href="../ShowInfo/?username=<?=$fuaddr2[username]?>"target="_blank"><?=$fuaddr2[username]?></a><span>性别：<?=$fuaddr[fax]?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;积分：<?=$fuaddr2[userfen]?></span></p><pclass="gz_opera"><aclass="qx_gz"href="/e/member/friend/add/?fcid=0?<?=$fuaddr2[username]?>"target="_blank">添加关注</a><aclass="sendInfo"href="/e/member/msg/AddMsg/?enews=AddMsg"target="_blank">发送短信</a></p></li><?php}?>