laravel.md

Laravel

Content

• ORM
  • How to query between two dates using Laravel and Eloquent
  • Update nested json

How to query between two dates using Laravel and Eloquent

 YourModel::query()
    ->where('start', '<=', now()->toDateTimeString())
    ->where('end', '>=', now()->toDateTimeString())
    ->get();

read more stackoverflow

Update nested json

$affected = DB::table('users')
              ->where('id', 1)
              ->update(['options->enabled' => true]);

# note you can use the normal Laravel eloquent (ORM) and it works with updateOrCreate