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

1 vote315 views1 answer
Convert php array to javascript json laravel
PHP Laravel
8 votes308 views3 answers
Laravel check record exists
PHP Laravel
0 vote341 views1 answer
Remove invalid characters from a string laravel
PHP Laravel
1 vote335 views1 answer
Boot method laravel
PHP Laravel
1 vote325 views1 answer
Select sum in laravel
PHP Laravel
0 vote328 views3 answers
Laravel validation alphanumeric with spaces
PHP Laravel
0 vote338 views1 answer
Laravel: Validation unique on update
PHP Laravel
0 vote320 views1 answer
Optimize clear laravel not working
PHP Laravel
1 vote340 views1 answer
Laravel php artisan make:controller in subfolder
PHP Laravel
23 votes281 views6 answers
Laravel 6 auth
PHP Laravel