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

0 vote172 views1 answer
Variable 'sql_mode' can't be set to the value of 'REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( @@sql_mode'</p><p>SELECT * FROM `users` WHERE `username` = 'yth19203' ORDER BY `id` DESC</p><p>Filename: models/Crud.php</p&
PHP
2 votes153 views2 answers
Show uploaded image in php
PHP
63 votes143 views6 answers
Laravel artisan clear cache
PHP
0 vote177 views3 answers
Laravel package console command
PHP Laravel
0 vote139 views1 answer
Foreach tableau php
PHP
11 votes138 views5 answers
Laravel check auth
PHP
3 votes159 views4 answers
Input if not null laravel
PHP Laravel
0 vote137 views1 answer
Php median
PHP
0 vote135 views1 answer
<a href="<?php echo base_url(); ?>">somelink</a>
PHP
11 votes149 views3 answers
Get the full url in php
PHP