|
Server IP : 172.16.15.8 / Your IP : 18.225.175.230 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/www/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!-- FootyFanatic MADRID STATS (madridStats.php) -->
<HEAD>
<meta charset="UTF-8">
<title>Footy Fanatic: Real Madrid</title>
<STYLE>
<!-- STYLING LINKS/IMAGES/BUTTONS -->
a:link {
color: black;
background-color: transparent;
text-decoration: underline;
text-transform: uppercase;
}
a:visited {
color: black;
background-color: transparent;
text-decoration: underline;
text-transform: uppercase;
}
img {
border: 5px solid #000000;
width: 70%;
height: auto;
box-shadow: 10px 10px 5px;
}
body {
font-family: 'American Typewriter', serif;
background-color: hsl(0, 100%, 100%);
color: black;
font-size: 20px;
}
h1 {
font-family: 'luminari', fantasy;
text-transform: uppercase;
color: black;
font-size: 36px;
}
h2 {
font-family: 'luminari', fantasy;
text-transform: uppercase;
color: black;
font-size: 30px;
}
h3 {
font-family: 'luminari', fantasy;
text-transform: uppercase;
color: black;
font-size: 24px;
}
h4 {
font-family: 'luminari', fantasy;
text-transform: uppercase;
color: black;
font-size: 18px;
}
button {
text-transform: uppercase;
text-align: center;
color: black;
width: 100px;
height: 100px;
border-radius: 50%;
display: inline-block;
box-shadow: 10px 10px 5px;
border: 5px solid #000000;
}
button:hover {
transform: scale(1.2);
}
nav {
display: flex;
position: fixed;
width: 120px;
justify-content: space-around;
flex-direction: column;
color: black;
opacity: 0.7;
box-shadow: 10px 10px 5px;
height: 100vh;
}
.content{
margin-left: 120px;
padding: 20px;
width: calc(100% - 120px); /* account for nav section */
text-align: center;
padding-right: 30px;
padding-left: 30px;
}
.container{
display: flex;
min-height: 100vh;
}
.stats-container {
display: flex;
justify-content: space-between;
}
.column {
flex: 1;
width: 48%;
padding: 10px;
text-align: center;
}
table {
text-align: center;
}
</STYLE>
</HEAD>
<BODY>
<HEADER>
<h1>Footy Fanatic</h1>
<!-- ADD IMAGE -->
<HR>
</HEADER>
<div class="container">
<NAV>
<button onclick="location.href='madridPlayers.html'" style="background-color:hsl(0, 100%, 100%)">LEGENDS</BUTTON>
<button onclick="location.href='madridStats.php'" style="background-color:hsl(0, 100%, 100%)">RECORDS</BUTTON>
<button onclick="location.href='madridQuiz.html'" style="background-color:hsl(0, 100%, 100%)">QUIZ</BUTTON>
<button onclick="location.href='footyFanatic.html'" style="background-color:hsl(0, 100%, 100%)">HOME</BUTTON>
</NAV>
<div class="content">
<h1>Real Madrid All-Time Stat Leaders</h1>
<img src="https://cdn.vox-cdn.com/thumbor/mtZwLhMe0iznFxgFGk_kBi1qsJo=/0x0:5000x3327/1200x800/filters:focal(2100x1264:2900x2064)/cdn.vox-cdn.com/uploads/chorus_image/image/54032317/654874836.0.jpg" title="Real Madrid">
<BR>
<BR>
<div class="stats-container">
<div class="column">
<h2>GOALS</h2>
<?php
$host = 'localhost';
$user = 'akimiavi';
$passwd = 'cs389';
$database = 'akimiavi';
$connect = new mysqli($host, $user, $passwd, $database);
$query = "select * from MADRIDGOALS";
$result_id = $connect->query($query);
if ($result_id)
{
print '<table border=1>';
print '<TH> # <TH> First Name <TH> Last Name <TH> Goals ';
while($row = $result_id->fetch_row())
{
print '<TR>';
foreach ($row as $field)
print "<TD> $field </TD>";
print '<TR>';
}
print '</table>';
}
else
print "Fail.<P>";
$connect->close();
?>
<!-- <P> -->
</div>
<div class="column">
<h2>APPEARANCES</h2>
<?php
$host = 'localhost';
$user = 'akimiavi';
$passwd = 'cs389';
$database = 'akimiavi';
$connect = new mysqli($host, $user, $passwd, $database);
$query = "select * from MADRIDAPPS";
$result_id = $connect->query($query);
if ($result_id)
{
print '<table border=1>';
print '<TH> # <TH> First Name <TH> Last Name <TH> Apps ';
while($row = $result_id->fetch_row())
{
print '<TR>';
foreach ($row as $field)
print "<TD> $field </TD>";
print '<TR>';
}
print '</table>';
}
else
print "Fail.<P>";
$connect->close();
?>
<!-- <P> -->
</div>
<div class="column">
<h2>TRANSFERS (IN)</h2>
<?php
$host = 'localhost';
$user = 'akimiavi';
$passwd = 'cs389';
$database = 'akimiavi';
$connect = new mysqli($host, $user, $passwd, $database);
$query = "select * from MADRIDBUYS";
$result_id = $connect->query($query);
if ($result_id)
{
print '<table border=1>';
print '<TH> First Name <TH> Last Name <TH> Transfer Fee (M) <TH> Club <TH> Year ';
while($row = $result_id->fetch_row())
{
print '<TR>';
foreach ($row as $field)
print "<TD> $field </TD>";
print '<TR>';
}
print '</table>';
}
else
print "Fail.<P>";
$connect->close();
?>
<!-- <P> -->
</div>
</div>
<HR>
<CENTER>
<a href='footyFanatic.html'>HOME</A> | <a href='footyMadrid.html'>MADRID HOME</A>
</CENTER>
</div>
</div>
</BODY>