Yii::$classMap['SphinxClient']='@frontend/web/SphinxClient.php';

/** * 話題搜索 * * @author YING * @param void * @return void */public function actionTopic(){  //模擬數據  $studId=2; //用戶id  $classId=2; //班級id  $title=""; //為空  //實例化模型  $studTopic=new StudTopic();  //查詢  $data=$studTopic->find()->select('*')->innerJoin('stud_user','stud_topic.stud_id=stud_user.stud_id')->where(['class_id'=>$classId]);  //實例化分頁類  $pagination=new Pagination(['totalCount' => $data->count()]);  //每頁條數  $pagination->setPageSize(3);  //執行分頁  $topicInfo= $data->offset($pagination->offset)->limit($pagination->limit)->asArray()->all();  //返回值  return $this->render('topicList',['topicInfo'=>$topicInfo,'pages'=>$pagination,'studId'=>$studId,'classId'=>$classId,'title'=>$title]);}/** * coreseek搜索 * * @author YING * @param void * @return void */public function actionSearchTitle(){  //接值  $title=Yii::$app->request->get('t_title');  $classId=Yii::$app->request->get('class_id');  //模擬數據  $studId=2; //用戶id  //coreseek 搜索  $cl = new SphinxClient ();  $cl->SetServer ( '127.0.0.1', 9312);  $cl->SetConnectTimeout ( 3 );  $cl->SetArrayResult ( true );  $cl->SetMatchMode ( SPH_MATCH_ANY);  $res = $cl->Query ( $title, "*" );  //如果存在值  if($res['total']){    $matches=$res['matches'];    foreach($matches as $key => $val){     $tidArray[]=$val['id'];    }  }  //轉化為字符串  $tidStr=isset($tidArray) ? implode(',',$tidArray) : 0;  //實例化模型  $studTopic=new StudTopic();  //查詢  $data=$studTopic->find()->select('*')->innerJoin('stud_user','stud_topic.stud_id=stud_user.stud_id')->where("t_id in ($tidStr)");  //實例化分頁類  $pagination=new Pagination(['totalCount' => $data->count()]);  //每頁條數  $pagination->setPageSize(3);  //執行分頁  $topicInfo= $data->offset($pagination->offset)->limit($pagination->limit)->asArray()->all();  //加載模板  return $this->render('topicList',['topicInfo'=>$topicInfo,'pages'=>$pagination,'studId'=>$studId,'classId'=>$classId,'title'=>$title]);}

<?phpuse yii/widgets/ActiveForm;use yii/helpers/Html;use yii/helpers/Url;use yii/widgets/LinkPager;?><table class="table">  <tr>    <td>標題</td>    <td>作者</td>    <td>發布時間</td>    <td>操作</td>  </tr>  <?php foreach($topicInfo as $key => $val): ?>    <tr id="tr_<?= $val['t_id']?>">      <td><input type="checkbox" tid="<?= $val['t_id']?>"/> <?= $val['t_title']?></td>      <td><?= $val['stud_name']?></td>      <td><?= date('Y-m-d H:i:s',$val['add_time'])?></td>      <?php if($val['stud_id']==$studId):?>      <td><a href="index.php?r=student/update-topic&topic_id=<?= $val['t_id']?>" rel="external nofollow" >編輯</a>||<a href="">刪除</a></td>      <?php else: ?>      <td><a href="">刪除</a></td>      <?php endif; ?>    </tr>  <?php endforeach; ?>  <tr>    <td><input type="button" value="全選/全不選" id="all"/></td>    <td><input type="button" value="反選" id="fan"/></td>    <td><input type="button" value="批刪" id="del"/></td>  </tr></table><?phpecho LinkPager::widget([  'pagination' => $pages,]);?><script src="./css/js/jquery.1.12.min.js"></script><script>  //全選/全不選   var temp=true; //臨時變量  $('#all').click(function(){    $('input[type="checkbox"]').prop('checked',temp);    //取反    temp=!temp;  })  //批刪  $('#del').click(function(){    var checkAll=$('input[type="checkbox"]'); //獲取全部的復選框    var length=checkAll.length; //計算長度    var arr=new Array(); //定義數組    var str=""; //定義字符串    //循環    $.each(checkAll,function(k,v){      //判斷是否選中      if(checkAll[k].checked){        arr.push(checkAll.eq(k).attr('tid'));      }    })    //轉化為字符串    str=arr.join(',');    //ajax    var url="index.php?r=student/delete-all"; //地址    $.get(url,{str:str},function(msg){      if(msg){        //window.location.reload(); //刷新頁面        //節點刪除        $.each(arr,function(k,v){          $('#tr_'+v).remove();        });      }    },'json');  });  //反選  $("#fan").click(function(){    var checkAll=$('input[type="checkbox"]'); //獲取復選    $.each(checkAll,function(k,v){      this.checked=!this.checked;    })  });</script>