|
Server IP : 172.16.15.8 / Your IP : 3.15.34.50 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/wrlainezmolina/www/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<CENTER>
<body text="White" style="background-color:DarkBlue;">
<H2>Results of your Coupe</H2>
<P>
<HR>
<P>
<?php
$cyl = $_POST['q1'];
$mod = $_POST['q2'];
$trans = $_POST['q3'];
$count = 0;
$host = 'localhost';
$user = 'wrlainezmolina';
$passwd = 'cs480';
$database = 'wrlainezmolina';
$connect = mysqli_connect($host, $user, $passwd);
$query = "select VEHICLE, CYLINDER, MODEL, TRANSMISSION from Cars where CYLINDER=$cyl and
MODEL ='$mod' and TRANSMISSION ='$trans'";
mysqli_select_db($connect, $database);
$result_id = mysqli_query($connect, $query);
if($result_id)
{
print '<font color="white">';
print '<CENTER>';
print '<table border=1>';
print '<TH> Vehicle Recommendation <TH> Cylinders <TH> Model <TH>
Transmission';
while($row = mysqli_fetch_row($result_id))
{
print '<TR>';
foreach($row as $field)
{
if ($count == 0)
{
print "<TD> $field </TD>";
$CarName = "$field";
$count = 1;
}
else
print "<TD> $field </TD>";
}
print '</TR>';
}
print '</table>';
print '<HR>';
include ("PicsLinks.php");
print '</font>';
print '</CENTER>';
}
else
print "Fail. <P>";
mysqli_close($connect);
?>
</CENTER>