|
Server IP : 172.16.15.8 / Your IP : 3.143.23.38 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/slcebula/public_html/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!--
Name: Lee Cebula
Date: 5/4/09
Instructor: Dr. Wang
Title: proj_search.php
Goal: action page for proj_search.html
-->
<HTML>
<HEAD>
<TITLE>
Results
</TITLE>
</HEAD>
<BODY>
<?php
$search = $_POST['search'];
$server = 'localhost';
$user = 'slcebula';
$pass = 'stce2607';
$mydb = 'slcebula';
$table_name = 'ClassProject';
print "<BODY BGCOLOR=marroon><FONT COLOR=gold>";
print "<CENTER><H1>Table $table_name</H1><HR><BR></FONT>";
$connect = mysql_connect($server, $user, $pass);
if(!$connect)
{
die ("Cannot connect to $server using $user");
}
else
{
$SQLcmd = "SELECT * FROM $table_name WHERE Course = '$search'";
mysql_select_db($mydb);
$results_id = mysql_query($SQLcmd, $connect);
if($results_id)
{
print "<TABLE BORDER=1>";
print "<TH>ID<TH>Gender<TH>Class<TH>Course<TH>Q1<TH>Q2<TH>Q3<TH>Q4<TH>Q5";
while($row=mysql_fetch_row($results_id))
{
print "<TR>";
foreach ($row as $field) print"<TD>$field</TD>";
print "</TR>";
}
print "</TABLE><BR><BR><A HREF=projtemp.php>HOME</A>";
print "<BR><BR><IMG SRC=proj_display.jpg WIDTH=400 HEIGHT=400></CENTER>";
}
else die ("Table Query Failed SQLcmd=$SQLcmd");
mysql_close($connect);
}
?>
</BODY>
</HTML>