title: PHP to decode JSON array and insert into MYSQL database
body: <p>I am trying to create a PHP script that decodes a JSON array and insert it into a database. So far i've managed to get the script to insert the first row in the array and nothing else.</p>
  
  <p>What would I need to add to this to get the script to insert all the rows in the array?</p>
  
  <p>Here's the array, ignore "listings", I don't need that data yet (It's quite big):
  <a href="http://eddb.io/archive/v3/stations.json" rel="nofollow">json</a>
  Here's the script:</p>
  
  <pre class="lang-php prettyprint-override"><code>&lt;?php
  $servername = "localhost";
  $username = "root";
  $password = "";
  
  // Create connection
  $con = mysql_connect($servername, $username, $password);
  
  //select db
  $selected = mysql_select_db("ed",$con);
  
  $json_obj = file_get_contents("stations.json");
  
  //convert to stdclass object
  $arr = json_decode($json_obj,true);
  
  //store the element values into variables
  
  $id = $arr[0]["id"];
  $name = $arr[0]["name"];
  $system_id = $arr[0]["system_id"];
  $max_landing_pad_size = $arr[0]["max_landing_pad_size"];
  $distance_to_star = $arr[0]["distance_to_star"];
  $faction = $arr[0]["faction"];
  $government = $arr[0]["government"];
  $allegiance = $arr[0]["allegiance"];
  $state = $arr[0]["state"];
  $type = $arr[0]["type"];
  $has_blackmarket = $arr[0]["has_blackmarket"];
  $has_commodities = $arr[0]["has_commodities"];
  $has_refuel = $arr[0]["has_refuel"];
  $has_repair = $arr[0]["has_repair"];
  $has_rearm = $arr[0]["has_rearm"];
  $has_outfitting = $arr[0]["has_outfitting"];
  $has_shipyard = $arr[0]["has_shipyard"];
  
  //insert values into mysql database
  $sql="INSERT INTO stations (station_id, name, system_id, max_landing_pad_size, distance_to_star, faction, government, allegiance, state, type, has_blackmarket, has_commodities, has_refuel, has_repair, has_rearm, has_outfitting, has_shipyard) 
  VALUES ('$id', '$name', '$system_id', '$max_landing_pad_size', '$distance_to_star', '$faction', '$government', '$allegiance', '$state', '$type', '$has_blackmarket', '$has_commodities', '$has_refuel', '$has_repair', '$has_rearm', '$has_outfitting', '$has_shipyard')";
  
  if(!mysql_query($sql,$con)) //$con is mysql connection object
  {
       die('Error : ' . mysql_error());
  }
  ?&gt;
  </code></pre>