将嵌套的json数组插入mysql [英] Insert nested json array into mysql
本文介绍了将嵌套的json数组插入mysql的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试将JSON数组插入我的MySQL数据库.这是数组的格式:
I am trying to insert a JSON array into my MySQL database. Here is the format of the array:
${
"customer_id": "1",
"products":[ {
"product_id": "1",
"product_qty": "2"
}, {
"product_id": "2",
"product_qty": "4"
}, {
"product_id": "3",
"product_qty": "12"
}, {
"product_id": "4",
"product_qty": "22"
}],
"order_totalamount": "100"
}
我尝试如下插入查询:
<?php
require("config.inc.php");
$jsondata = file_get_contents('OrderFormat.json');
//convert json object to php associative array
$data = json_decode($jsondata, true);
//get the employee details
$cus_id = $data['customer_id'];
$product_id = $data['products']['product_id'];
$product_qty = $data['products']['product_qty'];
$order_totalamount = $data['order_totalamount'];
//insert into mysql table
$sql = "insert into `order`(cm_id,product_id,product_quantity,order_totalamount,order_id,order_date) values ($cus_id,$product_id,$product_qty,$order_totalamount,$cus_id,CURDATE())";
echo $sql;
//$sql1 = mysql_query($sql);
$conn = mysqli_connect($host, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
if(!mysqli_query($conn,$sql))
{
die('Error : ' . mysql_error());
}
?>
我也解码JSON数据,并进行foreach循环.
Also I decode the JSON data, and foreach loop.
请帮助我解决此问题. 预先感谢.
Kindly help me in this issue. Thanks in advance.
推荐答案
尝试如下操作:
<?php
//require("config.inc.php");
$jsondata ='{
"customer_id": "1",
"products":[ {
"product_id": "1",
"product_qty": "2"
}, {
"product_id": "2",
"product_qty": "4"
}, {
"product_id": "3",
"product_qty": "12"
}, {
"product_id": "4",
"product_qty": "22"
}],
"order_totalamount": "100"
}';
//convert json object to php associative array
$data = json_decode($jsondata, true);
//get the employee details
$cus_id = $data['customer_id'];
$order_totalamount = $data['order_totalamount'];
$order_totalamount = $data['order_totalamount'];
foreach($data['products'] as $key => $val)
{
$product_id = $val['product_id'];
$product_qty = $val['product_qty'];
//insert into mysql table
$sql = "insert into `order`(cm_id,product_id,product_quantity,order_totalamount,order_id,order_date) values ($cus_id,$product_id,$product_qty,$order_totalamount,$cus_id,CURDATE())";
echo $sql;
//$sql1 = mysql_query($sql);
$conn = mysqli_connect($host, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
if(!mysqli_query($conn,$sql))
{
die('Error : ' . mysql_error());
}
}
?>
这篇关于将嵌套的json数组插入mysql的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文