====== sql test ====== $servername = "localhost"; $username = "root"; $password = "i18wZJQGe2WDyFSF9X0y"; $dbname = "availability"; // 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 "

"; echo $row["agent"].": "; echo "

"; echo "
"; echo $row["status"]; echo "

"; } } else { echo "0 results"; } mysqli_close($conn);