Differences

This shows you the differences between two versions of the page.

--- sidebar [2019/08/10 17:47] – rileys
+++ sidebar [2020/03/26 19:35] (current) – removed rileys
@@ Line 1: / Line 1: @@
-~~NOCACHE~~
-====== 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>