<center>
<H1>Display Results</H1>
<HR>
<?php
 
$host = 'localhost';
 
$user = 'tmrandall';
 
$passwd = 'cs389';
 
$database = 'tmrandall';
 
$connect = mysqli_connect($host, $user, $passwd);
 
$query = "select * from CLIENTS";
// 
print "The query is <i> $query </i> ";
 
mysqli_select_db($connect, $database);
 
$result_id = mysqli_query($connect, $query);
 
if($result_id)
 
{
 
print '<table border=1>';
 
print '<TH> NAME <TH> EMAIL <TH> TOPIC';
 
while($row = mysqli_fetch_row($result_id)
)
 
{ 
print '<TR>';
 
foreach ($row as $field)
 
print "<TD> $field </TD> ";
 
print '</TR>';
}
 
print '</table>';
 
}
 
else
 
print "Fail.<p>";
 
mysqli_close($connect);
?>
</center>
<h3>
<A HREF = project5.html> Assignment 5 Home</A>
<p>
<A HREF= index.html> Back To Home</A>
</h3>