Search by Queries/Bugs/Errors

How to use DB Laravel ?

Created at 22-Aug-2022 , By samar

In this session, we are going to try to solve the "How to use DB Laravel ?" puzzle by using the computer language.

You can use `DB::select('select * from users');` query after importing the `use Illuminate\Support\Facades\DB;` in class after namespace.

app\Http\Controllers\<HomeController>.php

Import DB facade after namespace (namespace App\Http\Controllers;) and before class definition (class HomeController extends Controller) in HomeController class.
```
use Illuminate\Support\Facades\DB;
```
Code in controller method
```
$users = DB::select('select * from users');
return view('home', compact('users'));
```
resources\views\home.blade.php
```
@foreach ($users as $user)
    <p>This is user {{ $user->id }}</p>
@endforeach
```

If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.

Don't forget to share this article! Help us spread the word by clicking the share button below.

We appreciate your support and are committed to providing you valuable and informative content.

We are thankful for your never ending support.

Bootstrap C C++ Cmd CodeIgniter Css Drupal Git Html Java Javascript Jquery Laravel Mongodb Nodejs Php Python React Sql Typescript Wordpress