Как вывести нужную информацию из массива?

Question

[Muffasssa]

есть вот такой код для вывода массива:

<?      
$db =&JFactory::getDBO();
$query = "SELECT field_id,item_id,value FROM a68y5_fields_values WHERE field_id='27'";
$db->setQuery($query);
$result = $db->loadObjectList();
print_r($result);
?>

Получаем такой вывод:

Array([0] => stdClass Object([field_id] => 27[item_id] => 57[value] => {"items":[{"caption":"","thumbnail":"media\/acfgallery\/content\/57\/27\/turkue-2_thumb.jpg","image":"media\/acfgallery\/content\/57\/27\/turkue-2.jpg"},{"caption":"","thumbnail":"media\/acfgallery\/content\/57\/27\/cei-tr-17-20_thumb.jpg","image":"media\/acfgallery\/content\/57\/27\/cei-tr-17-20.jpg"},{"caption":"","thumbnail":"media\/acfgallery\/content\/57\/27\/376e2e826ef05422273ec4ce4aeea6a7_thumb.jpg","image":"media\/acfgallery\/content\/57\/27\/376e2e826ef05422273ec4ce4aeea6a7.jpg"},{"caption":"","thumbnail":"media\/acfgallery\/content\/57\/27\/20210408193043834296329o_thumb.jpg","image":"media\/acfgallery\/content\/57\/27\/20210408193043834296329o.jpg"},{"caption":"","thumbnail":"media\/acfgallery\/content\/57\/27\/azura_park_room_1_thumb.jpg","image":"media\/acfgallery\/content\/57\/27\/azura_park_room_1.jpg"}]})[1] => stdClass Object([field_id] => 27[item_id] => 56[value] => {"items":{"0":{"caption":"","thumbnail":"media\/acfgallery\/content\/56\/27\/cei-tr-17-20_thumb.jpg","image":"media\/acfgallery\/content\/56\/27\/cei-tr-17-20.jpg"},"1":{"caption":"","thumbnail":"media\/acfgallery\/content\/56\/27\/turkue-2_thumb.jpg","image":"media\/acfgallery\/content\/56\/27\/turkue-2.jpg"},"2":{"caption":"","thumbnail":"media\/acfgallery\/content\/56\/27\/376e2e826ef05422273ec4ce4aeea6a7_thumb.jpg","image":"media\/acfgallery\/content\/56\/27\/376e2e826ef05422273ec4ce4aeea6a7.jpg"},"3":{"caption":"","thumbnail":"media\/acfgallery\/content\/56\/27\/20210408193043834296329o_thumb.jpg","image":"media\/acfgallery\/content\/56\/27\/20210408193043834296329o.jpg"},"5":{"caption":"","thumbnail":"media\/acfgallery\/content\/56\/27\/azura_park_room_1_thumb.jpg","image":"media\/acfgallery\/content\/56\/27\/azura_park_room_1.jpg"},"6":{"caption":"","thumbnail":"media\/acfgallery\/content\/56\/27\/27173286512962220648konak-city-towers-in-alanya_13_thumb.jpg","image":"media\/acfgallery\/content\/56\/27\/27173286512962220648konak-city-towers-in-alanya_13.jpg"}}}))

Как я могу вывести только то что содержится в 56[value] => Т.е. нужен вот этот код:

{"items":{"0":{"caption":"","thumbnail":"media\/acfgallery\/content\/56\/27\/cei-tr-17-20_thumb.jpg","image":"media\/acfgallery\/content\/56\/27\/cei-tr-17-20.jpg"},"1":{"caption":"","thumbnail":"media\/acfgallery\/content\/56\/27\/turkue-2_thumb.jpg","image":"media\/acfgallery\/content\/56\/27\/turkue-2.jpg"},"2":{"caption":"","thumbnail":"media\/acfgallery\/content\/56\/27\/376e2e826ef05422273ec4ce4aeea6a7_thumb.jpg","image":"media\/acfgallery\/content\/56\/27\/376e2e826ef05422273ec4ce4aeea6a7.jpg"},"3":{"caption":"","thumbnail":"media\/acfgallery\/content\/56\/27\/20210408193043834296329o_thumb.jpg","image":"media\/acfgallery\/content\/56\/27\/20210408193043834296329o.jpg"},"5":{"caption":"","thumbnail":"media\/acfgallery\/content\/56\/27\/azura_park_room_1_thumb.jpg","image":"media\/acfgallery\/content\/56\/27\/azura_park_room_1.jpg"},"6":{"caption":"","thumbnail":"media\/acfgallery\/content\/56\/27\/27173286512962220648konak-city-towers-in-alanya_13_thumb.jpg","image":"media\/acfgallery\/content\/56\/27\/27173286512962220648konak-city-towers-in-alanya_13.jpg"}}}

Comments

[Сергей]

foreach($result as $row) {
var_dump($row->value);
}

https://docs.joomla.org/Selecting_data_using_JData...

Answer 1

[Slava Rozhnev]

$result[0]->value;

Answer 2

[Сергей Толкачев]

Если joomla 4,то обращение к базе должно быть через DI-контейнер.