Yii的增删改查-分页

来源：互联网发布：淘宝客服售前做什么编辑：程序博客网时间：2024/04/30 08:51

<?php
namespace frontend\controllers;
use Yii;
use yii\base\InvalidParamException;
use yii\web\BadRequestHttpException;
use yii\web\Controller;
use yii\filters\VerbFilter;
use yii\filters\AccessControl;
use yii\db\Query;
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 Day1Controller extends Controller {
       //添加
   public function actionIndex(){
       $request = Yii::$app->request->post();
       if($request){
           unset($request['_csrf']);
           $res = Yii::$app->db->createCommand()->insert("day1",$request)->execute();
           return $this->redirect('index.php?r=day1/show');
       }else{
           return $this->render('index');
       }
   }
       //展示    分页
   public function actionShow(){
        $query=new Query();
        $data=$query->from("day1")->all();
        $count=count($data);
        // var_dump($count);die;
        $pagination = new Pagination(['totalCount' => $count]);
        $pagination->setPageSize(5);
        $list = $query
        ->offset($pagination->offset)
        ->limit($pagination->limit)
        ->all();
       //print_r($data);
        return $this->render("select",['list'=>$list,'pagination' =>
           $pagination]);
    }
       //删除
   public function actionDel(){
       $id = $_GET['id'];
       $res = Yii::$app->db->createCommand()->delete('day1',['id'=>$id])->execute();
       if($res){
           Yii::$app->session->setFlash('success', '删除成功');
           return $this->redirect('index.php?r=day1/show');
       }else{
           Yii::$app->session->setFlash('success', '删除失败');
           return $this->redirect('index.php?r=day1/show');
       }
   }
       //修改
   public function actionAlter(){
       //显示展示页面
       $id = Yii::$app->request->get("id");
       if($id){
           // var_dump($id);die;
           $list = Yii::$app->db->createCommand('SELECT * FROM day1 WHERE id='.$id)->queryOne();
           // var_dump($list);die;
           return $this->render("alter",['list'=>$list]);
       }
       $request = Yii::$app->request->post();
       if($request){
           // var_dump($request);die;
           // 修改
           unset($request['_csrf']);
           $res = Yii::$app->db->createCommand()->update('day1',$request,"id=".$request["id"])->execute();
           if($res){
               Yii::$app->session->setFlash('success', '修改成功');
               return $this->redirect('index.php?r=day1/show');
           }else{
               Yii::$app->session->setFlash('success', '修改失败');
               return $this->redirect('index.php?r=day1/show');
           }
       }


   }

}
?>

0 0