Yii框架结合sphinx,Ajax实现搜索分页功能示例

本文实例讲述了Yii框架结合sphinx,Ajax实现搜索分页功能的方法。分享给大家供大家参考，具

本文实例讲述了Yii框架结合sphinx,Ajax实现搜索分页功能的方法。分享给大家供大家参考，具体如下：

效果图:

控制器:

<?php
namespace backend\controllers;
use Yii;
use yii\web\Controller;
use yii\data\Pagination;
use SphinxClient;
use yii\db\Query;
use yii\widgets\LinkPager;
use backend\models\Goods;
class SouController extends Controller
{
 //显示搜索页面
 public function actionIndex()
 {
 //接受搜索值
 $sou=Yii::$app->request->get('sou');
 $p1=Yii::$app->request->get('p1');
 $p2=Yii::$app->request->get('p2');
 //echo $sou.$p1.$p2;die;
 //sphinx搜索
 $cl = new SphinxClient();
 $cl -> SetServer('127.0.0.1',9312);
 $cl -> SetConnectTimeout(3);
 $cl -> SetArrayResult(true);
 if($sou)
 {
 //只搜索条件
 $cl -> SetMatchMode(SPH_MATCH_ANY);
 }
 else
 {
 //全局扫描
 $cl -> SetMatchMode(SPH_MATCH_FULLSCAN);
 }
 //设置价格(注意:创建索引时,价格属性定义为int)
 if($p1&&$p2)
 {
 $cl->SetFilterRange('price',$p1,$p2);
 }
 //搜索查询关键字
 $res = $cl->Query($sou,"mysql_goods");
 //ajax分页
 $model=new Goods();
 foreach ($res['matches'] as $key => $val)
 {
 $ids[] = $val['id'];
 }
 //查询条件数据
 $query = $model->find()->where(['id'=>$ids]);
 $countQuery = clone $query;
 $pages = new Pagination(['totalCount' => $countQuery->count(),'defaultPageSize'=>3]);
 //分页
 $models = $query->offset($pages->offset)
 ->limit($pages->limit)
 ->all();
 //关键字变红
 foreach($models as $k=>$v)
 {
 $models[$k]['goods_name']=str_replace("$sou","<font color='red'>$sou</font>",$v['goods_name']);//将关键字替换成红色字体
 }
 //显示列表,分配数据
 return $this->render('index', [
 'res' => $models,
 'pages' => $pages,
 'sou'=>$sou,
 'p1'=>$p1,
 'p2'=>$p2
 ]);
 }
}
?>

视图层:

<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\widgets\LinkPager;
$form = ActiveForm::begin([
 'action' => 'index.php?r=sou/index',
 'method' => 'get'
]) ?>
<center>
<div id="list">
 商品名称:
 <input type="text" name="sou" value="<?php echo $sou?>">
 价格区间:
 <input type="text" name="p1" value="<?php echo $p1?>">---<input type="text" name="p2" value="<?php echo $p2?>">
 <input type="submit" value="搜索">
 <table border="1" style="width:500px;">
 <tr>
 <th>ID</th>
 <th>商品名称</th>
 <th>商品价格</th>
 </tr>
 <?php foreach($res as $key=>$v){?>
 <tr>
 <td><?php echo $v['id'];?></td>
 <td><?php echo $v['goods_name'];?></td>
 <td><?php echo $v['price'];?></td>
 </tr>
 <?php }?>
 </table>
<!--分页-->
<?= LinkPager::widget(['pagination' => $pages]) ?>
</div>
</center>
<?php ActiveForm::end() ?>
<!--显示-->
<?php $this->beginBlock('test2') ?>
 $(document).on('click', '.pagination a', function(e)
 {
 //阻止page显示，看地址
 e.preventDefault();
 var href = $(this).attr('href');
 $.post(href,function(msg){
 $('#list').html(msg);
 })
 });
<?php $this->endBlock();
$this->registerJs($this->blocks['test2'] , yii\web\View::POS_END)
?>