Laravel find query

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 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

Laravel find query

$model = App\Models\Flight::where('legs', '>', 100)->firstOr(function () {
        // ...
});

Source: laravel.com

Laravel find query

<?php

$flights = App\Models\Flight::all();

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

Source: laravel.com

Similar codes

0 vote184 views1 answer
Update php version in laravel
PHP Laravel
2 votes158 views1 answer
Go back URL in Laravel
PHP Laravel
3 votes189 views1 answer
Laravel back button
PHP Laravel
39 votes226 views3 answers
Add new column to existing table laravel
PHP Laravel
14 votes164 views6 answers
Laravel Password Validation
PHP Laravel
15 votes167 views1 answer
Laravel skip requirements
PHP Laravel
0 vote167 views1 answer
Laravel get biggest id
PHP Laravel
0 vote165 views1 answer
Laravel nginx permissions
PHP Laravel
0 vote159 views1 answer
'laravel'
PHP Laravel
0 vote163 views1 answer
Laravel new line in session flash message
PHP Laravel