| Server IP : 162.0.232.25 / Your IP : 3.135.219.252 Web Server : LiteSpeed System : Linux premium276.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : kwacuqig ( 988) PHP Version : 8.2.26 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/kwacuqig/sportsmycareer.com/ |
Upload File : |
<?php
include './head.php';
include './navbar.php';
if (isset($_GET['competition'])) {
if (!empty($_GET['competition'])) {
$competition = str_replace('-', ' ', $_GET['competition']);
$run = mysqli_query($conn, "SELECT `cid` FROM `competitions` WHERE `competition`='$competition'") or die(mysqli_error($conn));
$cid = mysqli_fetch_array($run)['cid'];
}
}
function getImageLogo($team)
{
global $conn;
$run = mysqli_query($conn, "SELECT `image` FROM `teams` WHERE `team`='$team'") or die(mysqli_error($conn));
$image = mysqli_fetch_array($run)['image'];
return $image;
}
?>
<header class="page-header" data-background="img/league-table.jpg">
<div class="container">
<h2 style="text-transform:capitalize;"><?php echo $competition; ?></h2>
<div class="bosluk3"></div>
<p><a href="home">Home</a> <i class="flaticon-right-chevron"></i> <a href="competitions.php">Competitions</a> <i class="flaticon-right-chevron"></i> Table</p>
</div>
<!-- end container -->
</header>
<main>
<div class="container">
<div class="sub-navbar">
<a href="fixtures?competition=<?php echo $_GET['competition']; ?>">Fixtures</a>
<a href="results?competition=<?php echo $_GET['competition']; ?>">Results</a>
<a href="table?competition=<?php echo $_GET['competition']; ?>" class="active">Table</a>
</div>
</div>
<!--League Table Overall Alanı-->
<section class="league-fixture-section">
<div class="container">
<div class="row">
<div class="col-12">
<!--League Table Overall-->
<table class="small-league-table">
<tbody>
<tr class="table-second-head">
<th class="table-team">Team</th>
<th class="table-score">W</th>
<th class="table-score">D</th>
<th class="table-score">L</th>
<th class="table-score">GD</th>
<th class="table-score">PTS</th>
</tr>
<?php
$query = "SELECT `teams`.`team`, `teams`.`image`, `competition_teams`.`ctid`, `competition_teams`.`w`, `competition_teams`.`d`,`competition_teams`.`l`,`competition_teams`.`gd`, `competition_teams`.`pts` FROM `teams`,`competition_teams` WHERE `competition_teams`.`cid`=$cid AND `teams`.`tid`=`competition_teams`.`tid` ORDER BY `pts` DESC";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = 1;
while ($row = mysqli_fetch_array($run)) {
?>
<tr>
<td class="table-team">
<span class="team-count">
<?php echo $count; ?>
</span>
<span class="team-flag">
<img src="./teams/<?php echo $row['image']; ?>" alt="" width="60" height="60" style="opacity: 1;">
</span>
<?php echo $row['team']; ?>
</td>
<td class="table-score"><?php echo $row['w']; ?></td>
<td class="table-score"><?php echo $row['d']; ?></td>
<td class="table-score"><?php echo $row['l']; ?></td>
<td class="table-score"><?php echo $row['gd']; ?></td>
<td class="table-score table-pts"><?php echo $row['pts']; ?></td>
</tr>
<?php
$count++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</section>
<?php include './footer.php'; ?>
<script>
document.querySelector("title").innerText = "SMC - <?php echo strtoupper($competition); ?> ~ Table";
document.querySelectorAll("ul.menueffect li a")[2].style.color = "yellow";
</script>