16_ThinkPHP通过Model方式对数据进行增删

<?php


namespace app\controller;


use app\Model\User;
use think\Db;

class ModelCrud
{
    //model两种调用方法，静态调用和实例调用
    public  function  index(){

        //save()新增
//        $data = [
//            'username'         => '小白鼠',
//            'gender'          =>   '男',
//            'email'           => 'xbs@zcv.net.cn',
//            'nicename'        => '无毛猫',
//            'age'             => 120,
//            'Create_Time'      => date('Y-m-d H:m:s')
//        ];
//        $user = new User();

        //saveAll
//        $data = [
//            [
//            'username'         => '小白鼠1',
//            'gender'          =>   '男',
//            'email'           => 'xbs@zcv.net.cn',
//            'nicename'        => '无毛猫',
//            'age'             => 120,
//            'Create_Time'      => date('Y-m-d H:m:s')
//            ],
//            [
//                'username'         => '小白鼠2',
//                'gender'          =>   '男',
//                'email'           => 'xbs@zcv.net.cn',
//                'nicename'        => '无毛猫',
//                'age'             => 120,
//                'Create_Time'      => date('Y-m-d H:m:s')
//            ],
//        ];
        //删除delete 1。先拿到要删的model对象，然后执行delete方法
       // $user = User::where('userid',16)->find();
        // $user->delete();



        //通过静态方法destroy()删除

        //User::destroy('15');// 默认主键ID必须叫ID，如果不是，请去model\User.php里设置$pk


        //修改一条  先通过get()拿到模型，然后修改，也可以通过where->find()
//        $user= User::get(13);
        $user['username']   =   '大花猫';
        $user['email']       =   'dhm@email.com';
        $user['nicename']   =   '无毛大花猫';

        $user->save();
///
///         //简写save([更新数据],[where条件])
//            $user=new User();
//            $user->save(['username'=>'简化大花猫'],['uid'=>'12']);


        // 一次性修改多条saveAll()
//        $user = new User();
//        //数组的第一个参数，一定要是主键id
//        $user->saveAll([
//            ['uid'=>10,'username'=>'大花猫10','nicename'=>'无毛大花猫10'],
//            ['uid'=>11,'username'=>'大花猫11','nicename'=>'无毛大花猫11'],
//            ['uid'=>12,'username'=>'大花猫12','nicename'=>'无毛大花猫12']
//
//
//        ]);

        //静态方法更新
//        User::where('uid',1)
//            ->update([
//                'username'      =>      '我是第一民',
//                'email'         =>      'iamfirstp@ppp.p'
//            ]);


        //显示新增  isUpdate(true)

//        $user= User::get(13);
//        $user['username']   =   '大花猫13';
//        $user['email']       =   'dhm13@email.com';
//        $user['nicename']   =   '无毛大花猫13';
//
//        $user->isUpdate(true)->save();//只代码端能看到效果。
//
//
//       return json(User::select());

        //查询单条
        //1.get(id)
        //$data= User::get(13);
        //2. where(条件)->find()
//        $data = User::where('uid','=',10)
//            ->find();


        //多条
        //1。all('id1,id2,id3')or all([id1,id2,id3])
        //$data= User::all('10,11,12');
        //$data= User::all([1,11,12]);

        //2.链式查询where()->order()->select()
        //$data= User::where('username','like','%猫%')->select();

        //3.动态查询getByXXX()
//        $user = new User();
//        $data = $user ->getByUid(1)->find();

        //4.聚合函数sum(),count()
        $user = new User();
        $data = $user ->count('username');
        $data = $user ->sum('age');
        return json($data);




    }

}