Home / Questions / 419156
Accepted
DAD
Asked: 2022-01-08 10:27:20 +0800 CST 2022-01-08 10:27:20 +0800 CST

How can I get the id correctly from this query?

  • 772

I am using MongoDB and Laravel

I am doing the query as follows:

$json_datos = DB::table('items_tabla')->get();
$datos_finales= json_decode($json_datos );

The query $json_datosI get this data: ![enter image description here

so that's why I use the json_decodeto be able to get them as follows enter image description here

bladebut the problem I have is that when I try to show _id it I get an error because the id is inside another key, and I don't know how to enter it to get it enter image description here

This is how I use the foreach in the blade:

@foreach ($datos_finales as $item)
   {{$item->_id}}  //error
   {{$item->imagen}} //success
@endforeach

I would appreciate the help, thank you very much!

laravel

1 Answers

  1. Best Answer

    Try this way, you should be able to access your array without the stdClass

    $datos_finales= json_decode(json_encode($json_datos), true);

@foreach ($datos_finales as $item)
    {{$item['_id']['$oid']}}
    {{$item['imagen']}}
@endforeach
    • 1