Laravel db facade

TRANSACTON LARAVEL QUERY BUILDER

DB::beginTransaction();

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

Source: stackoverflow.com

DB::transaction

use Illuminate\Support\Facades\DB;

DB::transaction(function () {
    DB::update('update users set votes = 1');

    DB::delete('delete from posts');
});

Source: laravel.com

DB: in eloquent using sql

$results = DB::select('select * from users where id = :id', ['id' => 1]);

Source: laravel.com

Laravel db facade

use Illuminate\Support\Facades\DB;

$users = DB::select('select * from users');

foreach ($users as $user) {
    echo $user->name;
}

Source: laravel.com

Laravel DB facade relations

$antiques = DB::table('antiques')
    ->join('images', 'images.antiques_id', '=', 'antiques.id')
    ->latest()
    ->limit(20)
    ->get(['antiques.*', 'images.path']);

Source: laracasts.com

Similar codes

1 vote196 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
13 votes180 views4 answers
Mysql select last 10 rows
SQL
1 vote217 views1 answer
Does insert into overwrite sql
SQL
0 vote181 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote191 views1 answer
Sqlite explain plan
SQL
5 votes190 views3 answers
Bash: mysql: command not found
SQL
0 vote202 views1 answer
Including parameters in OPENQUERY
SQL
5 votes260 views4 answers
Restart the psql server windows
SQL
14 votes175 views2 answers
How to auto increment in sql
SQL
0 vote178 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL