数组值以分配php:中的变量
Array
(
[0] => stdClass Object
(
[Id] => 116249
[Amount] => 51.62
[Currency] => INR
[ExchangeRate] => 1
[InvoiceDate] => 2015-12-16T00:00:00Z
}
[1] => stdClass Object
(
[Id] => 116250
[Amount] => 55.20
[Currency] => KWD
[ExchangeRate] => 1
[InvoiceDate] => 2015-12-16T00:00:00Z
}
[2] => stdClass Object
(
[Id] => 116251
[Amount] => 59.42
[Currency] => USD
[ExchangeRate] => 1
[InvoiceDate] => 2015-12-16T00:00:00Z
}
}
foreach ($invoice as $key => $value)
{
$Id=$value->Id;
$Amount=$value->Amount;
$Currency=$value->Currency;
$ExchangeRate=$value->ExchangeRate;
$invoiceDate = str_replace('Z', '', str_replace('T', ' ',$value->InvoiceDate));
}
$jsonData ='[{"Id": "'.$Id.'",
"Amount": "'.$Amount.'",
"Currency": "'.$Currency.'",
"ExchangeRate": "'.$ExchangeRate.'",
"invoiceDate": "'.$invoiceDate.'"}];
我试过这个代码最后一个数组值只打印数组[2]值,我需要像一样的输出
[{"Id": "116249",
"Amount": "51.62",
"Currency": "INR",
"ExchangeRate": "1",
"invoiceDate": "2015-12-16T00:00:00Z"},
{"Id": "116250",
"Amount": "55.20",
"Currency": "KWD",
"ExchangeRate": "1",
"invoiceDate": "2015-12-16T00:00:00Z"},
{"Id": "116251",
"Amount": "59.42",
"Currency": "USD",
"ExchangeRate": "1",
"invoiceDate": "2015-12-16T00:00:00Z"}]
我同意Liam的观点,json_encode()
可能是解决您问题的最佳方案。然而,如果你正在寻找一个DIY解决方案,它很简单:
$jsonData = '[';
foreach ($invoice as $key => $value)
{
$Id=$value->Id;
$Amount=$value->Amount;
$Currency=$value->Currency;
$ExchangeRate=$value->ExchangeRate;
$invoiceDate = str_replace('Z', '', str_replace('T', ' ',$value->InvoiceDate));
// Append the next invoice's JSON data to all of the JSON data
$jsonData .='{"Id": "'.$Id.'",
"Amount": "'.$Amount.'",
"Currency": "'.$Currency.'",
"ExchangeRate": "'.$ExchangeRate.'",
"invoiceDate": "'.$invoiceDate.'"},';
}
// Clean up and close off the JSON data:
$jsonData = rtrim($jsonData, ','); // remove the trailing comma
$jsonData .= ']'; // Add the closing bracket.
您在代码中遇到的问题是,在foreach循环运行后,您只分配了一次JSON数据。相反,您需要将每个发票的JSON数据附加到其他发票的JSON数据中。
尽管如此,json_encode()
可能是更好的解决方案,因为它是一行,更容易阅读,而且可以说更容易理解。
您想要从数组创建json字符串。你所需要做的就是运行以下
jsonData = json_encode($invoice);
如果您想使用循环来创建数组,只生成特定的值,那么您可以执行以下操作:
$tmp = array();
foreach ($invoice as $key => $value)
{
$tmp["id"] = $value->Id;
$tmp["amount"] = $value->Amount;
$tmp["Currency"] = $value->Currency;
$tmp["ExchangeRate"] = $value->ExchangeRate;
$tmp["invoiceDate"] = str_replace('Z', '', str_replace('T','',$value->InvoiceDate));
}
jsonData = json_encode($tmp);
*编辑*
如果您对invoiceData变量使用mysql日期。那么您最好使用PHP日期函数。