how to use where in laravel eloquent code example

Example 1: laravel fillable

/**
     * The attributes that are mass assignable.
     */
    protected $fillable = [
      					   'title',
                           'slug',
                           'body',
                           'image',
                           'published',
                           'comments_open'
                          ];

Example 2: laravel create or update

// If there's a flight from Oakland to San Diego, set the price to $99.
// If no matching model exists, create one.
$flight = App\Models\Flight::updateOrCreate(
    ['departure' => 'Oakland', 'destination' => 'San Diego'],
    ['price' => 99, 'discounted' => 1]
);

Example 3: laravel where

$users = DB::table('users')
                ->whereMonth('created_at', '12')
                ->get();

Example 4: laravel update

$flight = App\Models\Flight::find(1);

$flight->name = 'New Flight Name';

$flight->save();

Example 5: laravel scope query

$model = App\Models\Flight::where('legs', '>', 100)
            ->firstOr(['id', 'legs'], function () {
                // ...
            });

Example 6: laravel where and where

Table::where('Column', Value)->where('NewColumn', Value)->get();

Tags:

Php Example