Yii2 分页 搜索变红

<?php
namespace frontend\controllers;

use Yii;
use yii\web\Controller;
use yii\data\Pagination;
use frontend\models\User;


class Day3Controller extends Controller{
    function actionIndex()
    {
        $search=Yii::$app->request->get('search');       
        $query = User::find()->OrderBy(['id'=>SORT_ASC]);   //user为model名也是表名 id排序
        if($search){
            $query->where(['like','name',$search]);
        }
        //$countQuery = clone $query;
        $pages = new Pagination(['totalCount' => $query->count(),'pageSize'=>'2']);
        $models = $query->offset($pages->offset)->asArray()   //以数组形式 不写为对象
            ->limit($pages->limit)
            ->all();
        //print_r($models);die;
        foreach($models as $k=>$v){
            $models[$k]=str_replace($search,"<font color='red'>".$search."</font>",$v);
        }
        return $this->render('index', [
            'models' => $models,
            'pages' => $pages,
        ]);
    }
}

?>

view

<meta charset="utf-8">
<center>
    <?php
    use yii\helpers\Html;
    use yii\widgets\ActiveForm;

    $form = ActiveForm::begin([
        'action' => 'index.php?r=day3/index',
        'method' => 'get',
    ])
    ?>
    <input type="text" name="search" /><input type="submit" value="搜索" />
    <?php ActiveForm::end() ?>

<table border="1">
    <th>ID</th>
    <th>姓名</th>
    <th>密码</th>
    <?php foreach($models as $model):?>
        <tr>
            <td><?php echo $model['id']?></td>
            <td><?php echo $model['name']?></td>
            <td><?php echo $model['pwd']?></td>
        </tr>
    <?php endforeach?>
</table>

<?php
use yii\widgets\LinkPager;
echo LinkPager::widget([
    'pagination' => $pages,
]);
?>
</center>

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值