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

3 votes172 views3 answers
Get order details by id woocommerce
PHP
0 vote141 views1 answer
Dynamic modal name appending in laravel
PHP
1 vote175 views3 answers
Laravel model to array
PHP Laravel
1 vote132 views2 answers
Php superglobal
PHP
1 vote124 views1 answer
Php syntax <<<
PHP
0 vote153 views1 answer
Php mail merge docx document
PHP
0 vote155 views1 answer
Laravel check if form has errors
PHP
10 votes145 views3 answers
For loop in laravel
PHP
26 votes135 views6 answers
Random array php
PHP
10 votes180 views4 answers
Laravel migration change column default
PHP