TP5.1模型 增删改查

    
    public  function mocha() //模型查询
    {
            // 取出主键为5的数据
            $Attr = Attr::get(5);
            echo $Attr->name;
        


            // 使用查询构造器查询满足条件的数据
            $Attr = Attr::where('name', 'thinkphp')->find();
            echo $Attr->name;


            // 使用查询构造器查询满足条件的数据
            $Attr = Attr::where('name', 'thinkphp')->findOrEmpty();

        // 根据主键获取多个数据
        $list = Attr::all('15,16,17');
        //或者使用数组
        $list = Attr::all([1,2,3]);
        //对数据集进行遍历操作
        foreach($list as $key=>$user)
        {
            echo $user->id."<br/>";
        }    


            // 使用查询构造器查询
            $list = Attr::where('status', 1)->limit(3)->order('id', 'asc')->select();
            foreach($list as $key=>$user)
            {
                echo $user."<br/>";
            }



            // 使用查询构造器查询
            $list = Attr::where('status', 1)->limit(3)->order('id', 'asc')->all();
            foreach($list as $key=>$user)
            {
                echo $user."<br/>";
            }
                        

            $Attr=    Attr::where('id',10)->find();
            $Attr=    Attr::where('status',1)->order('id','desc')->select();
            $Attr=     Attr::where('status',1)->limit(10)->select();


            // 获取某个用户的积分
            $Attr=    Attr::where('id',8)->value('status');
            // 获取某个列的所有值
            $Attr=    Attr::where('status',1)->column('name');
            // 以id为索引
            $Attr=    Attr::where('status',1)->column('name','id');


            //动态查询
            // 根据name字段查询用户
            $Attr = Attr::getByName('thinkphp');
            //根据email字段查询用户
            $Attr = Attr::getByColor('thinkphp@qq.com');

            //聚合查询
                $Attr =Attr::count();//count统计数量，参数是要统计的字段名（可选）
            $Attr =Attr::where('status','>',0)->count();
             $Attr =Attr::where('status',1)->avg('id');//avg获取平均值，参数是要统计的字段名（必须）
             $Attr =Attr::where('status',1)->sum('id');//sum获取总值，参数是要统计的字段名（必须）
            $Attr =Attr::max('id');    //max获取最大值

                //数据分批处理  
                $Attr =    Attr::chunk(100,function($users) {
                    foreach($users as $user){
                        // 处理user模型对象
                    }
                });


                //使用游标查询
                foreach(Attr::where('status', 1)->cursor() as $user){
                    echo $user->name."<br/>";
                }


                //查询缓存 
                //get方法和all方法的支持使用查询缓存，可以直接在第二个参数传入true表示开启查询缓存。
                $Attr = Attr::get(1,true);
                $Attr  = Attr::all('1,2,3',true);
                //如果要设置缓存标识，则必须在第三个参数传入缓存标识。
                $Attr = Attr::get(1,'','user');
                $Attr  = Attr::all('1,2,3','','user_list');


                $Attr           = new Attr;
                $Attr->name     = 'thinkphp';
                $Attr->color    = 'thinkphp@qq.com';
                $Attr->create_time=time();  
                $Attr->save();
                // 从主库读取数据
                $Attr->master()->get($Attr->id);


                $Attr           = new Attr;
                $Attr->name     = 'thinkphp';
                $Attr->color    = 'thinkphp@qq.com';
                $Attr->create_time=time();
                $Attr->save();
                // 从主库读取数据
                $Attr->readMaster(true)->get($Attr->id);


                // var_dump($Attr);
                 return json($Attr);




        
    }
    public function model() //模型删除
    {
        // 删除ID为11
        $user = Attr::get(11);
        $data=$user->delete();

         //删除主键 为 3
             $data =Attr::destroy(3);   
        //支持批量删除多个数据
        $data =Attr::destroy('1,2,3');
        //或者
        $data =Attr::destroy([1,2,3]);
     



        $data=    Attr::where('id','=',4)->delete();         
        
     var_dump($data);
        // return json($data);
    }

    public function mogeng()//模型更新
    {
        $user = Attr::get(11);
        $user->name     = 'thinkphp';
        $user->color    = 'thinkphp@qq.com';
        $data=     $user->save();

        $user = Attr::where('status',2)
                ->where('name','liuchen')
                ->find();
        $user->name     = 'php';
        $user->color    = 'thinkphp@qq.com';
        $data= $user->save();

        $user = Attr::get(11);
        $user->name     = 'thinkphp';
        $user->color    = 'thinkphp@qq.com';
        $user->status    =  Db::raw('status+1');
         $data= $user->save();

            $user = Attr::get(11);
            $user->name     = 'tp';
            $user->color    = 'tp@qq.com';
            $user->status    = ['inc', 1];
            $data=$user->save();


            $user           = new Attr;    //新增
            $user->id='11';        
            $user->name     = 'thinkphp';
            $user->color    = 'thinkphp@qq.com';
            $user->create_time= time();
            $data = $user->save();
            echo $user->id;


        return json($data);
    }

    public function mozeng()//模型增加
    {

        //第一种是实例化模型对象后赋值并保存：
        $user           = new Attr;
        $user->name     = 'thinkphp';
        $user->color    = 'thinkphp@qq.com';
        $data= $user->save();

        $user = new Attr;
        $data=$user->save([
            'name'  =>  'thinkphp',
            'color' =>  'thinkphp@qq.com',
            'create_time'=>time()
        ]);


        //通过外部 post传值提交赋值给模型，并且希望指定某些字段写入，可以使用：
        $user = new Attr;
        // // post数组中只有name和color字段会写入
        $user->allowField(['name','color'])->save($_POST);
        // //  || 或者下面

        $user = new Attr;
        // // 过滤post数组中的非数据表字段数据
        $data = Request::only(['name','email']);
        $user->save($data);


            $user           = new Attr;
            $user->name     = 'thinkphp';
            $user->color    = 'thinkphp@qq.com';
            $user->create_time = time();
            $data=     $user->replace()->save();
            

            //获取自增ID
            $user           = new Attr;
            $user->name     = 'thinkphp';
            $user->color    = 'thinkphp@qq.com';
            $user->create_time= time();
            $data = $user->save();
            
            echo $user->id;

        //批量新增
            $user = new Attr;
            $list = [
                ['name'=>'thinkphp','color'=>'thinkphp@qq.com','create_time'=>time()],
                ['name'=>'onethink','color'=>'onethink@qq.com','create_time'=>time()],
            ];
            $data = $user->saveAll($list);



            //还可以直接静态调用create方法创建并写入：
            $user = Attr::create([
                'name'  =>  'thinkphp',
                'color' =>  'thinkphp@qq.com',
                'create_time'=>time()
            ]);
            echo $user->name."<br/>";
            echo $user->color."<br/>";
            echo $user->id;   //获取自增ID


        
                $user = Attr::create([
                    'name'  =>  'thinkphp',
                    'color' =>  'thinkphp@qq.com',
                    'create_time'=>time()
                ], ['name', 'color','create_time']);
                echo $user->name."<br/>";
                echo $user->color."<br/>";
                echo $user->id."<br/>"; // 获取自增ID
                echo $user->create_time; 


                $user = User::create([
                    'name'  =>  'thinkphp',
                    'email' =>  'thinkphp@qq.com'
                ], ['name','email'], true);


            // var_dump($data); boolean 类型
            return json($data); //boolean  类型
    }