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 vote239 views2 answers
Create storage link laravel without terminal server
PHP Laravel
0 vote218 views1 answer
Import separate graphql file laravel
PHP Laravel
0 vote244 views1 answer
Laravel many to many migration
PHP Laravel
0 vote254 views1 answer
Laravel route limit parameter
PHP Laravel
0 vote227 views1 answer
Laravel composer anctum
PHP Laravel
1 vote216 views1 answer
Laravel makeHidden
PHP Laravel
11 votes243 views3 answers
How to remove composer package in laravel
PHP Laravel
12 votes226 views6 answers
Run seeder in migration laravel
PHP Laravel
4 votes247 views1 answer
Refresh a specific migration in laravel
PHP Laravel
0 vote180 views1 answer
How to store multiple value in session in laravel
PHP Laravel