Insertgetid laravel 8

Laravel not in query

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

Insertgetid laravel 8

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
	$id = DB::table('users')->insertGetId(
            ['email' => 'john@example.com','name' => 'john']
        );
}

Source: nicesnippets.com

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

DB::table('users')->get();

DB::table('users')->where('name', Input::get('name'))->get();

Source: stackoverflow.com

Similar codes

16 votes174 views6 answers
Laravel redirect back
PHP Laravel
0 vote151 views0 answer
Laravel
PHP Laravel
0 vote186 views3 answers
Laravel pagination with search filter
PHP Laravel
0 vote199 views1 answer
Laravel collection except
PHP Laravel
0 vote164 views1 answer
$this- attribute laravel
PHP Laravel
2 votes180 views1 answer
Laravel delete relationship data
PHP Laravel
43 votes183 views6 answers
Laravel create migration add column
PHP Laravel
7 votes196 views3 answers
Laravel random query
PHP Laravel
0 vote180 views1 answer
Check if variable is set and not empty laravel
PHP Laravel
0 vote194 views1 answer
Laravel validate number to be at least 3 digits
PHP Laravel