Untitled

<html>
<head>
<style>
    table, td {
        border: 1px solid black;
    }
</style>
</head>
<table>
<?php

$servername = "localhost";
$username = "guest";
$password = "guest";
$dbname = "guest";

$conn = mysqli_connect($servername, $username, $password, $dbname);

if(!$conn) {
    die("connection failed: " . mysqli_connect_error());
}

$sql = "SELECT * FROM username1";

$result = mysqli_query($conn, $sql);

if(mysqli_num_rows($result) > 0) {
        while($row = mysqli_fetch_assoc($result)) {
                echo "<tr><td>" . $row['id'] . "</td><td>" . $row['firstname'] . "</td><td>" . $row['lastname'] . "</td><td>" . $row['email'] . "</tr></td><br>";

        }
}
else {
        echo "No results.";
}


mysqli_close($conn);

?>
</table>
</html>