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!

Kaz · Accepted Answer · 2019-07-18 09:44:22Z

150

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, 2019 at 9:44

Kaz

1,2781 gold badge11 silver badges21 bronze badges

answered May 20, 2016 at 15:37

thefallen

9,8202 gold badges39 silver badges51 bronze badges

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

1 Comment

Orange Lux Over a year ago

You also have to uncomment the previous line ($app->withFacades();, as Eloquent does use Facades).

miken32 · Accepted Answer · 2023-08-31 21:13:09Z

19

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()
```

edited Aug 31, 2023 at 21:13

miken32

42.5k16 gold badges127 silver badges177 bronze badges

answered Feb 27, 2020 at 8:48

Valentine Shi

8,1294 gold badges60 silver badges50 bronze badges

Comments

Feisal Ali · Accepted Answer · 2021-07-16 20:09:23Z

10

Go to bootstrap/app.php

then uncomment

$app->withEloquent();

answered Jul 16, 2021 at 20:09

Feisal Ali

3772 silver badges9 bronze badges

Comments

Ankur prajapati · Accepted Answer · 2020-12-27 15:03:16Z

4

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

And check again, it works for me.

answered Dec 27, 2020 at 15:03

community wiki

Ankur prajapati

Comments

Otobong Jerome · Accepted Answer · 2021-07-11 10:18:04Z

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, 2021 at 10:18

Otobong Jerome

5167 silver badges5 bronze badges

Comments

Afzal Ali · Accepted Answer · 2022-09-27 12:56:21Z

1

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

composer du

works for me.

answered Sep 27, 2022 at 12:56

Afzal Ali

1,08614 silver badges29 bronze badges

Comments

Whelmer Neto · Accepted Answer · 2023-08-31 17:41:37Z

0

Go to bootstrap/app.php

then uncomment

$app->withEloquent();

worked for me!

answered Aug 31, 2023 at 17:41

Whelmer Neto

11

1 Comment

Community Over a year ago

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.

Collectives™ on Stack Overflow

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

7 Answers 7

1 Comment

Comments

Comments

Comments

Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

Comments

Comments

Comments

Comments

Comments

1 Comment

Linked

Related