Answers for "db insert laravel"

laravel db inserr

DB::table('users')->insert([
    'email' => '[email protected]',
    'votes' => 0
]);

laravel not in query

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

laravel wher in

$users = DB::table('users')
                    ->whereIn('id', [1, 2, 3])
                    ->get();

How to request and display data from db in larave

$users = DB::table('users')->get();
foreach($users as $key => $value)
{
	//to get each columns value
	//$value->name
}

laravel db inserr

$id = DB::table('users')->insertGetId(
    ['email' => '[email protected]', 'votes' => 0]
);

TRANSACTON LARAVEL QUERY BUILDER

DB::beginTransaction();

try {
    DB::insert(...);    
    DB::commit();
} catch (\Throwable $e) {
    DB::rollback();
    throw $e;
}