<?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 $row['id'] . " | " . $row['firstname'] . " | " . $row['lastname'] . " | " . $row['email'] . "<br>";
        }
}
else {
        echo "No results.";
}

mysqli_close($conn);


?>