DB::table Select() returns Array as String Laravel

Question

I want to get users list as per distance and in user DB I stored user images in json format. When I use DB::table it return as string not as array.

Please Help me.

My Controller:

$doc = DB::table( 'users' )
            ->select(
                'id',
                'name',
                'image',
                'latitude',
                'longitude' )
            ->selectRaw( "{$getDistance} AS distance" )
            ->orderBy( 'distance' )
            ->get();

CURRENT JSON RESPONSE:

{
"name": "User One",
"image": "[\"f0f159c7238b8c9a1a3e5c9bd48de2a5cJ8Y4ssqzcuoWJAS1614581337EC2fGzmRCjf9wphI.webp\", 
         \"f0f159c7238b8c9a1a3e5c9bd48de2a5tvof9EarZgvupGpa1614581337zvPSnQchCjSL9lZS.webp\"]",
}

What I WANT TO GET:

{
"name": "User One",
"image": ["f0f159c7238b8c9a1a3e5c9bd48de2a5cJ8Y4ssqzcuoWJAS1614581337EC2fGzmRCjf9wphI.webp", 
         "f0f159c7238b8c9a1a3e5c9bd48de2a5tvof9EarZgvupGpa1614581337zvPSnQchCjSL9lZS.webp"],
}

maybe it is because of distance, you just do this $doc = DB::table( 'users' ) ->select( 'id', 'name', 'image', 'latitude', 'longitude' ) ->get();and check what you get — Basharmal
– Basharmal, Commented Mar 6, 2021 at 6:02

Sebastian Agreda · Accepted Answer · 2021-03-06 05:57:45Z

1

you can use Jsonencode or jsondecode before send the response.

i would use $doc->image = json_encode($doc->image());

and then

return response()->json('data' => $doc);

answered Mar 6, 2021 at 5:57

Sebastian Agreda

91 bronze badge

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

Collectives™ on Stack Overflow

DB::table Select() returns Array as String Laravel

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