This is an old revision of the document!


TSD Availability

<PHP>

  $servername = "web-db01.cluster-ccrvus27e52v.us-east-1.rds.amazonaws.com";
  $username = "availuser";
  $password = "i18wZJQGe2WDyFSF9X0y";
  $dbname = "availability";
  $statusStyle = "style='font-size:14px;border-style:solid;border-width:1px;border-color:#cbcbcb;background:#f5f5f5'";
  // Create connection
  $conn = mysqli_connect($servername, $username, $password, $dbname);
  // Check connection
  if (!$conn) {
      die("Connection failed: " . mysqli_connect_error());
  }
  $sql = "SELECT * FROM tsd";
  $result = mysqli_query($conn, $sql);
  if (mysqli_num_rows($result) > 0) {
      // output data of each row
      while($row = mysqli_fetch_assoc($result)) {
          echo "<p style='font-weight:bold;'>";
          echo $row["agent"].": ";
          echo "</p>";
          echo "<blockquote ".$statusStyle.">";
          echo $row["status"];
          echo "</blockquote><hr>";
      }
  } else {
      echo "0 results";
  }
  mysqli_close($conn);

</PHP>