eloquent or where code example

Example 1: AND-OR-AND + brackets with Eloquent

//mysql query be like this
// ... WHERE (gender = 'Male' and age >= 18) or (gender = 'Female' and age >= 65)

//Eloquent query is
// ...
$q->where(function ($query) {
    $query->where('gender', 'Male')
        ->where('age', '>=', 18);
})->orWhere(function($query) {
    $query->where('gender', 'Female')
        ->where('age', '>=', 65);	
})
//@sujay

Example 2: where () laravel Eloquent

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

Example 3: laravel where and where

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

Tags:

Shell Example

Related