<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Test Output</title>
</head>
<body>
<h1>Output</h1>
<?PHP
$db_location="localhost";
$db_username="d123456t";
$db_password="YourPassword";
$db_database="d123456t";
$db_Connection=mysqli_connect("$db_location","$db_username","$db_password","$db_database") or die("Could not connect to the database");
$customers = mysqli_query($db_Connection, "SELECT * FROM CUSTOMER ORDER BY LastName ASC") or die("This Query didn't work");
$numRecords = mysqli_num_rows($customers);
echo $numRecords." number of customers<br><br>";
echo "<table border='1'>";
echo "<tr>
<th>Last Name</th>
<th>First Name</th>
<th>Phone</th>
<th>Email Address</th>
</tr>";
while ($row = mysqli_fetch_array($customers))
{
echo "<tr>";
echo "<td>".$row["LastName"]."</td>";
echo "<td>".$row["FirstName"]."</td>";
echo "<td>".$row["Phone"]."</td>";
echo "<td>".$row["Email"]."</td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($db_Connection);
?>
</body>
</html>