Eloquent Model returns empty array even though there&#39;s data in the database

Level 58

The issue might be related to the namespace of the Notification model. Make sure that the namespace in the LaraJobNotifications component matches the namespace in the Notification model.

Here's the updated code:

namespace App\Http\Livewire;

use App\Models\Notification;
use Livewire\Component;

class LaraJobNotifications extends Component
{
    public function render()
    {
        $notifications = Notification::all();
   
        var_dump($notifications);

        return view('livewire.lara-job-notifications', [
            'notifications' => $notifications,
        ]);
    }
}

Also, ensure that you have data in the notifications table in your database.

If the issue persists, you can try running the following command to clear the application cache:

php artisan cache:clear

If none of the above solutions work, please provide more information about your database configuration and any error messages you are receiving.

Level 1

After running the cache:clear command, this is what I get when I call var_dump($notifications);

object(Illuminate\Database\Eloquent\Collection)#1167 (2) { ["items":protected]=> array(0) { } ["escapeWhenCastingToString":protected]=> bool(false) }

MohamedTammam

Level 51

What do you get when you do ?

dd($notifications);

Level 1

@MohamedTammam Nothing is echoed out when I do dd($notifications);

MohamedTammam

Level 51

@oyincode Then you don't have records on the database, or something wrong with your model structure.

BTW, it this Larajob NativePHP bounty app? 😅

Level 1

@MohamedTammam yes it's the bounty app 😁

Level 11

@oyincode Check with this code and let me know your feedback.

// app/Http/Livewire/LaraJobNotifications.php

namespace App\Http\Livewire;

use Livewire\Component;
use App\Models\Notification; // Adjust the namespace according to your model location

class LaraJobNotifications extends Component
{
    public $notifications;

    public function mount()
    {
        $this->notifications = Notification::all();
    }

    public function render()
    {
        return view('livewire.lara-job-notifications');
    }
}

Level 1

@hupp Nothing happens. Still the same

Level 11

@oyincode Check your Database is same as you check in tool and in laravel project connected. Verify table name is proper.

 $this->notifications = Notification::get()->toArray();

Level 1

@hupp this is what I get array(0) { }. The table exists in my DB. The name of the table is notifications. I currently have 16 records in there

Level 11

@oyincode Does they are soft_deleted ?? in that case you want to get the you have to use

Notification::withTrashed()->get()->toArray();

May now you get all soft_deleted records too.

Level 50

@hupp You can see the model definition above. It doesn't use soft-deletion.

Level 11

@JussiMannisto Check DB Connection & Check Database Name same you checking is the same in .env.

Level 1

@JussiMannisto Yes, it doesn't use soft deletion.

The funny thing is when I run DB:select('select * from migrations'), I get the data from the DB. But when I run DB:select('select * from notifications'), it's still empty. I'm not sure where the problem might be

Level 50

@oyincode Well your database obviously doesn't have any notifications then. Where did you get the 16 records you mentioned above?

Level 11

@oyincode Which tool you used to check 16 records are there !

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=database_name
DB_USERNAME=db_user
DB_PASSWORD=db_pass

Verify this in .env and mysql tool used.

Level 11

@oyincode i told you to verify it many times before. But you are not doing that first. Check this .env file or config/database.php

Level 50

Is your DB configuration correct? And are you using the correct DB connection? How are you checking that your DB has those models?

What do you get if you retrieve the models through tinker:

php artisan tinker
App\Models\Notification::all();

Level 1

@JussiMannisto When I run the php artisan tinker, this is what I get

> App\Models\Notification::all();
= Illuminate\Database\Eloquent\Collection {#7380
    all: [
      App\Models\Notification {#7382
        id: 1,
        title: "Senior Laravel Developer / Tech Lead (work from home)",
        job_link: "https://larajobs.com/job/3046",
        company_name: "Snapforms",
        created_at: "2023-07-25 03:51:00",
        updated_at: "2023-07-25 03:51:00",
      },
      App\Models\Notification {#7383
        id: 2,
        title: "Junior to Mid-level Front-end Web Developer",
        job_link: "https://larajobs.com/job/859",
        company_name: "Genos International",
        created_at: "2023-07-25 03:51:01",
        updated_at: "2023-07-25 03:51:01",
      },
      App\Models\Notification {#7384
        id: 3,
        title: "Senior Software Developer",
        job_link: "https://larajobs.com/job/2199",
        company_name: "TeachBoost",
:

Level 1

So the data exists

Level 1

@JussiMannisto. Doesn't this prove that there is data in the Model or am I missing something?

Level 50

@oyincode So there are notifications here but you don't see them in your component. Can you check if you're using the same database connection.

First in tinker:

php artisan tinker
App\Models\Notification::query()->getConnection()->getName();
App\Models\Notification::query()->getConnection()->getDatabaseName();

And then in your component:

dump(Notification::query()->getConnection()->getName());
dump(Notification::query()->getConnection()->getDatabaseName());

Btw, how are you running your app?

Level 50

@oyincode

Doesn't this prove that there is data in the Model or am I missing something?

It only proves that there is data somewhere. But it doesn't look like you're querying that DB in your Livewire component.

Level 1

@JussiMannisto You are a life saver.

The Model uses App\Models\Notification::query()->getConnection()->getName() = 'mysql' App\Models\Notification::query()->getConnection()->getDatabaseName() = ''laravel_notifier'

The Component uses dump(Notification::query()->getConnection()->getName()) = 'nativephp' dump(Notification::query()->getConnection()->getDatabaseName()); = '"/Users/oyindamolaoyetunmibi/Library/Application Support/NativePHP/database/database.sqlite"

So apparently the component is connected to a different DB from my Model. So how can I rectify this?

I'm using NativePHP by the way

Level 1

@JussiMannisto Exactly, you're right. Please how can I fix this

Level 50

@oyincode Unfortunately I'm not familiar with NativePHP. It's a whole different game.

Level 1

@JussiMannisto yes I found the problem. NativePHP uses SQlite alone for its DB purposes. So storing my data in MySQL was never going to work. Thank @jussimannisto, you have been of great help

Snapey