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 votes348 views1 answer
How to check query execution time in laravel
PHP Laravel
6 votes355 views1 answer
How to add new column in table laravel
PHP Laravel
0 vote356 views1 answer
Laravel replace white space with dash
PHP Laravel
0 vote343 views1 answer
Laravel where between cluse
PHP Laravel
5 votes374 views3 answers
Delete all rows in table laravel foreign key
PHP Laravel
0 vote343 views1 answer
Set laravel local time to indonesia
PHP Laravel
0 vote373 views1 answer
Laravel custom abort message
PHP Laravel
4 votes319 views4 answers
Search in laravel 8
PHP Laravel
2 votes397 views1 answer
Call to undefined method JeroenNoten\\LaravelAdminLte\\Helpers\\MenuItemHelper::isSearchBar(
PHP Laravel
8 votes363 views4 answers
Laravel unique validation on multiple columns
PHP Laravel