eloquent where laravel code example

Example 1: eloquent where in

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

Example 2: where () laravel Eloquent

//los signos de igualdad pueden ser: ">=", "<=", "=", ">", "<"
$user = User::where("estado","=",1)->find(10);

Example 3: laravel where

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

Example 4: laravel where

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

Example 5: laravel where and where

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

Tags:

Sql Example