Laravel Eloquent returning double array with null properties

Question

I am querying a model using Laravel Eloquent. When there is records available the query returns a result that is an array of objects.

[{id: 2, num: 3}]

When there is no records available Eloquent returns an array within an array of objects where all the object properties has a null values.

[[{id: null, num: null}]]

The thing is how to I test whether there is no record or a null object. None of the following methods works:

isset($records) // does not cover empty object
!empty($records) // does not seem to see null properties
count($records) > 0 // sees an array more than zero deep

This is my query:

$records = FertilAppUser::select('fertilapp.*')
            ->leftJoin('fertilapp', 'fertilappuser.id', '=', 'fertilapp.fertilappuser_id')
            ->where('fertilappuser.id', '=', $request->get( 'id' ))
            ->groupBy('fertilapp.id')
            ->orderBy('fertilapp.id', 'asc')
            ->get();

An empty result must be handled because it is possible and it seems to be the one thing that is a pain to handle for me. Everything works, then I test empty results and boom comes errors!

Can someone help me to understand why the results are arrays of differing depths?

If both results where an array of objects it would be easy but how do I check for !empty($record[0]->id) and !empty($record[0][0]->id) without getting an error.

Interestingly the following query returns an array of objects or an array with null [null].

$records = DB::select('SELECT fertilapp.* ' .
                  ' FROM fertilapp ' .
                  ' LEFT JOIN fertilappuser ON fertilappuser.id = fertilapp.fertilappuser_id ' .
                  ' WHERE fertilappuser.id = ? ' .
                  ' GROUP BY fertilapp.id ' .
                  ' ORDER BY fertilapp.id ASC ', [$request->get( 'id' )]);

This can the be tested with above methods. Still would like to know why the Eloquent method is returning the result above.

After running the query I check if the results are usable and loop through them.

if (isset($records) && !empty($records) ) {                        
       foreach ($records as $key => $value) {...}
}

What are you doing with the $record after the query? Are you wrapping it in a Resource class? In any case, $record should be an Eloquent Collection. If you wannt to know if it's empty or not, use the collection methods: $record->isEmpty() or $record->isNotEmpty() — IGP
– IGP, Commented Sep 8, 2020 at 20:31
Does using ->isEmpty() / ->isNotEmpty() return the expected values? And how are you 'testing' it? What are you using to dump the data and get an array within an array? — IGP
– IGP, Commented Sep 8, 2020 at 20:36
I mean an Eloquent Resource. If you're not using one it doesn't really matter. — IGP
– IGP, Commented Sep 8, 2020 at 20:38

IGP · Accepted Answer · 2020-09-09 16:19:42Z

1

First,

isset($record) will always return true since you're setting the $record variable yourself.

Second,

Instead of !empty($record), you should use either !$record->isEmpty() or $record->isNotEmpty().

Third,

The null values you encounter are probably a result of the left join. Use an (inner) join if you want to avoid null values.

answered Sep 9, 2020 at 16:19

IGP

16.4k5 gold badges34 silver badges55 bronze badges

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

Comments

Emil Georgiev · Accepted Answer · 2020-09-09 03:52:19Z

0

You are using left join here - fertilappusers left join fertilapp It will return all users records even if they has no record in fertilapp table.

The queries you provided are different. The first one is like I said above. The second one is fertilapp left join fertilappusers which will give you all records from fertilapp even if there is no user for it.

Please check this link where you will get familiar how the mysql join works What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

answered Sep 9, 2020 at 3:52

Emil Georgiev

5384 silver badges15 bronze badges

Collectives™ on Stack Overflow

Laravel Eloquent returning double array with null properties

2 Answers 2

First,

Second,

Third,

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

First,

Second,

Third,

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related