|
Server IP : 172.16.15.8 / Your IP : 3.138.124.28 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/ajzamor/public_html/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!-- housingSearchStyleAct.php
Andrew Zamor -->
<body style="background-color:powderblue;">
<CENTER>
<H2> Search for Roommates </H2>
<HR>
<?php
$careVolume = $_POST["careVolume"];
$volume = $_POST["volume"];
$careMess = $_POST["careMess"];
$mess = $_POST["mess"];
$careTime = $_POST["careTime"];
$time = $_POST["time"];
$host = 'localhost';
$user = 'ajzamor';
$passwd = 'cs389';
$database = 'ajzamor';
$connect = mysqli_connect($host, $user, $passwd);
if ($careVolume == "yes") {
$query = "select * from HOUSING where VOLUME = '$volume'";
mysqli_select_db($connect, $database);
$result_id = mysqli_query($connect, $query);
if($result_id)
{
print '<table border=1>';
print '<TH> FIRST <TH> LAST <TH> GRADE <TH> PHONE <TH> EMAIL <TH> VOLUME <TH> MESS <TH> TIME <TH> ROOM';
while($row = mysqli_fetch_row($result_id))
{ print '<TR>';
foreach ($row as $field)
print "<TD> $field </TD> ";
print '</TR>';
}
}
else
print "Fail.<p>";
mysqli_close($connect);
}
elseif ($careMess == "yes") {
$query = "select * from HOUSING where MESS = '$mess'";
mysqli_select_db($connect, $database);
$result_id = mysqli_query($connect, $query);
if($result_id)
{
print '<table border=1>';
print '<TH> FIRST <TH> LAST <TH> GRADE <TH> PHONE <TH> EMAIL <TH> VOLUME <TH> MESS <TH> TIME <TH> ROOM';
while($row = mysqli_fetch_row($result_id))
{ print '<TR>';
foreach ($row as $field)
print "<TD> $field </TD> ";
print '</TR>';
}
}
else
print "Fail.<p>";
mysqli_close($connect);
}
elseif ($careTime == "yes") {
$query = "select * from HOUSING where TIME = '$time'";
mysqli_select_db($connect, $database);
$result_id = mysqli_query($connect, $query);
if($result_id)
{
print '<table border=1>';
print '<TH> FIRST <TH> LAST <TH> GRADE <TH> PHONE <TH> EMAIL <TH> VOLUME <TH> MESS <TH> TIME <TH> ROOM';
while($row = mysqli_fetch_row($result_id))
{ print '<TR>';
foreach ($row as $field)
print "<TD> $field </TD> ";
print '</TR>';
}
}
else
print "Fail.<p>";
mysqli_close($connect);
}
else {
$query = "select * from HOUSING";
mysqli_select_db($connect, $database);
$result_id = mysqli_query($connect, $query);
if($result_id)
{
print '<table border=1>';
print '<TH> FIRST <TH> LAST <TH> GRADE <TH> PHONE <TH> EMAIL <TH> VOLUME <TH> MESS <TH> TIME <TH> ROOM';
while($row = mysqli_fetch_row($result_id))
{ print '<TR>';
foreach ($row as $field)
print "<TD> $field </TD> ";
print '</TR>';
}
}
else
print "Fail.<p>";
mysqli_close($connect);
}