将JSON结果分离为变量 - Separate JSON result into variables

Separate JSON result into variables

本文关键字：变量分离结果 JSON | 更新日期: 2023-09-27

我有以下生成的JSON结果，并想了解如何将结果分离为2个变量：

JSON-

{
    "data": [
        [
            {
                "source": "server1",
                "host": "pc1",
                "description": "SSH server is down on {HOSTNAME}",
            }
        ],
        [
            {
                "source": "server2",
                "host": "pc2",
                "description": "webapp down",
            }
        ]
    ],
    "error": {
        "server3": "Host is not allowed to connect to this MySQL server",
        "server4": "Can't connect to MySQL server",
    }
}

预期结果：

{
    "data": [
            {
                "source": "server1",
                "host": "pc1",
                "description": "SSH server is down on {HOSTNAME}",
            },
            {
                "source": "server2",
                "host": "pc2",
                "description": "webapp down",
            }
        ]
}

和

{
    "error": {
        "server3": "Host is not allowed to connect to this MySQL server",
        "server4": "Can't connect to MySQL server",
    }
}

PHP代码：

<?php
  include '../include/db_conn.php';
  print to_json(get_all_alert());
 $return = get_all_alert();
print to_json($return["data"]);
print to_json($return["error"]);
?>

php代码仍然打印两次合并后的结果。感谢

您的json数据不正确，您可以在此处进行检查：http://json.parser.online.fr/从每个数组部分中删除多余的逗号。

试试这个：

<?php
$data1='{
    "data": [
        [
            {
                "source": "server1",
                "host": "pc1",
                "description": "SSH server is down on {HOSTNAME}"
            }
        ],
        [
            {
                "source": "server2",
                "host": "pc2",
                "description": "webapp down"
            }
        ]
    ],
    "error": {
        "server3": "Host is not allowed to connect to this MySQL server",
        "server4": "Cant connect to MySQL server"
    }
}';
$val_array = json_decode($data1,true);
print_r($val_array['data']);
print_r($val_array['error']);

好吧，您可能不需要额外的一行。

print to_json(get_all_alert());

去掉它，你的问题很可能就会消失。