07-30-db/userList.php
<?php
require("authUser.php");

/* Setup the Connection Parameters */
$host = "127.0.0.1";
$user = "nerdarmy";
$pass = "";
$db = "testDB";
$port = 3306;

/* make a connection to the mySQL database */
$connection = mysqli_connect($host, $user, $pass, $db, $port) 
    or die(mysql_error());

?>    

<!DOCTYPE html>
<title>Users Page</title>

<style>
table, th, td {
  border: 1px solid black;
  border-collapse: collapse;
}    
</style>

<?php include("navBar.php"); ?>

<h2>USERS List Page</h2>

<p>
    <a href="userAddEdit.php">Add New User</a>
</p>

<table>
    <tr>
        <th></th>
        <th>UID</th>
        <th>ISADMIN</th>
        <th>USERNAME</th>
        <th>EMAIL</th>
        <th>PASSWORD</th>
        <th></th>
    </tr>
    
<?php
$query = "SELECT * FROM Users";
$result = mysqli_query($connection, $query);
while ($row = mysqli_fetch_assoc($result)) {
?>
    <tr>
        <td><a href="userAddEdit.php?UID=<?php echo($row['UID']); ?>">edit</a></td>
        <td><?php echo($row['UID']); ?></td>
        <td><?php echo($row['ISADMIN']); ?></td>
        <td><?php echo($row["USERNAME"]); ?></td>
        <td><?php echo($row["EMAIL"]); ?></td>
        <td><?php echo($row["PASSWORD"]); ?></td>
        <td><a href="userAddEditPost.php?UID=<?php echo($row['UID']); ?>&killme=true">X</a></td>
    </tr>
<?php
}
?>

</table>