laravel not in query
DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();
laravel query when
$users = DB::table('users') ->when($role, function ($query, $role) { $query->where('role_id', $role); }) ->get();
Source: laravel.com
laravel db query
$users = DB::table('users') ->where('votes', '>', 100) ->orWhere(function($query) { $query->where('name', 'Abigail') ->where('votes', '>', 50); }) ->get();
laravel find query
// Retrieve a model by its primary key... $flight = App\Models\Flight::find(1); // Retrieve the first model matching the query constraints... $flight = App\Models\Flight::where('active', 1)->first(); // Shorthand for retrieving the first model matching the query constraints... $flight = App\Models\Flight::firstWhere('active', 1);
Source: laravel.com
laravel find query
return Destination::orderByDesc( Flight::select('arrived_at') ->whereColumn('destination_id', 'destinations.id') ->orderBy('arrived_at', 'desc') ->limit(1) )->get();
Source: laravel.com
laravel find query
use App\Models\Destination; use App\Models\Flight; return Destination::addSelect(['last_flight' => Flight::select('name') ->whereColumn('destination_id', 'destinations.id') ->orderBy('arrived_at', 'desc') ->limit(1) ])->get();
Source: laravel.com