如何将json值插入mysql数据库[关闭]

Question

I recive this JSON from a site

https://openexchangerates.org/api/latest.json?app_id=1d85872a9b324abcabb2aea5ab397605 

and it looks like this.

{
  "disclaimer": "Exchange rates...",
  "license": "Data sourced from various providers...",
  "timestamp": 1433782861,
  "base": "USD",
  "rates":
  {
      "BWP": 10.075038,
      "CHF": 0.934077,
      "CNY": 6.188018,
      "EUR": 0.890331,
      "GBP": 0.653896,
      "ZMW": 7.248788
   }
}

How can I insert, or rather periodically update a MySQL database replacing previous values using PHP, MySQL with this structure.

CREATE TABLE IF NOT EXISTS `rate` (
  `currency_` varchar(10) NOT NULL Primary key,
  `value_` decimal(10,5) NOT NULL
)

Answer 1

<?php
include('con.php'); //http://www.w3schools.com/php/func_mysqli_connect.asp

//get the json
$json = file_get_contents('https://openexchangerates.org/api/latest.json?app_id=1d85872a9b324abcabb2aea5ab397605');

//decode json, in to an array
$decoded = json_decode($json, true);

//iterate over the array
foreach($decoded['rates'] as $currency => $rate){
    $rates[] = "('" . $currency . "', '" . $rate . "')";
}

//query, just connect once
 $sql =  "INSERT INTO `lol`.`rate` (`currency_`, `value_`) VALUES " . implode(",",$rates) . "ON DUPLICATE KEY UPDATE value_ = VALUES(value_)";

if (mysqli_query($con, $sql)) {
    echo 'Record created successfully<br>';
} else {
    echo $sql . '"<br>"' . mysqli_error($con);
};    
?>

EDIT: http://www.w3schools.com/php/func_mysqli_connect.asp

con.php:

<?php
//use your connection data here
$user = "";
$pass = "";
$host = "";
$dbdb = "";

$con = mysqli_connect($host, $user, $pass, $dbdb);

// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}