coba

#isi data input.json
{
  "sensor": [
    {
      "accel": [
        {
          "x": 999.9999,
          "y": 999.9999,
          "z": 999.9999
        }
      ],
      "compass": [
        {
          "x": 999.9999,
          "y": 999.9999,
          "z": 999.9999
        }
      ],
      "gyro": [
        {
          "x": 999.9999,
          "y": 999.9999,
          "z": 999.9999,
          "temp": 39.25
        }
      ],
      "dht22": [
        {
          "temp": 500.25,
          "hum": 82.25
        }
      ]
    }
  ],
  "analog": [
    {
      "24v": [
        {
          "1": 1023,
          "2": 1023,
          "3": 1023,
          "4": 1023
        }
      ],
      "12v": [
        {
          "1": 1023,
          "2": 1023,
          "3": 1023,
          "4": 1023
        }
      ],
      "5v": [
        {
          "1": 1023,
          "2": 1023,
          "3": 1023,
          "4": 1023
        }
      ]
    }
  ],
  "digital": [
    {
      "5v": [
        {
          "1": 255,
          "2": 255
        }
      ],
      "12v": [
        {
          "1": 1,
          "2": 1
        }
      ],
      "24v": [
        {
          "1": 1,
          "2": 1
        }
      ]
    }
  ]
}



#file buat ambil data json dari input.json

$data = file_get_contents('input.json');
$raw = json_decode($data, true);
// echo $data;
// print_r($raw);

#buat akses ke index x,y,z
$accel_x =  $raw['sensor']['0']['accel']['0']['x'];
$accel_y = $raw['sensor']['0']['accel']['0']['y'];
$accel_z = $raw['sensor']['0']['accel']['0']['z'];

#buat masukin data ke database
try{
  $sql = "INSERT INTO coba(accel_x, accel_y, accel_z)VALUES($accel_x,$accel_y,$accel_z)";
  $data = $connection->query($sql);
  $data->setFetchMode(PDO::FETCH_ASSOC);
}catch(PDOException $e ){
  die("Connection Failed!. Try Again!". $e->getMessage());