|
Server IP : 172.16.15.8 / Your IP : 3.135.190.107 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/akimiavi/public_html/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!-- SocStat SEARCH (action) | socStatSearch.php -->
<CENTER>
<STYLE>
table {
color: white;
}
img {
border: 5px solid #ffffff;
}
</STYLE>
<BODY style="background-color: hsl(214, 100%, 75%);">
<?php
$number = $_POST['number'];
$goals = $_POST['goals'];
$assists = $_POST['assists'];
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$matches = $_POST['matches'];
$host = 'localhost';
$user = 'akimiavi';
$passwd = 'cs389';
$database = 'akimiavi';
$connect = mysqli_connect($host, $user, $passwd);
$query = "select NUMBER, FNAME, LNAME, GOALS, ASSISTS, MATCHES from SOCSTAT where NUMBER='$number' ";
mysqli_select_db($connect, $database);
$result_id = mysqli_query($connect, $query);
if($result_id)
{
print '<table border=1>';
print '<TH> # <TH> First Name <TH> Last Name <TH> Goals <TH> Assists <TH> Matches ';
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);
?>
<HR>
<P>
<A HREF=socStatHomepage.html>HOME</A> | <A HREF=socStatAdd.html>ADD</A> | <A HREF=socStatDisplay.php>DISPLAY</A>
<P>
</CENTER>