PHP Lumen Call to a member function connection() on null

Question

I'm receiving this error when trying to use an Eloquent Model in Lumen.

Call to a member function connection() on null

Controller func:

/**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {

        $employees = Employee::orderBy('first_name', 'asc')->get();
dd($employees);

        $response['precontent'] = view('admin::employee.search')->render();

        $response['content'] = view('admin::employee.index')
            ->with(['employees' => $employees])
            ->render();

        $response['title'] = 'Employees';

        return $response; 

    }

Model:

    <?php
    namespace App;

use Illuminate\Database\Eloquent\Model;

class Employee extends Model 
{

    protected $table = 'system_core.employees';

    protected $fillable = [
        'user_id',
        'first_name',
        'last_name',
        'position',
        'primary_address',
        'secondary_address',
        'phone_1',
        'phone_2',
        'birth_date',
        'start_date',
        'end_date'
    ];

}

I'm pretty experienced with Laravel, but just started my first Lumen project for mere API use and I'm not sure why this error is being thrown. Perhaps it's just my connection settings? Would all queries have to be run the following way?:

$results = app('db')->select("SELECT * FROM users");

Thank you!

score 145 · Answer 1 · edited Jul 18 '19 at 09:44

145

You should uncomment the Eloquent $app->withEloquent() call in bootstrap/app.php.

https://lumen.laravel.com/docs/5.2/database#basic-usage

Update:

Latest version of the docs https://lumen.laravel.com/docs/5.8/database, check section Eloquent ORM

edited Jul 18 '19 at 09:44

Kazmi

1,198
9
20

answered May 20 '16 at 15:37

thefallen

9,496
2
34
49

5

You also have to uncomment the previous line (`$app->withFacades();`, as Eloquent does use Facades). – Marc Brillault Aug 23 '18 at 16:36

score 19 · Answer 2 · edited Aug 31 '23 at 21:13

You have to:

Create the database manually via e.g. PHPMyAdmin;
Configure the database connection it in the .env file (i.e. set DB_CONNECTION, DB_DATABASE, DB_USERNAME, DB_PASSWORD);
As per above answers uncomment $app->withFacades();, $app->withEloquent(); lines in bootstrap/app.php;
If you use your Eloquent model within PHPUnit tests you have to boot the Lumen (or Laravel) first by adding the following line to your test class setUp() method:
```
parent::setUp()
```

score 9 · Answer 3 · answered Jul 16 '21 at 20:09

9

Go to bootstrap/app.php

then uncomment

$app->withEloquent();

answered Jul 16 '21 at 20:09

Feisal Ali

351
2
9

score 3 · Answer 4 · answered Dec 27 '20 at 15:03

3

I think you just uncomment $app->withFacades();, $app->withEloquent(); lines in bootstrap/app.php;

And check again, it works for me.

answered Dec 27 '20 at 15:03

Ankur prajapati

485
6
9

score 2 · Answer 5 · answered Jul 11 '21 at 10:18

2

Another less common reason for this error is that you are trying to access an eloquent model before it is ready, e.g in the constructor of a Job or perhaps in app/Console/Kernel.php

If this is the case, try doing this instead

use Illuminate\Support\Facades\DB;

$model =  DB::table('table_name')
            ->where('field_name', 'field_value')->first()

answered Jul 11 '21 at 10:18

Otobong Jerome

401
6
5

this what i faced thanks (y) – Mohamed Naser Oct 13 '21 at 08:29

score 0 · Answer 6 · answered Sep 27 '22 at 12:56

0

I've tried different solutions but seems like problem was very simple.

composer du

works for me.

answered Sep 27 '22 at 12:56

Afzal Ali

880
8
25

score -1 · Answer 7 · answered Aug 31 '23 at 17:41

-1

Go to bootstrap/app.php

then uncomment

$app->withEloquent();

worked for me!

answered Aug 31 '23 at 17:41

Whelmer Neto

1

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Sep 02 '23 at 18:45

PHP Lumen Call to a member function connection() on null

7 Answers7

Linked