Я хочу вставить параметры JSON в базу данных phpmyadmin. Я пробовал с кодом ниже, но это не сработало. Пожалуйста, помогите мне в этом.
мои параметры JSON:
`$ "address" = "bharuch" "customer_id" = "108" "products" = "[{"product_id":"1","product_name":"Potato","category_id":"1","subcategory_id":"1","product_memberprice":"11","product_nonmemberprice":"14","product_minquantity":"500 gms","product_image":"http:\/\/gaubharat.in\/gaubharat\/images\/potato.png","product_brand":"","sub_total":"28","user_qty":"2"},{"product_id":"2","product_name":"Tomato","category_id":"1","subcategory_id":"1","product_memberprice":"15","product_nonmemberprice":"18","product_minquantity":"500 gms","product_image":"http:\/\/gaubharat.in\/gaubharat\/images\/tomato.png","product_brand":"","sub_total":"18","user_qty":"1"}]" "pincode" = "392025" "order_totalamount" = "46"` и мой PHP-код:
<?php require("config.inc.php"); $address = $_POST['address']; $customerid = $_POST['customer_id']; $amount = $_POST['order_totalamount']; $pincode = $_POST['pincode']; $product = json_decode($_POST['products']); foreach( $product as $key => $val) { $product_id = $val['product_id']; $product_name = $val['product_name']; $category_id = $val['category_id']; $subcategory_id = $val['subcategory_id']; $product_memberprice = $val['product_memberprice']; $product_nonmemberprice = $val['product_nonmemberprice']; $product_minquantity = $val['product_minquantity']; $product_image = $val['product_image']; $product_brand = $val['product_brand']; $sub_total = $val['sub_total']; $user_qty = $val['user_qty']; $query = "INSERT INTO `order`(cm_id,product_id,product_quantity,sub_total,order_totalamount,order_id,address,pincode,order_date) VALUES ('$customerid','$product_id','$user_qty','$sub_total','$amount','1','$address','$pincode',CURDATE())"; if(!mysqli_query($db,$query)) { die('Error : ' . mysql_error()); } else{ $response["success"] = 1; $response["message"] = "You order placed successfully!"; echo json_encode($response); } } ?>-<?php require("config.inc.php"); $address = $_POST['address']; $customerid = $_POST['customer_id']; $amount = $_POST['order_totalamount']; $pincode = $_POST['pincode']; $product = json_decode($_POST['products']); foreach( $product as $key => $val) { $product_id = $val['product_id']; $product_name = $val['product_name']; $category_id = $val['category_id']; $subcategory_id = $val['subcategory_id']; $product_memberprice = $val['product_memberprice']; $product_nonmemberprice = $val['product_nonmemberprice']; $product_minquantity = $val['product_minquantity']; $product_image = $val['product_image']; $product_brand = $val['product_brand']; $sub_total = $val['sub_total']; $user_qty = $val['user_qty']; $query = "INSERT INTO `order`(cm_id,product_id,product_quantity,sub_total,order_totalamount,order_id,address,pincode,order_date) VALUES ('$customerid','$product_id','$user_qty','$sub_total','$amount','1','$address','$pincode',CURDATE())"; if(!mysqli_query($db,$query)) { die('Error : ' . mysql_error()); } else{ $response["success"] = 1; $response["message"] = "You order placed successfully!"; echo json_encode($response); } } ?>
Пожалуйста, помогите мне в этом.