<?php

$sensor_accelerometerx = $_POST["accelerometerx"];
$sensor_gyroscopex = $_POST["gyroscopex"];
$sensor_accelerometery = $_POST["accelerometery"];
$sensor_gyroscopey = $_POST["gyroscopey"];
$sensor_accelerometerz = $_POST["accelerometerz"];
$sensor_gyroscopez = $_POST["gyroscopez"];

$user = "cameron";
$password = "password";
$host = "mysensordb.cckpya2bgz7v.eu-west-2.rds.amazonaws.com";
$db_name = "sensors";

$con = mysqli_connect($host,$user,$password,$db_name);

if(isset($_POST["accelerometerx"]))
{
    $sql = "UPDATE mysensordata SET accelerometerx = '".$sensor_accelerometerx."' WHERE idmysensordata = 0;";


}
else if(isset($_POST['gyroscopex']))
{
    $sql = "UPDATE mysensordata SET gyroscopex = '".$sensor_gyroscopex."' WHERE idmysensordata = 0;";


}
if(isset($_POST["accelerometery"]))
{
    $sql = "UPDATE mysensordata SET accelerometery = '".$sensor_accelerometery."' WHERE idmysensordata = 0;";


}


else if(isset($_POST['gyroscopey']))
{
    $sql = "UPDATE mysensordata SET gyroscopey = '".$sensor_gyroscopey."' WHERE idmysensordata = 0;";


}
if(isset($_POST["accelerometerz"]))
{
    $sql = "UPDATE mysensordata SET accelerometerz = '".$sensor_accelerometerz."' WHERE idmysensordata = 0;";


}


else if(isset($_POST['gyroscopez']))
{
    $sql = "UPDATE mysensordataz SET gyroscope = '".$sensor_gyroscopez."' WHERE idmysensordata = 0;";


}

if(mysqli_query($con,$sql))
{
    echo "Data update successful";
}
else
{
    echo "error";
}
mysqli_close($con);

?>