php model 操作

// 查询
        public function get() {

            // 静态方法

            {
                $res = News::column('id','title','content');
                var_dump($res);
            }

            {
                $res = News::where('id', 1)->value('content');
                var_dump($res);
            }

            {
                $res = News::where('id','>','4')->select();
                var_dump($res);
            }

            {
                $res0 = count(News::all(function ($query){ // 参数闭包
                    $query->where('id > 4');
                }));
                var_dump($res0);
            }

            {
                $res0 = News::all('1,2,3'); // 参数主键
                var_dump($res0);
            }

            // 实例方法
            {
                $news = new News();
                $res1 = $news->field(['id', 'title','image','read_count'])->where('id > 5')->find();
                var_dump($res1->toArray());
            }

            {
                $news = model('news');
                $res2 = $news::get('1');
                var_dump($res2);
            }

            {
                $news = Loader::model('News');
                $res3 = $news::get('1');
                var_dump($res3);
            }
        }

// 增加
        public function add() {

            // 静态方法
            {
                $res = News::create(
                  [
                      'title' => '123',
                      'content' => 'content',
                      'image' => 'image',
                      'create_time' => time(),
                  ]
                );
                var_dump($res->id); // 自增id，主键
                var_dump($res->toArray());
            }

            {
                // 以外的字段 参数true
                $res = News::create(
                    [
                        'title' => '123',
                        'content' => 'content',
                        'image' => 'image',
                        'create_time' => time(),
                        'demo' => 'demo'
                    ],true
                );
                var_dump($res->id); // 自增id，主键
                var_dump($res->toArray());
            }

            {
                // 限制字段的增加
                $res = News::create(
                    [
                        'title' => '123',
                        'content' => 'content',
                        'image' => 'image',
                        'create_time' => time(),
                        'demo' => 'demo'
                    ],['title', 'content']
                );
                var_dump($res->id); // 自增id，主键
                var_dump($res->toArray());
            }

            // 实例方法
            {
                $news = new News();
                $news->title = 'title';
                $news->content = 'content_content';
                $news->save();
            }


            {
                $news = new News();
                $res = $news->allowField(['title','content'])
                    ->save([
                        'title' =>  'title',
                        'content' => 'content',
                        'demo' => 123
                    ]);
                var_dump($res);
            }


            {
                // 批量插入
                $news = new News();
                $data = [];
                for ($i = 0; $i < 10; $i ++) {
                    $data[] = [
                        'title' => "title{$i}",
                        'content' => "content{$i}",
                        'create_time' => time(),
                    ];
                }
                $res = $news->saveAll($data);
                var_dump($res);
            }
        }

public function update() {

            {
                $res = News::where('id = 1')
                    ->update(['title' => 'title1']);
                var_dump($res);
            }

            {

                $res = News::update([
                    'id' => 1,
                    'title' => 'title2'
                ]);

                var_dump($res->id);
            }

            {
                $res = News::update([

                    'title' => 'title3'
                ],['id' => 1]);

                var_dump($res->title);
            }

            {
                $res = News::update([
                    'title' => 'title4'
                ],function ($query) {
                    $query->where('id = 1');
                });

                var_dump($res->title);
            }

            {
                $news = News::get('1');
                $news->title = 'title123';
                $res = $news->save();
                var_dump($res);
            }

            {
                $res = News::update(['content' => 'content50'],['id' => 50,'id' => 49]);
                var_dump($res->content);
            }

            {
                $news = new News();
                $res = $news->save(
                    ['content' => 'content50'],
                    ['id' => 51]
                );

                var_dump($res);
            }

        }

public function delete() {

            {
                $res = News::destroy(1); // 主键
                var_dump($res);
            }

            {
                $res = News::destroy(['content' => 'content']);
                var_dump($res);
            }

            {
                $news = News::get(3);
                if ($news) {
                    $res = $news->delete();
                    var_dump($res);
                }
            }

            {
                $res = News::where(['id' => 4])
                    ->delete();
                var_dump($res);
            }
            
            // 删除所有数据
            {
                $res = News::where([1=>1])
                    ->delete();
                var_dump($res);
            }
        }