PHP json数组，并从深度嵌套的数组中获取一些键值 [英] php json array of arrays and get some key values from deep nested
本文介绍了PHP json数组，并从深度嵌套的数组中获取一些键值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
code和values要存储到表中的代码，因为表列和值对于每个记录都是动态的。我不需要存储json值中的附件和Total。
我想以INSERT INTO(ID，TrackingNumber，CustomerFull)值(json值)的形式存储到表中。任何代码引爆器、php解决方案或提示都将非常有用。
{
"Values": [{
"AttributeValues": [{
"ID": 0,
"Name": "ID",
"Values": [
"720"
],
"DataType": "Number",
"Code": "ID",
"IsVisible": true,
"IsValueEmptyOrNull": false,
"IsDefault": true
},
{
"ID": 0,
"Name": "Tracking Number",
"Values": [
"xxxx/1094/180730/1"
],
"DataType": "String",
"Code": "TrackingNumber",
"IsVisible": true,
"IsValueEmptyOrNull": false,
"IsDefault": true
},
{
"ID": 0,
"Name": "Customer Full",
"Values": [
"Ali Abdi"
],
"DataType": "String",
"Code": "CustomerFull",
"IsVisible": true,
"IsValueEmptyOrNull": false,
"IsDefault": true
}
],
"Attachements": null
},
{
"AttributeValues": [{
"ID": 0,
"Name": "ID",
"Values": [
"757"
],
"DataType": "Number",
"Code": "ID",
"IsVisible": true,
"IsValueEmptyOrNull": false,
"IsDefault": true
},
{
"ID": 0,
"Name": "Tracking Number",
"Values": [
"xxx/1094/180731/1"
],
"DataType": "String",
"Code": "TrackingNumber",
"IsVisible": true,
"IsValueEmptyOrNull": false,
"IsDefault": true
},
{
"ID": 0,
"Name": "Customer Full",
"Values": [
"Aberash Haile"
],
"DataType": "String",
"Code": "CustomerFull",
"IsVisible": true,
"IsValueEmptyOrNull": false,
"IsDefault": true
},
{
"ID": 0,
"Name": "Service Code",
"Values": [
"SO-1096"
],
"DataType": "String",
"Code": "ServiceCode",
"IsVisible": true,
"IsValueEmptyOrNull": false,
"IsDefault": true
},
{
"ID": 0,
"Name": "Request Date",
"Values": [
"7/31/2018 11:04:06 AM"
],
"DataType": "Datetime",
"Code": "RequestDate",
"IsVisible": true,
"IsValueEmptyOrNull": false,
"IsDefault": true
}
],
"Attachements": null
}
],
"Total": 335
}
JSON
首先，您应该将推荐答案转换为数组，然后使用循环(Foreach、For、While...)并获得相应的价值，如下所示：
<?php
$json = '{
"Values":[
{
"AttributeValues":[
{
"ID":0,
"Name":"ID",
"Values":[
"720"
],
"DataType":"Number",
"Code":"ID",
"IsVisible":true,
"IsValueEmptyOrNull":false,
"IsDefault":true
},
{
"ID":0,
"Name":"Tracking Number",
"Values":[
"xxxx/1094/180730/1"
],
"DataType":"String",
"Code":"TrackingNumber",
"IsVisible":true,
"IsValueEmptyOrNull":false,
"IsDefault":true
},
{
"ID":0,
"Name":"Customer Full",
"Values":[
"Ali Abdi"
],
"DataType":"String",
"Code":"CustomerFull",
"IsVisible":true,
"IsValueEmptyOrNull":false,
"IsDefault":true
}
],
"Attachements":null
},
{
"AttributeValues":[
{
"ID":0,
"Name":"ID",
"Values":[
"757"
],
"DataType":"Number",
"Code":"ID",
"IsVisible":true,
"IsValueEmptyOrNull":false,
"IsDefault":true
},
{
"ID":0,
"Name":"Tracking Number",
"Values":[
"xxx/1094/180731/1"
],
"DataType":"String",
"Code":"TrackingNumber",
"IsVisible":true,
"IsValueEmptyOrNull":false,
"IsDefault":true
},
{
"ID":0,
"Name":"Customer Full",
"Values":[
"Aberash Haile"
],
"DataType":"String",
"Code":"CustomerFull",
"IsVisible":true,
"IsValueEmptyOrNull":false,
"IsDefault":true
},
{
"ID":0,
"Name":"Service Code",
"Values":[
"SO-1096"
],
"DataType":"String",
"Code":"ServiceCode",
"IsVisible":true,
"IsValueEmptyOrNull":false,
"IsDefault":true
},
{
"ID":0,
"Name":"Request Date",
"Values":[
"7/31/2018 11:04:06 AM"
],
"DataType":"Datetime",
"Code":"RequestDate",
"IsVisible":true,
"IsValueEmptyOrNull":false,
"IsDefault":true
}
],
"Attachements":null
}
],
"Total":335
}';
$json_data = json_decode($json, true);
//echo "<pre>"; print_r($json_data['Values']); exit;
if(isset($json_data['Values'])){
foreach($json_data as $data){
foreach($data as $attr){
if(isset($attr['AttributeValues'])){
foreach($attr['AttributeValues'] as $value){
if(isset($value['Values'])){
foreach($value['Values'] as $val){
$attribute_values = $val;
echo "<pre>"; print_r($attribute_values); echo "</pre>";
}
}
}
}
}
}
}
?>
这篇关于PHP json数组，并从深度嵌套的数组中获取一些键值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
