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

4 votes179 views1 answer
How to check query execution time in laravel
PHP Laravel
0 vote208 views1 answer
Laravel route limit parameter
PHP Laravel
1 vote162 views1 answer
Delete record using laravel
PHP Laravel
4 votes228 views3 answers
Get current route in blade laravel
PHP Laravel
0 vote195 views2 answers
Insert multiple rows laravel
PHP Laravel
9 votes191 views4 answers
Laravel soft delete example
PHP Laravel
-1 vote168 views1 answer
Clear Caching of Queries Laravel Specific Model Cache
PHP Laravel
0 vote194 views1 answer
Laravel hasMany with join
PHP Laravel
1 vote192 views1 answer
Laravel child relation order by desc
PHP Laravel
2 votes174 views3 answers
Laravel web php request to redirect to another page
PHP Laravel