Answers for "laravel eloquent where and"

laravel eloquent get first

// return first row by id
$user = App\User::where('id',$id)->first();
// or return directly a field
$userId = App\User::where(...)->pluck('id');

laravel where multiple conditions on single colmn

//laravel
// here, i have used two different where condition on a single column
$today = Carbon::today();
$data = Users::where('type',1)
        ->where(function($query) use ($today) {
            return $query->whereDate('updated_at','!=', $today)
            ->orWhere('updated_at',null);
         })
         ->get();

where in laravel

$users = Users::whereIn('id', array(1, 2, 3))->get()

laravel where

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

laravel where

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

laravel where and where

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