Convert NULL into empty string while getting response

Question

i just want how can we convert null into empty string while getting result from db. For example

User::first();

In user table, roll number is null value. i want it to convert into empty string.

do you need all response NULL to "" for android or iphone developer ? — Kamlesh Paul
– Kamlesh Paul, Commented Mar 8, 2021 at 11:38
then use middleware and apply to all route so you will not miss any where — Kamlesh Paul
– Kamlesh Paul, Commented Mar 8, 2021 at 14:25

Kamlesh Paul · Accepted Answer · 2021-03-08 11:43:05Z

i had same task i solved this by Middleware

created NullToBlank.php Middleware

<?php

namespace App\Http\Middleware;

use Closure;

class NullToBlank
{
    /**
     * Handle an incoming request.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \Closure  $next
     * @return mixed
     */
    public function handle($request, Closure $next)
    {
        $output = $next($request);
        if ($output) {

            $json = $output->content();
            $modelAsArray = json_decode($json, true);

            if (is_array($modelAsArray)) {
                array_walk_recursive($modelAsArray, function (&$item, $key) {
                    $item = $item === null ? '' : $item;
                });
                return response($modelAsArray);
            } else {
                return $next($request);
            }
        }
    }
}

then apply this middleware whenever you need to replace NULL to ""

Satyandra Shakya · Accepted Answer · 2021-03-08 11:39:40Z

2

Yes, you can do this in boot method with retrieved observer like this.

 self::retrieved(function ($model) {
        $keys = $model->fillable;
        foreach ($keys as $key => $value) {
            $model->attributes[$value] = @$model->attributes[$value] == null ?  '' : $model->attributes[$value];
        }
    });

answered Mar 8, 2021 at 11:39

Satyandra Shakya

3712 silver badges9 bronze badges

Collectives™ on Stack Overflow

Convert NULL into empty string while getting response

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related