Raw queries in laravel

DB: in eloquent using sql

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

Source: laravel.com

Laravel sql query

use Illuminate\Support\Facades\DB;

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

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

Source: laravel.com

Raw query in laravel with parameters

$someVariable = Input::get("some_variable");
$results = DB::select( DB::raw("SELECT * FROM some_table WHERE some_col = :somevariable"), array(
   'somevariable' => $someVariable,
 ));

DB::statement( 'ALTER TABLE HS_Request AUTO_INCREMENT=:incrementStart', array('incrementStart' => 9999) );

Raw queries in laravel

DB::statement('UPDATE users SET role_id = 1 WHERE role_id IS NULL AND YEAR(created_at) > 2020');

Source: quickadminpanel.com

Similar codes

0 vote168 views1 answer
How to read laravel query string with dash
PHP Laravel
0 vote157 views1 answer
Hasmany relationship with created at in laravel example
PHP Laravel
7 votes200 views2 answers
Laravel mail send to multiple recipients
PHP Laravel
6 votes176 views4 answers
Laravel base url
PHP Laravel
2 votes157 views1 answer
Redirect on validation error laravel to specific section laravel
PHP Laravel
1 vote182 views2 answers
Laravel route group middleware prefix
PHP Laravel
0 vote158 views1 answer
Laravel eloquent get 3 months
PHP Laravel
5 votes196 views1 answer
Limit 1 1 in laravel query
PHP Laravel
2 votes165 views4 answers
Failed to clear cache. make sure you have the appropriate permissions. laravel
PHP Laravel
14 votes158 views3 answers
Change returning datetime timezone to recalculate with user timezone laravel
PHP Laravel