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 vote142 views1 answer
Laravel blade check if yielded content exists
PHP Laravel
1 vote151 views1 answer
Laravel include with variable
PHP Laravel
-1 vote102 views1 answer
Laravel 7 generator
PHP Laravel
13 votes163 views6 answers
How to create model in laravel
PHP Laravel
0 vote141 views1 answer
Laravel compare request domain and app domain and request original domain
PHP Laravel
0 vote137 views1 answer
Laravel: Session message exist while click on browser back button
PHP Laravel
0 vote140 views1 answer
Laravel create table with model command line
PHP Laravel
2 votes144 views1 answer
Laravel get only the Ids of an eloquent arrays
PHP Laravel
12 votes140 views6 answers
Laravel validation
PHP Laravel
19 votes139 views6 answers
Laravel query builder join
PHP Laravel