Laravel 5 - Class 'DB' not found

Question

I have ChatController located in app/http/controllers like so:

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;

use Ratchet\MessageComponentInterface;
use Ratchet\ConnectionInterface;
use DB;

class ChatController extends Controller implements MessageComponentInterface {

    protected $clients;

    function __construct() {
        $this->clients = new \SplObjectStorage;
    }

    public function onOpen(ConnectionInterface $conn) 
    {
        $this->clients->attach($conn);
    }

    public function onMessage(ConnectionInterface $conn, $msg) 
    {
        foreach ($this->clients as $client) 
        {
            if ($client !== $conn )
                $client->send($msg); 

            DB::table('messages')->insert(
                ['message' => $msg]
            );
        }
    }

    public function onClose(ConnectionInterface $conn) 
    {
        $this->clients->detach($conn);
    }

    public function onError(ConnectionInterface $conn, \Exception $e) 
    {
        echo 'the following error occured: ' . $e->getMessage();
        $conn->close();
    }

}

And I have chatserver.php file in the root like so:

<?php
require  'vendor/autoload.php';

use Ratchet\Server\IoServer;
use Ratchet\Http\HttpServer;
use Ratchet\WebSocket\WsServer;
use App\Http\Controllers\ChatController;


$server = IoServer::factory(
    new HttpServer(
        new WsServer(
            new ChatController()
        )
    ),
    8080
);

$server->run();

If I remove

DB::table('messages')->insert(
                    ['message' => $msg]
                );

from the ChatController and start chatserver.php it works, but if I don't remove it then the server starts but as soon as I send a message I get this error:

Fatal error: Uncaught Error: Class 'DB' not found in C:\wamp\www\laraveltesting\app\Http\Controllers\ChatController.php:31

Why won't it use DB? I am extending the laravel controller.

@KhanShahrukh same crap

user6562256
– user6562256

2016-07-30 12:48:10 +00:00
Commented Jul 30, 2016 at 12:48 — user6562256
– user6562256, Commented Jul 30, 2016 at 12:48

Sibasankar Bhoi · Accepted Answer · 2017-06-14 13:50:06Z

10

This one is better

use Illuminate\Support\Facades\DB;

Or you can use a slash('/') before DB like below

/DB::table('messages')->insert(
                ['message' => $msg]
            );

answered Jun 14, 2017 at 13:50

Sibasankar Bhoi

5894 silver badges15 bronze badges

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

Comments

jonju · Accepted Answer · 2016-07-30 11:54:14Z

2

try using this

use Illuminate\Support\Facades\DB;

instead of

use DB;

answered Jul 30, 2016 at 11:54

jonju

2,7561 gold badge15 silver badges19 bronze badges

1 Comment

user6562256 Over a year ago

I get this: the following error occured: A facade root has not been set. - either way, I don't get why use DB isn't enough since I am extending the controller.

Ndeto · Accepted Answer · 2018-02-19 10:21:22Z

2

As previously advised First use

use Illuminate\Support\Facades\DB;

then go /bootstrap/app.php and uncomment

$app->withFacades();

answered Feb 19, 2018 at 10:21

Ndeto

3156 silver badges18 bronze badges

Comments

Miguellito · Accepted Answer · 2019-10-08 01:04:12Z

1

for Laravel 5 and up simply just use this

use DB;

instead of

use Illuminate\Support\Facades\DB;

which is use for Laravel 4 version

answered Oct 8, 2019 at 1:04

Miguellito

211 silver badge6 bronze badges

Comments

Deddy Supa · Accepted Answer · 2020-07-29 09:17:32Z

1

change use Illuminate\Support\Facades\DB; to Use DB;

answered Jul 29, 2020 at 9:17

Deddy Supa

111 bronze badge

Comments

billrichards · Accepted Answer · 2023-11-16 15:15:44Z

0

Add this in your test class file (before the class keyword) so your test can find the location of the Laravel application and create a new app.

if (!isset($app)) {
    $app = new \Illuminate\Foundation\Application(
          // E.g. if the current dir is app/tests/Unit/
          // Your path may differ
        realpath(__DIR__.'/../../')
    );
}

And in the test methods where you want to use DB, add global $app

public function testSomething()
{
    global $app;
    //
}

answered Nov 16, 2023 at 15:15

billrichards

2,0804 gold badges25 silver badges37 bronze badges

Collectives™ on Stack Overflow

Laravel 5 - Class 'DB' not found

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related