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

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

2021-03-13 17:02Love满天星 PHP教程

这篇文章主要介绍了Yii框架结合sphinx,Ajax实现搜索分页功能,结合实例形式分析了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)

									?>