<?php
    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "booking";

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

//Check connection
if ($conn->connect_error)
{
  die('Could not connect: ' .  $conn->connect_error);
  }

$sql = "SELECT room_id, qty_reserve, arrival, departure,   FROM roominventory";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

    //Outout data of each row
     while($row = $result->fetch_assoc()) {

        echo "<br> room_id: ". $row["room_id"].  $row["qty_reserve"].  $row["arrival"] .  $row["departure"] . "<br>";

        $angavil = $row['qty'] - $inogbuwin;

      echo '<div style="height: 117px;">';
          echo '<div style="float: left; width: 100px; margin-left: 19px;">';
          echo "<img width=92 height=72 alt='Unable to View' src='" . $row["image"] . "'>";
          echo '</div>';
          echo '<div style="float: right; width: 575px; margin-top: -10px;">';
          echo '<span class="style5">'.'Avalable Rooms: '.$angavil.'</span>';
          if ($angavil > 0){
                        echo '<input name="roomid" type="checkbox" value="' .$row["room_id"]. '" />';
                        echo '<input type="submit" name="Submit" value="reserve" onclick="setDifference(this.form);"/>';
                        }
                    if ($angavil <= 0){
                    echo '<span class="style5">'.'wala chansa wala gid vacant'.'</span>';
                    }
          echo '<br>';
          echo '<span class="style5">'.'Room Type: '.$row['type'].'</span><br>';
          echo '<span class="style5">'.'Room Rate: '.$row['rate'].'</span><br>';
              echo '<span class="style5">'.'Max Child: '.$row['max_child'].'</span><br>';
              echo '<input name="mchild" type="hidden" value="' .$row["max_child"]. '" />';
            echo '<input name="avail" type="hidden" value="' .$angavil. '" />';
            echo '<span class="style5">'.'Max Adult: '.$row['max_adult'].'</span><br>';
              echo '<input name="madult" type="hidden" value="' .$row["max_adult"]. '" />';
          echo '<span class="style5">'.'Room Description: '.$row['description'].'</span><br>';
          echo '</div>';
        echo '</div>';

  }

}else {

echo "No rooms currently available for booking!";

}

$conn->close();