如何在PHP中解析MySQL列中的数组 - How to parse array from MySQL column in PHP

How to parse array from MySQL column in PHP

本文关键字：MySQL 数组 PHP | 更新日期: 2023-09-27

表中有列extra_fields。

在列中，我有一个数组，我需要解析它

 [{"id":"1","value":"fdsds"},{"id":"2","value":"'/images'/powered_by.png"},{"id":"3","value":"fdsfdsfdsfds"},{"id":"4","value":"<p>fdsfdsfdsfds<'/p>"}]

试着用这个代码来做，

$extrafields = array();
foreach($this->item->extra_fields as $item)
{   
    $extrafields[$item->id] = $item->value;
}

但返回空字符串或。。。我不知道是什么

目前还不清楚您想要实现什么，但现在可以实现了：

$test = json_decode('[{"id":"1","value":"fdsds"},{"id":"2","value":"'/images'/powered_by.png"},{"id":"3","value":"fdsfdsfdsfds"},{"id":"4","value":"<p>fdsfdsfdsfds<'/p>"}]');
$extrafields = array();
foreach ($test as $key => $item) {
    $extrafields[$item->id] = $item->value;
}