get query in laravel code example

Example 1: laravel get query parameters

$name = $request->query('name', 'Helen');

Example 2: laravel query builder select first

$user = DB::table('users')->where('name', 'John')->first();

var_dump($user->name);

Example 3: 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();

Example 4: laravel find query

foreach ($flights as $flight) {
    echo $flight->name;
}