Level 65
Blank != no errors.
Check your web server/PHP error logs.
May 7, 2015
8
Level 1
Lumen Blank Screen only on DB:: Query
I just installed a fresh version of Lumen and I'm having an issue with database queries. I have Dotenv, Facades and Eloquent enabled in my app.php file. I've also connected my .env file to my local database.
The site works fine but once I add a query a receive a white blank page (no errors)
Here is my code in my controller
public function index()
{
$users = DB::table('users')->get();
return view('main.home');
}
Any suggestions?
Level 1
@bashy thanks for the quick response. I am seeing an error in my PHP log. I've placed it below:
[07-May-2015 17:26:14 UTC] PHP Fatal error: Class 'App\Http\Controllers\DB' not found in /Users/macadmin/Documents/projects/localleader/lumen/app/Http/Controllers/PageController.php on line 11
How do import the DB model?
use App\Http\Controllers\DB
Level 65
You shouldn't need to if you have the withFacades() uncommented.
Note: If you would like to use the DB facade, you should uncomment the $app->withFacades() call in your bootstrap/app.php file.
Level 1
@bashy I currently have it uncommented. Any other suggestions?
Level 65
Yeah just making sure. That's all you need to do for it to be enabled but I've used Eloquent in mine so not used the DB facade myself.
Level 1
@bashy I found the issue. It was due to php namespacing which required me to use a \ in front of DB. Below is my working code.
$users = \DB::table('users')->get();
Level 65
Can probably do use DB; at the top and use it without the backslash then!
Level 1
@bashy, "use DB; " is working good, can use DB:: without the backslash now.
Please or to participate in this conversation.