SQL queries from database with Laravel

Question

I'm using Laravel and trying to do an SQL query from my Controller in a public function, but I'm really confused where I would put my table in the argument and if quotes go around the argument. Here is my code

 public function selectMethod(){
    $results = DB::select('select firstname from people where id = 1');
    print_r($results);
    return view('pages.selectMethod');
}

table is called people

My .env is configured to my database correctly and I get this error

FatalErrorException in AboutController.php line 90: Class 'App\Http\Controllers\DB' not found

Thanks !

Only add ----use DB;---- namespace

Nazmul Hasan
– Nazmul Hasan

2017-07-09 05:11:01 +00:00
Commented Jul 9, 2017 at 5:11 — Nazmul Hasan
– Nazmul Hasan, Commented Jul 9, 2017 at 5:11
use \DB instead of DB

Bishnu Bhusal
– Bishnu Bhusal

2017-07-09 05:59:15 +00:00
Commented Jul 9, 2017 at 5:59 — Bishnu Bhusal
– Bishnu Bhusal, Commented Jul 9, 2017 at 5:59

Seifeddine Besbes · Accepted Answer · 2017-07-09 04:28:41Z

1

you should add use Illuminate\Support\Facades\DB; at the top of your page for example :

    <?php

namespace App\Http\Controllers;

use Illuminate\Support\Facades\DB;
use App\Http\Controllers\Controller;

class UserController extends Controller
{
    /**
     * Show a list of all of the application's users.
     *
     * @return Response
     */
    public function index()
    {
        $users = DB::table('users')->get();

        return view('user.index', ['users' => $users]);
    }
}

answered Jul 9, 2017 at 4:28

Seifeddine Besbes

4042 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Abhishek · Accepted Answer · 2017-07-09 05:58:20Z

1

Your error clearly states: Class 'App\Http\Controllers\DB' not found

Hence just use DB in your class. Add:

use DB;

At the top of the file just below the namespace line.

Also, I would suggest you to use Eloquent for your queries. It will make your life a lot easier and your code a lot beautiful.

answered Jul 9, 2017 at 5:58

Abhishek

3,99923 silver badges43 bronze badges

Collectives™ on Stack Overflow

SQL queries from database with Laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related