yii增删改查搜索分页

<?php
namespace frontend\controllers;

use Yii;
use yii\base\InvalidParamException;
use yii\web\BadRequestHttpException;
use yii\db\Query;
use yii\web\Controller;
use yii\filters\VerbFilter;
use yii\filters\AccessControl;
use common\models\LoginForm;
use frontend\models\PasswordResetRequestForm;
use frontend\models\ResetPasswordForm;
use frontend\models\SignupForm;
use frontend\models\ContactForm;
use yii\data\Pagination;


/**
 * Site controller
 */
class TestController extends Controller{
    public function actionShow(){
        $query=new Query();
        $data=$query->from("user")->all();
        $count=count($data);
        $pagination = new Pagination(['totalCount' => $count]);
        $pagination->setPageSize(3);
        $model = $query->offset($pagination->offset)->limit($pagination->limit)->all();
//        print_r($data);
        return $this->render("show.php",['data'=>$data, 'model' => $model,'pagination' => $pagination,]);
    }
    public function actionAdd(){
       $request=Yii::$app->request;
//        print_r($request);
        if($request->isPost){
            $data=$request->post();
//            print_r($data);
//            die;
            unset($data['_csrf-frontend']);
            $res=Yii::$app->db->createCommand()->insert("user",$data)->execute();
            if($res){
                $this->redirect("?r=test/show");
            }
        }else{
           return $this->render("add.php");
        }
    }
    public function actionDel(){
        $request=Yii::$app->request;
        $id=$request->get("id");
//        echo $id;
        $res=Yii::$app->db->createCommand()->delete("user","id=$id")->execute();
        if($res){
            $this->redirect("?r=test/show");
        }
    }
    public function actionUp(){
       $request=Yii::$app->request;
        $id=$request->get("id");
        $query=new Query();
        $data=$query->from("user")->where("id=$id")->one();
//        print_r($data);
        if($request->isPost){
            $data=$request->post();
            unset($data['_csrf-frontend']);
            $res=Yii::$app->db->createCommand()->update("user",$data,"id=$id")->execute();
            if($res){
                $this->redirect("?r=test/show");
            }
        }else{
            return $this->render("up.php",['data'=>$data]);
        }
    }
}