yii 2.0 增删改查 分页 ajax 批删

[php] view plain copy    //关闭csrf    原生代码          public $enableCsrfValidation = false;      添加 接值              $connection = \Yii::$app->db->createCommand()->insert('denglu',$arr)->execute();      查询        $command = \Yii::$app->db->createCommand('SELECT * FROM denglu');         $posts = $command->queryAll();      //删除  接id              $command = \Yii::$app->db->createCommand()->delete('denglu', 'id = '.$id)->execute();        修改  先查询 接值 id            $command = \Yii::$app->db->createCommand("SELECT * FROM denglu where id='$id'");             $post = $command->queryOne();      修改  先接值 修改要的值              $command = \Yii::$app->db->createCommand()->update('denglu', ['name' => $name,'password'=>$password],  'id = '.$id)->execute();      yii2.0      use Yii;      use yii\web\Controller;      use frontend\models\Denglu;      use yii\data\Pagination;      // csrf      <input type="hidden" name="<?= \Yii::$app->request->csrfParam; ?>" value="<?= \Yii::$app->request->getCsrfToken();?>">      //添加       if($re['_csrf-frontend']) {                  unset($re['_csrf-frontend']);                  //print_r($re);die;                  $er1=new Denglu();                  //  print_r($er1);die;                  $er1->name=$re['name'];                  $er1->password=$re['password'];                  $er1->save();              }      查询   分页          $re=Denglu::find();              $pagination = new Pagination([                  'defaultPageSize' => 2,                  'totalCount' => $re->count(),              ]);                    $list = $re->offset($pagination->offset)                  ->limit($pagination->limit)                  ->all();              // print_r($re);die;              return $this->render('list',[                  'list' => $list,                  'pagination' => $pagination,              ]);          }      不带分页查询        $results=goods::find()->asArray()->all();      //        return $this->render("list",["list"=>$results]);      删除           $a=goods::find()->where(["id"=>$id])->one();              $arr=$a->delete();      修改查询      1        $acc=goods::find()->where(["id"=>$id])->asArray()->one();      2        $goods = \Yii::$app->db->createCommand()->update('goods', ["goods_name"=>$arr['goods_name'],"money"=>$arr['money']],"id=".$arr['id'])->execute();      视图层      <?php      use yii\widgets\LinkPager;      ?>          <?= LinkPager::widget(['pagination' => $pagination]) ?>      ajax  批删   视图层          <td><input type="checkbox" name="dom" id="ss" value="<?php echo $v['id']?>"/><?php echo $v['id']?></td>          <input type="checkbox" value="批量删除" onclick="check_del();">批量删chu      function check_del(){              var dom=document.getElementsByName('dom');              var str='';              for(var i=0;i<dom.length;i++){                  if(dom[i].checked==true){                      str=str+','+dom[i].value;                  }              }              str=str.substr(1);         // alert(str)        location.href="?r=lianxi/dele&id="+str;      }       控制器  接受批删的id值        $id=\yii::$app->request->get('id');        $sql="delete from shang where id in ($id)";      $a= \Yii::$app->db->createCommand($sql)->execute();      if($a){          return $this->redirect("?r=lianxi/list");      }else{          echo "删出失败";      }
[html] view plain copy    上传图片   加载类      use yii\web\UploadedFile;      $arr=\yii::$app->request->post();              $file = UploadedFile::getInstanceByName('filename');              $path = 'upload';                                        //设置上传文件的路径              $paths = $path.'/'.rand(1,9999).$file;                    //设置上传文件的路径名称(这里的数据进行入库)              $arr['filename']=$paths;              $file->saveAs($paths,true);                               //保存文件              $goods = \Yii::$app->db->createCommand()->insert('goods', $arr)->execute();              if($goods){                  return $this->redirect("?r=lianxi/list");              }else{                  echo "添加失败";              }       简单的反选全选全不选             <td><input type="checkbox" class="check" name="dom" value="<?php $v['id']?>"/><?php echo $v['id']?></td>       <input type="checkbox" class="quan" value="<?php echo $v['id']?>"/>全选          <input type="checkbox" class="fan" value="<?php echo $v['id']?>"/>全不选          <input type="checkbox" class="bu" value="<?php echo $v['id']?>"/>反选      引进jquery文件 //全选（按钮）          $(function(){              $('.quan').click(function(){                  var ids = $('input:checkbox');                  $.each(ids,function(i,item){                      ids[i].checked=true;                  })              })          })          //全不选          $(function(){              $('.fan').click(function(){                  var ids=$('input:checkbox');                  $.each(ids,function(i,item){                      ids[i].checked=false;                  })              })          })          //反选          $(function(){              $('.bu').click(function(){                  var ids=$('.check');                  $.each(ids,function(i,item){                   ids[i].checked=!ids[i].checked;               })              })          })