How to remove 'null' values in laravel controller while retrieving data from database

Question

The results in $data variable. I want to remove null values at output.

The following code:

    $data = json_decode(json_encode($data),true);

I am copying $data to $data1 later to merge the two variables using below code:

$data1 = $data;
$unique= array_merge($data1,$data);
$final =array_values(array_map("unserialize",array_unique(array_map("serialize", $unique))));

`$data ` being what exactly? If it's a collection then you can apply filters:`$data->filter(function ($element, $key) { return $element!==null; });` — ka_lin, Jul 05 '17 at 08:16
Maybe you should rethink what you are doing: Encoding and then decoding, serializing and then unserializing, merging it with itself... Surely there is an easier way to get the results you need. — jeroen, Jul 05 '17 at 08:20
This looks like an [X/Y problem](https://meta.stackexchange.com/questions/66377/what-is-the-xy-problem) I suggest, instead of this question, ask a question about the problem you were trying to solve and came up with this solution. As it stands, this code is doing a lot of things that are a bit sub-optimal. — apokryfos, Jul 07 '17 at 16:13

Bibhudatta Sahoo · Answer 1 · 2017-07-05T10:22:26.320

1

You can use array_filter to remove the null value fro the array

Do like this

$data = json_decode(json_encode($data),true);
$data =array_filter($data);

Modification
As you are dealing with Multi dimensional array (as you said in comment),to remove the array which have null data you need to use array_map , array_filter and in_array.

Do like this

$data = json_decode(json_encode($data),true);
$data =array_map('array_filter',$data);
$data=array_map(function ($data){
            if(!in_array(null,$data))
                return $data;
        },$data);
$data=array_filter($data);

It will give output as

It will work for you.

edited Jul 05 '17 at 10:22

answered Jul 05 '17 at 08:18

Bibhudatta Sahoo

4,808
2
27
51

in $data array i have some data and $data1 have some data so i merged two arrays and return to array_map (). – Prashanth vadla Jul 05 '17 at 08:20
okay you can use `array_filter() ` when you need to remove your null value from your data array. – Bibhudatta Sahoo Jul 05 '17 at 08:25
still same issue using array_filter(). – Prashanth vadla Jul 05 '17 at 08:27
Can you please show your data what you have now and what you want to be. – Bibhudatta Sahoo Jul 05 '17 at 08:28
The following code have for the material null, so i remove for that null and give only valued data .[0]=> array(3) { ["iot"]=> int(1172141637653120) ["datetime"]=> string(19) "2017-05-11 11:32:39" ["material"]=> NULL } [1]=> array(3) { ["iot"]=> int(8567763953469695) ["datetime"]=> string(19) "2017-05-11 11:32:39" ["material"]=> string(13) "2134803942910" } – Prashanth vadla Jul 05 '17 at 08:47
yes i tried, but i need where ever the material code is NULL, that particular index should be removed and give output. – Prashanth vadla Jul 05 '17 at 10:07
like that only its working now it just removing the ** material code is NULL** just check the o/p `array[0]` – Bibhudatta Sahoo Jul 05 '17 at 10:09
yes but i need remove whole index like its iot, date, material_code, where ever the material_code is NULL.so for above two array responses i need only one array response. – Prashanth vadla Jul 05 '17 at 10:12
@Prashanthvadla now i got your problem just try this modified ans. – Bibhudatta Sahoo Jul 05 '17 at 10:23
No, its not coming can you check it once! – Prashanth vadla Jul 05 '17 at 10:28
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/148396/discussion-between-bibhudatta-sahoo-and-prashanth-vadla). – Bibhudatta Sahoo Jul 05 '17 at 10:29
@Prashanthvadla if your issue is solved then close your question by accepting my answer :) – Bibhudatta Sahoo Jul 05 '17 at 13:17

score 0 · Answer 2 · answered Jul 05 '17 at 08:20

0

array_filter will work perfectly if you're only working with arrays containing strings. Be careful otherwise as array_filter will also remove 0, '', and false.

See this answer: Remove empty array elements

answered Jul 05 '17 at 08:20

Lasse

77
1
10

score 0 · Answer 3 · answered Jul 05 '17 at 08:26

If both $data adn $data1 are database results I can assume they are collections.

Then you can make 1 collection by applying union: $data->union($data1);

After which you can filter the result set:

$data->filter(function ($element, $key) { return $element!==null; });

How to remove 'null' values in laravel controller while retrieving data from database

3 Answers3