Laravel fetch data from mysql table

Question

By using the following code on my controller page, I am trying to fetch data from mysql database.

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;

class productscontroller extends Controller
{
    public function index()
    {
        $Products = DB::table('products_description')->get();
        return view('products.index',compact($Products));
    }   
}

and receiving the following error.

FatalErrorException in productscontroller.php line 12:
Class 'App\Http\Controllers\DB' not found

I am following a laracast tutorial to fetch the data but not sure what I am doing wrong.

curious_coder · Accepted Answer · 2016-06-25 14:15:25Z

2

Either put use DB; or $Products = \DB::table('products_description')->get();

answered Jun 25, 2016 at 14:15

curious_coder

2,4784 gold badges28 silver badges45 bronze badges

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

15 Comments

Murtaza Over a year ago

with $Products = \DB::table('products_description')->get(); it is giving the following error PDOException in Connector.php line 55: SQLSTATE[HY000] [1045] Access denied for user 'homestead'@'localhost'

curious_coder Over a year ago

Edit your .env file .. Provide database, username and password there

Murtaza Over a year ago

By using use DB; it is giving the following error syntax error, unexpected 'use' (T_USE)

Murtaza Over a year ago

I already configured "config > database.php". where should I find .env file you are talking about?

curious_coder Over a year ago

Which version of laravel are you using?

|

Collectives™ on Stack Overflow

Laravel fetch data from mysql table

1 Answer 1

15 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

15 Comments

Your Answer

Sign up or log in

Post as a guest

Related