Class 'App\Http\Controllers\DB' not found

Just do this:

$d = \DB::table('sites')->join('sites' , 'SiteID' , '=' , 'datavalues.SiteID')->get();

or import DB at the top:

use DB;

There are tho ways

\DB::table('table')->query();

Or add this to the top of your document

use Illuminate\Support\Facades\DB;

Hi @yassin98010, with Laravel 5.1.2 I have a lot of error with the libraries. I found that just adding a backslash before the class' name (\ClassName) solve all the problem. Example:

\Mail::send(...)
\Flash::info(...)
\Input::get(...)
\Auth::attempt(...)
...

All of these are the same correct answer. When you are within a namespace, php looks in the namespace to find the class. (I believe If the class can't be found it then checks the parent namespace...and so on until it's at the global namespace.) Because the DB is in a sub namespace of a different namespace it would never be found (as would the Facades not be found also). So adding the slash at the beginning tells it to look for any globally set classes (as the Facades already are) and to use them instead.

Namespacing is tricky and will be the root of many of your problems until you get the hang of it. I've been using them for over a year and still run into issues now and again.

thank you very much !!