搜索分頁 · TP5常用代碼

[TOC] ## 檢索出除自己外呢稱含有關鍵字的用戶 ``` $where = array( 'username' => array('LIKE', '%' . $keyword . '%'), 'uid' => array('NEQ', session('uid')) ); ``` ## 互相關注組合條件 ``` $db = M('follow'); $sql = '(SELECT `follow` FROM `hd_follow` WHERE `follow` = ' . $v['uid'] . ' AND `fans` = ' . session('uid') . ') UNION (SELECT `follow` FROM `hd_follow` WHERE `follow` = ' . session('uid') . ' AND `fans` = ' . $v['uid'] . ')'; $mutual = $db->query($sql); ``` >完整代碼： ``` /** * 重組結果集得到是否互相關注與是否已關注 * @param [Array] $result [需要處理的結果集] * @return [Array] [處理完成后的結果集] */ Private function _getMutual ($result) { if (!$result) return false; $db = M('follow'); foreach ($result as $k => $v) { //是否互相關注 $sql = '(SELECT `follow` FROM `hd_follow` WHERE `follow` = ' . $v['uid'] . ' AND `fans` = ' . session('uid') . ') UNION (SELECT `follow` FROM `hd_follow` WHERE `follow` = ' . session('uid') . ' AND `fans` = ' . $v['uid'] . ')'; $mutual = $db->query($sql); if (count($mutual) == 2) { $result[$k]['mutual'] = 1; $result[$k]['followed'] = 1; } else { $result[$k]['mutual'] = 0; //未互相關注是檢索是否已關注 $where = array( 'follow' => $v['uid'], 'fans' => session('uid') ); $result[$k]['followed'] = $db->where($where)->count(); } } return $result; } ``` ## 格式化搜索關鍵字（加紅搜索關鍵字） ``` {$v.username|str_replace=$keyword, '<font style="color:red">' . $keyword . '</font>', ###} <a href="">{$v.username|str_replace=$keyword, '<font style="color:red">' . $keyword . '</font>', ###}</a> ``` ## 搜索找人后臺處理 ``` /** * 搜索找人 */ Public function sechUser () { $keyword = $this->_getKeyword(); if ($keyword) { //檢索出除自己外呢稱含有關鍵字的用戶 $where = array( 'username' => array('LIKE', '%' . $keyword . '%'), 'uid' => array('NEQ', session('uid')) ); $field = array('username', 'sex', 'location', 'intro', 'face80', 'follow', 'fans', 'weibo', 'uid'); $db = M('userinfo'); //導入分頁類 import('ORG.Util.Page'); $count = $db->where($where)->count('id'); $page = new Page($count, 20); $limit = $page->firstRow . ',' . $page->listRows; $result = $db->where($where)->field($field)->limit($limit)->select(); //重新組合結果集，得到是否已關注與是否互相關注 $result = $this->_getMutual($result); //分置搜索結果到視圖 $this->result = $result ? $result : false; //頁碼 $this->page = $page->show(); } $this->keyword = $keyword; $this->display(); } ``` ### 返回搜索關鍵字 ``` Private function _getKeyword () { return $_GET['keyword'] == '搜索微博、找人' ? NULL : $this->_get('keyword'); } ``` ### 檢查是否互相關注 ``` /** * 重組結果集得到是否互相關注與是否已關注 * @param [Array] $result [需要處理的結果集] * @return [Array] [處理完成后的結果集] */ Private function _getMutual ($result) { if (!$result) return false; $db = M('follow'); foreach ($result as $k => $v) { //是否互相關注 $sql = '(SELECT `follow` FROM `hd_follow` WHERE `follow` = ' . $v['uid'] . ' AND `fans` = ' . session('uid') . ') UNION (SELECT `follow` FROM `hd_follow` WHERE `follow` = ' . session('uid') . ' AND `fans` = ' . $v['uid'] . ')'; $mutual = $db->query($sql); if (count($mutual) == 2) { $result[$k]['mutual'] = 1; $result[$k]['followed'] = 1; } else { $result[$k]['mutual'] = 0; //未互相關注是檢索是否已關注 $where = array( 'follow' => $v['uid'], 'fans' => session('uid') ); $result[$k]['followed'] = $db->where($where)->count(); } } return $result; } ``` ## 模板顯示搜索數據 ``` <if condition="isset($result)"> <div id='content'> <if condition='$result'> <div class='view_line'> <strong>用戶</strong> </div> <ul> <foreach name='result' item='v'> <li> <dl class='list-left'> <dt> <img src=" <if condition='$v["face80"]'> __ROOT__/Uploads/Face/{$v.face80} <else/> __PUBLIC__/Images/noface.gif </if>" width='80' height='80'/> </dt> <dd> <a href="">{$v.username|str_replace=$keyword, '<font style="color:red">' . $keyword . '</font>', ###}</a> </dd> <dd> <i class='icon icon-boy'></i>  <span> <if condition='$v["location"]'> {$v.location} <else/> 該用戶未填寫所在地 </if> </span> </dd> <dd> <span>關注 <a href="">{$v.follow}</a></span> <span class='bd-l'>粉絲 <a href="">{$v.fans}</a></span> <span class='bd-l'>微博 <a href="">{$v.weibo}</a></span> </dd> </dl> <dl class='list-right'> <if condition='$v["mutual"]'> <dt>互相關注</dt> <dd class='del-follow' uid='{$v.uid}' type='1'>移除</dd> <elseif condition='$v["followed"]' /> <dt>√ 已關注</dt> <dd class='del-follow' uid='{$v.uid}' type='1'>移除</dd> <else/> <dt class='add-fl' uid='{$v.uid}'>+ 關注</dt> </if> </dl> </li> </foreach> </ul> <div style="text-align:center;padding:20px;">{$page}</div> <else/> <p style='text-indent:7em;'>未找到與<strong style='color:red'>{$keyword}</strong>相關的用戶</p> </if> </div> </if> ```