Php convert null value inside array to blank (" ")

Question

I am returning all shipping address saved by user but there are some values which are left blank and output comes as null in those. How can i convert NULL values to blank (" "). I have looked many solutions on internet but not able to get make it working. API link:

https://androidapp.factory2homes.com/api/shippings/3

$address = DB::table('shippings')->where('user_id' , $user_id)->get();
  return $address;

Maybe you can show us your "many solutions", and tell us why they don't work? For now: make your address a true eloquent model, for example model Shipping. Return that model in a response, either by simply returning the model or by returning a model resource. Either way, internally laravel calls several functions to get the attribute values. You have the ability to access these attributes, turning null values into blanks. See laravel.com/docs/7.x/eloquent-mutators#defining-an-accessor — Maarten Veerman
– Maarten Veerman, Commented Jul 19, 2020 at 18:24

Kurt Friars · Accepted Answer · 2020-07-19 18:20:11Z

1

You can just map the return value like:

return $address = DB::table('shippings')
                    ->where('user_id' , $user_id)
                    ->get()
                    ->map(function ($item) {
                       $mapped = [];

                       foreach ($item as $key => $value) {
                           $mapped[$key] = $value ?? ' ';
                       }
                       
                       return $mapped
                    });

answered Jul 19, 2020 at 18:20

Kurt Friars

3,7742 gold badges18 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Php convert null value inside array to blank (" ")

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related