从mysql数据库中查询和解码json

Question

我的mysql数据库中有这个JSON编码代码：

{"Suggestion":{"Title":"Casinos","Text":"maybe it will be good if its there casinos "},"ID":6,"VoteNo":[],"Status":"Voting","Player":{"SteamID":"STEAM_0:1:36988062","Name":"Pepi"},"Approved":{"Name":"Nido Johnson","Is":true,"SteamID":"STEAM_0:0:47457253"},"VoteYes":{"1":"STEAM_0:0:56939043","2":"STEAM_0:0:55948188","3":"STEAM_0:1:25856984","4":"STEAM_0:1:40894071"}}

我想在我的网站上对它进行查询和解码。

Answer 1

您必须使用php "json_decode()“函数来解码json编码的数据。基本上，json_decode()函数将JSON数据转换为PHP数组。

语法: json_decode(数据、dataTypeBoolean、深度、选项)

data ：-您想在PHP中解码的json数据。

dataTypeBoolean(Optional) :-使函数返回(如果设置为"true“)的布尔值，如果省略此参数或将其设置为"false”，则返回PHP stdClass对象。可以像数组一样访问这两种数据类型，并使用基于数组的PHP循环进行解析。

深度 :-可选递归限制。使用整数作为此参数的值。

options :-可选JSON_BIGINT_AS_STRING参数。

现在进入您的代码

    $json_string = '{"Suggestion":{"Title":"Casinos","Text":"maybe it will be good if its there casinos "},"ID":6,"VoteNo":[],"Status":"Voting","Player":{"SteamID":"STEAM_0:1:36988062","Name":"Pepi"},"Approved":{"Name":"Nido Johnson","Is":true,"SteamID":"STEAM_0:0:47457253"},"VoteYes":{"1":"STEAM_0:0:56939043","2":"STEAM_0:0:55948188","3":"STEAM_0:1:25856984","4":"STEAM_0:1:40894071"}}';

将有效的json数据分配给单变量“‘s ('')中的变量$json_string，因为json字符串已经具有双quot.。

// here i am decoding a json string by using a php 'json_decode' function, as mentioned above & passing a true parameter to get a PHP associative array otherwise it will bydefault return a PHP std class objecy array.

    / just can check here your encoded array data.
// echo '<pre>';
// print_r($json_decoded_data);

// loop to extract data from an array
foreach ($json_decoded_data as $key => $value) {
    echo "$key <br/>";
    foreach($value as $k=>$data)
    {
        echo "$k | $data <br/>";
    }

}