从results wordpress读取数组Object内部的JSON

Question

在wordpress(Caldera Form插件(的DB表中，有一个JSON数组作为值，从查询中，结果具有以下结构：

Array (
[0] => stdClass Object (
[config] => a:22:{
s:2:"ID";
s:15:"CF605df92fa7a17";
s:13:"_last_updated";
s:31:"Sat, 27 Mar 2021 16:44:15 +0000";
s:10:"cf_version";
s:5:"1.9.4";
s:4:"name";
s:29:"Registration for Artists 2021";
s:10:"scroll_top";...}
) 
[1] => stdClass Object (
[config] => a:22:{
s:2:"ID";
s:15:"CF605ba79300239";
s:13:"_last_updated";
s:31:"Sat, 27 Mar 2021 16:44:51 +0000";
s:10:"cf_version";
s:5:"1.9.4";
s:4:"name";
s:29:"Inscription des Artistes 2021";
s:10:"scroll_top";...}
) 

我怎么能读"；a： 22〃；那么"；s： 15〃；在…内我用[config]值做了一个json_decode，但它返回了一个空值。。

Answer 1

你把我放在轨道上

$results = [];
$data = [];
foreach ($entries as $key => $object) {
$results[] = unserialize($object->config);
foreach ($results as $key => $value) {
$data = [
'id' => $value['ID'],
'name' => $value['name']
];
}
var_dump($data);
}```
gives :

array(2) { ["id"]=> string(15) "CF605df92fa7a17" ["name"]=> string(29) "Registration for Artists 2021" } 
array(2) { ["id"]=> string(15) "CF605ba79300239" ["name"]=> string(29) "Inscription des Artistes 2021" } 

It's what i need
So I can continue
Thanxs

Answer 2

使用您发布的这个数组转储，会返回什么？

foreach ($array as $key => $object) {
$config = unserialize($object->config);
var_dump($config);
}

通过$array传递您转储的相同变量。这可能不起作用，但值得一试。

---

例如，如果我有这个$array转储的数据。。。

Array
(
[0] => stdClass Object
(
[config] => a:4:{s:2:"ID";s:15:"CF605df92fa7a17";s:13:"_last_updated";s:31:"Sat, 27 Mar 2021 16:44:15 +0000";s:10:"cf_version";s:5:"1.9.4";s:4:"name";s:29:"Registration for Artists 2021";}
)
[1] => stdClass Object
(
[config] => a:4:{s:2:"ID";s:15:"CF605ba79300239";s:13:"_last_updated";s:31:"Sat, 27 Mar 2021 16:44:51 +0000";s:10:"cf_version";s:5:"1.9.4";s:4:"name";s:29:"Inscription des Artistes 2021";}
)
)

并在循环中运行上面的unserialize()函数，这就是输出。。。

Array
(
[ID] => CF605df92fa7a17
[_last_updated] => Sat, 27 Mar 2021 16:44:15 +0000
[cf_version] => 1.9.4
[name] => Registration for Artists 2021
)
Array
(
[ID] => CF605ba79300239
[_last_updated] => Sat, 27 Mar 2021 16:44:51 +0000
[cf_version] => 1.9.4
[name] => Inscription des Artistes 2021
)

---

对您最后一条评论的回应，此输出是什么？

foreach ($array as $key => $object) {
var_dump($object);
// $config = unserialize($object->config);
// var_dump($config);
}