用模型对json字段进行查询

student.php中设置json类型字段

class student extends Model
{
    //
    public function scopeThinkphp($query)
    {
        $query->where('name','路飞')->field('id,name');
    }
    public function scopeNumber($query)
    {
        $query->where('number','>',20)->limit(10);
    }
     //设置json类型字段
    protected $json = ['info'];
}

1.写入json数据

$user = new student;
$user->name = 'thinkphp';
$user->info = ['email'=>'thinkphp@qq.com','nickname'=>'流年'];
$select=$user->save();
dump($select);

2.查询json数据

$user = student::find(62);
echo $user->name;
echo '<br><br>';
echo $user->info->email;
echo '<br><br>';
echo $user->info->nickname;
echo '<br><br>';

3.更新json数据

$user = student::find(62);
$user->name = '钢铁侠';
$user->info->email = '123456@qq.com';
$user->info->nickname = '无敌';
$select=$user->save();
dump($select);