<?php
$servername = "nitroxtech.c48qi7cc3kyh.us-west-1.rds.amazonaws.com";
$username = "NitroxAdmin";
$password = "5tgjkl123";

// Create connection
$conn = new mysqli($servername, $username, $password, "StorageDBWebAppMainDatabase");

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT unitId, rateAmount FROM FacilitiesUnits WHERE facilityId=" . htmlspecialchars($_GET["id"]);
$units = $conn->query($sql);
$rowArray = array();
$idArray = array();
$priceArray = array();
if ($units->num_rows > 0) {
    // output data of each row
    while($row = $units->fetch_assoc()) {
        // echo "Name: " . $row["name"]. "<br>";
        // array_push($rowArray, $row);
        array_push($idArray, $row['unitId']);
        array_push($priceArray, $row['rateAmount']);
        // echo json_encode($row);
        // echo($row['unitId']);
    }
} else {
    echo "0 results";
}

// echo json_encode($priceArray);


$sql = "SELECT * FROM Units WHERE id IN";
$sql .= "(";

for ($x = 0; $x < count($idArray); $x++) {
    $sql .= $idArray[$x];
    if ($x != count($idArray) - 1) {
        $sql .= ", ";
    } else {
        $sql .= ")";
    }
}

$result = $conn->query($sql);
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        // echo "Name: " . $row["name"]. "<br>";
        // array_push($rowArray, $row);
        array_push($rowArray, $row);
        // echo json_encode($row);
        // echo($row['unitId']);
    }
} else {
    echo "0 results";
}

for ($x = 0; $x < count($rowArray); $x++) {
    $rowArray[$x]['price'] = $priceArray[$x];
}



// echo $sql;

echo json_encode($rowArray);

$conn->close();
?>