如何在JSON数据Laravel 5.1中查询生成器 [英] How to Query Builder in json data laravel 5.1

问题描述

如何在json数据中查询生成器?我正在使用guzzle，所有我想要如何查询，例如搜索金额不为NULL的数据?

how to query builder in json data? i'm using guzzle , all i want how to query like searching data where amount is NOT NULL?

json数据结果:

{
  "amount": [
    {
      "member_id": "SSD",
      "sum4": null,
      "sum5": null,
      "sum6": null
    },
    {
      "member_id": "OGG",
      "sum4": 122,
      "sum5": 242,
      "sum6": 123
    },
    {
      "member_id": "PUCAN",
      "sum4": 123,
      "sum5": 443,
      "sum6": 222
    },
    {
      "member_id": "SS3TG",
      "sum4": null,
      "sum5": null,
      "sum6": null
    }
  ]
}

我只想在JSON结果中不获取sum4，sum6，sum6的地方，你们能帮助我吗?.

ALL I WANT HOW TO GET sum4,sum6,sum6 WHERE NOT NULL IN JSON RESULT, can u guys help me..

推荐答案

// Pass JSON data with true as parameters to json_decode function
// It returns value as associative array
$data = json_decode($jsonData, true);

// Loop through amount
foreach($data['amount'] as $sum)
{
    // Check sum is not null
    if ($sum['sum4'] != null) {
        echo $sum['sum4'];
    // Check sum is not null
    } elseif ($sum['sum5'] != null) {
        echo $sum['sum5'];
    // Check sum is not null
    } elseif ($sum['sum6'] != null) {
        echo $sum['sum6'];
    }
}

这篇关于如何在JSON数据Laravel 5.1中查询生成器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！