php代码来检查json数据是否来自android代码。
<?php
require "init.php";
if($_POST){
print_r($_POST);
}else{
echo "Nothing came from android code";
}
?>
作为响应,我正在获取json数据,如下所示:-
([jsonarray] => [{“ custInfo”:“ Ujwal 9975022560”,“ rate”:“ 24000”,“ weight”:“ 21.00000”,“ desc”:“ GENTS ANGTHI 22k NO STONE”,“ makingAmt”:“ 200“,” sum_total“:” RS.156283.38“,” vat“:” RS.3064.38“,” itemTotal“:” 51073“,”条形码“:” BQSP78BB“,” net_rate“:” 24200“,” date“ :“ 2015-12-02”,“发票编号”:“ 1”,“ bill_type”:“发票”},{“ custInfo”:“ Ujwal 9975022560”,“ rate”:“ 24000”,“ weight”:“ 21.00000 “,” desc“:” GENTS ANGTHI 22k NO STONE“,” makingAmt“:” 200“,” sum_total“:” RS.156283.38“,” vat“:” RS。3064.38“,” itemTotal“:” 51073“,”条形码“:” BQSP78BB“,” net_rate“:” 24200“,” date“:” 2015-12-02“,” invoiceNo“:” 1“,” bill_type“ :“发票”},{“ custInfo”:“ Ujwal 9975022560”,“ rate”:“ 24000”,“ weight”:“ 21.00000”,“ desc”:“ GENTS ANGTHI 22k NO STONE”,“ makingAmt”:“ 200 “,” sum_total“:” RS.156283.38“,” vat“:” RS.3064.38“,” itemTotal“:” 51073“,”条形码“:” BQSP78BB“,” net_rate“:” 24200“,” date“: “ 2015-12-02”,“ invoiceNo”:“ 1”,“ bill_type”:“发票”}])条码“:” BQSP78BB“,” net_rate“:” 24200“,” date“:” 2015-12-02“,” invoiceNo“:” 1“,” bill_type“:” Invoice“},{” custInfo“:” Ujwal 9975022560“,” rate“:” 24000“,” weight“:” 21.00000“,” desc“:” GENTS ANGTHI 22k NO STONE“,” makingAmt“:” 200“,” sum_total“:” RS.156283.38“, “ vat”:“ RS.3064.38”,“ itemTotal”:“ 51073”,“条形码”:“ BQSP78BB”,“ net_rate”:“ 24200”,“ date”:“ 2015-12-02”,“ invoiceNo”: “ 1”,“ bill_type”:“发票”}])条码“:” BQSP78BB“,” net_rate“:” 24200“,” date“:” 2015-12-02“,” invoiceNo“:” 1“,” bill_type“:” Invoice“},{” custInfo“:” Ujwal 9975022560“,” rate“:” 24000“,” weight“:” 21.00000“,” desc“:” GENTS ANGTHI 22k NO STONE“,” makingAmt“:” 200“,” sum_total“:” RS.156283.38“, “ vat”:“ RS.3064.38”,“ itemTotal”:“ 51073”,“条形码”:“ BQSP78BB”,“ net_rate”:“ 24200”,“ date”:“ 2015-12-02”,“ invoiceNo”: “ 1”,“ bill_type”:“发票”}])invoiceNo“:” 1“,” bill_type“:” Invoice“},{” custInfo“:” Ujwal 9975022560“,” rate“:” 24000“,” weight“:” 21.00000“,” desc“:” GENTS ANGTHI 22k NO STONE“,” makingAmt“:” 200“,” sum_total“:” RS.156283.38“,” vat“:” RS.3064.38“,” itemTotal“:” 51073“,”条形码“:” BQSP78BB“,” net_rate “:” 24200“,” date“:” 2015-12-02“,” invoiceNo“:” 1“,” bill_type“:” Invoice“}])invoiceNo“:” 1“,” bill_type“:” Invoice“},{” custInfo“:” Ujwal 9975022560“,” rate“:” 24000“,” weight“:” 21.00000“,” desc“:” GENTS ANGTHI 22k NO STONE“,” makingAmt“:” 200“,” sum_total“:” RS.156283.38“,” vat“:” RS.3064.38“,” itemTotal“:” 51073“,”条形码“:” BQSP78BB“,” net_rate “:” 24200“,” date“:” 2015-12-02“,” invoiceNo“:” 1“,” bill_type“:” Invoice“}])GENTS ANGTHI 22k NO STONE“,” makingAmt“:” 200“,” sum_total“:” RS.156283.38“,” vat“:” RS.3064.38“,” itemTotal“:” 51073“,”条形码“:” BQSP78BB“ ,“ net_rate”:“ 24200”,“ date”:“ 2015-12-02”,“ invoiceNo”:“ 1”,“ bill_type”:“ Invoice”}]))GENTS ANGTHI 22k NO STONE“,” makingAmt“:” 200“,” sum_total“:” RS.156283.38“,” vat“:” RS.3064.38“,” itemTotal“:” 51073“,”条形码“:” BQSP78BB“ ,“ net_rate”:“ 24200”,“ date”:“ 2015-12-02”,“ invoiceNo”:“ 1”,“ bill_type”:“ Invoice”}]))
我想做的就是解析此响应并将数据插入到mysql数据库中。我认为是这样的。
foreach ( $data as $inv ) {
$custInfo = $inv->custInfo;
$rate = $inv->rate;
$weight= $inv->weight;
$desc= $inv->desc;
$makingAmt= $inv->makingAmt;
$vat= $inv->vat;
$itemTotal= $inv->itemTotal;
$sum_total= $inv->sum_total;
$barcode= $inv->barcode;
$net_rate= $inv->net_rate;
$date= $inv->date;
$invoiceNo= $inv->invoiceNo;
$bill_type= $inv->bill_type;
$sql = "INSERT INTO selected_items
(custInfo, invoiceNo, barcode, desc,
weight, rate, makingAmt,net_rate,
itemTotal,vat,sum_total,bill_type,date)
VALUES
('$custInfo','$invoiceNo','$barcode','$desc',
'$weight','$rate','$makingAmt','$net_rate',
'$itemTotal','$vat','$sum_total','$bill_type','$date')";
$res = mysqli_query($sql,$con);
我是php的新手,所以尝试了json_decode,但它返回一个空字符串作为响应。如何解析并插入custInfo, invoiceNo, barcode, desc,weight, rate, makingAmt,net_rate,itemTotal,vat,sum_total,bill_type,date
表格selected_items.
谢谢你:)
试试这个(更新):
$arr = json_decode(stripslashes($_POST['jsonarray']), true);
$env = $arr['jsonarray'];
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句