主页 / 问题 / 982933
Accepted
Denis640Kb
Asked:2020-05-19 00:02:36 +0000 UTC2020-05-19 00:02:36 +0000 UTC

无法转换数组。json_deocde 不工作

  • 772

求助各位，我需要帮助。有数据

{"stat":"Сообщение успешно обработано","status":"OK","messageId":"123","messageResult":"Запрос обработан","messageDate":1558037969,"lastName":"Мяяя","firstName":"Vzzz","middleName":"Kkk","iin":"111222333444","birthdate":"16.11.1993","period":"6","table":[{"DATE_OPR":"2011-12-11T00:00:00+06:00","SUMM_DB":"172755.1","SUMM_DB_NETTO":"117000.03099999996","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"123","F50_GUARANTOR_RNN":"123123213","nameRu":""},{"DATE_OPR":"2011-01-11T00:00:00+06:00","SUMM_DB":"116755.1","SUMM_DB_NETTO":"117000.03099999996","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""},{"DATE_OPR":"2011-02-11T00:00:00+06:00","SUMM_DB":"115000.0","SUMM_DB_NETTO":"115578.4","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""},{"DATE_OPR":"2011-03-11T00:00:00+06:00","SUMM_DB":"115000.0","SUMM_DB_NETTO":"115578.4","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB","F50_GUARANTOR_RNN":"1231231232","nameRu":""},{"DATE_OPR":"2011-04-01T00:00:00+06:00","SUMM_DB":"117219.59999999998","SUMM_DB_NETTO":"111176.27599999998","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""},{"DATE_OPR":"2011-05-11T00:00:00+06:00","SUMM_DB":"115000.0","SUMM_DB_NETTO":"115578.4","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""}]}

可以有不同数量的表值。我正在尝试通过 json_decode 转换为 json 数组，但它总是返回空。告诉我，我怎样才能将这些数据转换成一个多维数组，其中有几个表？谢谢

php

2 个回答

  1. 试试吧，它可能会工作:)

      <?php
    $date='{"stat":"Сообщение успешно обработано","status":"OK","messageId":"123","messageResult":"Запрос обработан","messageDate":1558037969,"lastName":"Мяяя","firstName":"Vzzz","middleName":"Kkk","iin":"111222333444","birthdate":"16.11.1993","period":"6","table":[{"DATE_OPR":"2011-12-11T00:00:00+06:00","SUMM_DB":"172755.1","SUMM_DB_NETTO":"117000.03099999996","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"123","F50_GUARANTOR_RNN":"123123213","nameRu":""},{"DATE_OPR":"2011-01-11T00:00:00+06:00","SUMM_DB":"116755.1","SUMM_DB_NETTO":"117000.03099999996","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""},{"DATE_OPR":"2011-02-11T00:00:00+06:00","SUMM_DB":"115000.0","SUMM_DB_NETTO":"115578.4","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""},{"DATE_OPR":"2011-03-11T00:00:00+06:00","SUMM_DB":"115000.0","SUMM_DB_NETTO":"115578.4","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB","F50_GUARANTOR_RNN":"1231231232","nameRu":""},{"DATE_OPR":"2011-04-01T00:00:00+06:00","SUMM_DB":"117219.59999999998","SUMM_DB_NETTO":"111176.27599999998","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""},{"DATE_OPR":"2011-05-11T00:00:00+06:00","SUMM_DB":"115000.0","SUMM_DB_NETTO":"115578.4","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""}]}';


    $gr=explode(':',$date);
    $chery=count($gr);

    for($i = 0; $i <= $chery-1; $i++) {

        $da2=explode(",", $gr[$i]);
    $da3=explode(",", $gr[$i+1]);

    $tu[$da2[1].'+'.$i]=$da3[0];


    }


    print_r($tu);
    ?>
    • 1
  2. Best Answer

    我在代码中撒了一些谎-引号已损坏-稍后我会更正。
    但是算法的思想是正确描述的

    1. 有必要纠正歪曲数据的来源，而不是数据需要使用的地方。
    2. 所以我确信不仅引号没有在那里转义，而且所有其他字符也没有转义。
    3. 如果你想要一些半足够的拐杖：
      1. 转义所有反斜杠以将 \t 序列分成 2 个字符。
      2. 我们正在尝试解析为 json。
      3. 发生了？万岁！
      4. 否则，将最后一个字符替换为其 unicode 代码并返回步骤 2。

    Chrome 上最笨的 js 版本（我没有在其他浏览器中检查过 - 它可能无法正常工作）会变成这样：

    function parse(drivel) {
  drivel = drivel.replace(/\\/g, "\\\\")
  var last = 0, back = false

  while(1) {
    try {
      return JSON.parse(drivel)
    } catch (e) {
      var match = e.message.match(/^Unexpected token .*? in JSON at position (\d+)$/)
      if (!match) throw new Error("Failed to parse - unexpected error: " + e.message)
      var i = +match[1]

      if (i <= last) {
        if (back || last !== i+1) throw new Error(`Failed to parse - need to go back for fix: from ${last} to ${i} in ${JSON.stringify(drivel)}`)
        back = true
      } else {
        back = false
      }
      
      last = i
      drivel = drivel.slice(0, i-1) + "\\u" + (drivel[i].charCodeAt(0) + 0x10000).toString(16).slice(-4) + drivel.slice(i)
    }
  }
}

console.log(parse(`{"stat":"Сообщение успешно обработано","status":"OK","messageId":"123","messageResult":"Запрос обработан","messageDate":1558037969,"lastName":"Мяяя","firstName":"Vzzz","middleName":"Kkk","iin":"111222333444","birthdate":"16.11.1993","period":"6","table":[{"DATE_OPR":"2011-12-11T00:00:00+06:00","SUMM_DB":"172755.1","SUMM_DB_NETTO":"117000.03099999996","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"123","F50_GUARANTOR_RNN":"123123213","nameRu":""},{"DATE_OPR":"2011-01-11T00:00:00+06:00","SUMM_DB":"116755.1","SUMM_DB_NETTO":"117000.03099999996","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""},{"DATE_OPR":"2011-02-11T00:00:00+06:00","SUMM_DB":"115000.0","SUMM_DB_NETTO":"115578.4","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""},{"DATE_OPR":"2011-03-11T00:00:00+06:00","SUMM_DB":"115000.0","SUMM_DB_NETTO":"115578.4","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB","F50_GUARANTOR_RNN":"1231231232","nameRu":""},{"DATE_OPR":"2011-04-01T00:00:00+06:00","SUMM_DB":"117219.59999999998","SUMM_DB_NETTO":"111176.27599999998","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""},{"DATE_OPR":"2011-05-11T00:00:00+06:00","SUMM_DB":"115000.0","SUMM_DB_NETTO":"115578.4","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""}]}`))
    .as-console-wrapper.as-console-wrapper { max-height: 100vh }

    它有什么不好？

    1. 就像我说的，修复不在它应该在的地方。
    2. 可能存在无法正确识别的数据。
    3. 此代码效率低下：
      • 它具有二次渐近性，尽管线性也可以做到这一点
      • 它对非异常情况使用异常机制
    4. 这段代码很糟糕，因为
      • 使用错误消息解析而无法以其他方式获取错误位置 - 消息可能会更改，并且这种情况下的代码将停止工作；即使现在我也不知道它是否可以在 chrome 以外的地方使用
      • 也许它有特殊字符的其他缺陷
    5. 专业人士中
      • 编写的函数总是完成 - 成功或有异常

    好吧，如果你突然需要用php重写它，那就让它成为作者的任务。

    • 1

相关问题