Answers for "laravel eloquent find all"

laravel firstorcreate

// Retrieve flight by name, or create it if it doesn't exist...
$flight = App\Flight::firstOrCreate(['name' => 'Flight 10']);

// Retrieve flight by name, or create it with the name, delayed, and arrival_time attributes...
$flight = App\Flight::firstOrCreate(
    ['name' => 'Flight 10'],
    ['delayed' => 1, 'arrival_time' => '11:30']
);

// Retrieve by name, or instantiate...
$flight = App\Flight::firstOrNew(['name' => 'Flight 10']);

// Retrieve by name, or instantiate with the name, delayed, and arrival_time attributes...
$flight = App\Flight::firstOrNew(
    ['name' => 'Flight 10'],
    ['delayed' => 1, 'arrival_time' => '11:30']
);

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 eloquent get all records where

// Get all rows from Eloquent model
Model::get();
	//Get all the cars
    $cars = App\Models\Cars::get();

// Get all rows from Eloquent model where column matches the given value
Model::where('column', {value})->get();
	//Get all the blue cars
	$blue_cars = App\Models\Cars::where('color', 'blue')->get();
	//Get all the green cars
	$looking_for = 'green';
	$green_cars = App\Models\Cars::where('color', $looking_for)->get();

// Get all rows from Eloquent model where column is matched conditionally
Model::where('column', {condition}, {value})->get();
	//Get all the antique cars
    $antiques = App\Models\Cars::where('year', '<=', 2000)->get();

// Get all rows from Eloquent model with multiple where conditions
	//Get all the green antique cars
    $green_antiques = App\Models\Cars::where(
      [
        	['color', 'green'],
        	['year', '<=', 2000],
      ]
    )->get();

// For very large data sets use cursor() rather than get();
Model::where('column', {value})->cursor();
// Or limits
Model::where('column', {value})->limit({n})->get();
	// Get the first 10 green cars
	$some_green_cars = 
      App\Models\Cars::where('color', 'green')->limit(10)->get();