代码之家 › 专栏 › 技术社区 › Brian Millot

如何修复json输出?

curl json

0

Brian Millot · 技术社区 · 8 年前

我在解码从CURL收到的json时遇到了一个问题, 我使用json\u last\u error来查看可能的原因,我的json似乎格式不正确。

        // Make the REST call, returning the result
        $response = curl_exec($this->curl); // result is as per screenshot below

        $resp_json = json_decode($response, true);

        echo "<pre>";
        print_r($resp_json); // display nothing
        echo "</pre>";

Click here to see the json output and the issue

从jsonlint来看,响应就像。。。

{
    "RESPONSE_DATA": [{
                "property_address": "6\/192 Kingsgrove Road",
                "price": 0.0,
                "contact_name": "Nicholas Smith",
                "property_facing_direction": "unknown",
                "agent_name": "",
                "client_id": 46984,
                "property_suburb": "Kingsgrove",
                "agent_phone": "",
                "contact_phone": "0407 787 288",
                "ordered_datetime": "2017-12-05 04:15:03",
                "agent_email": "",
                "property_state": "NSW",
                "job_id": 2324,
                "im_job_id": "40432-o",
                "product_ids": 3000000,
                "confirmed_datetime": "",
                "photographer_comment": "Photography Premium Daylight 3 photos  $145.00\
                nAdd Per Premium Photo 2 at $20 .00 each\ n Total $185 .00 ","
                contact_company ":"
                Raine & Horne Commerical - Marrickville ","
                agent_id ":"
                ","
                preferred_datetime ":"
                2017 - 12 - 07 11: 00: 00 ","
                property_postcode ":0000,"
                status_code ":"
                N "}],"
                RESPONSE_MESSAGE ":"
                OK ","
                RESPONSE_CODE ":200}

1 回复 | 直到 8 年前

1

0

Yu-Lin Chen 8 年前

json有4个问题:

意外换行符
\n 在里面 photographer_comment
\ n 在里面 摄影师评论
property_postcode ":0000

您可以通过硬编码将其替换为:

$json = trim(preg_replace('/\s+/', ' ', $json));
$json = str_replace("\\n", "", $json);
$json = str_replace("\\ n", "", $json);
$json = str_replace(":0000", ":\"0000\"", $json);

它又快又脏,不包括其他情况;如果您想使用更通用的方法,可以尝试正则表达式。但我认为,在数据提供商方面进行修复更为合理。

除此之外,由于拖尾空白,一些键的名称不好,例如: "preferred_datetime "