| Server IP : 162.0.232.25 / Your IP : 3.145.112.91 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';
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;
}
$sport = $_POST['option'];
?>
<body>
<main>
<section>
<!-- Friendly Matches -->
<div class="container">
<div class="row">
<div class="col-md-12">
<h2 class="h2-baslik-hizmetler-21 wow fade animated" style="visibility: visible">
Friendly Matches
</h2>
</div>
</div>
</div>
<?php
$query2 = "SELECT * FROM `matches` WHERE `sport`='$sport' ORDER BY `mid` DESC";
$run2 = mysqli_query($conn, $query2) or die(mysqli_error($conn));
$count = mysqli_num_rows($run2);
if ($count > 0) {
while ($row2 = mysqli_fetch_array($run2)) {
if (date('d-M-Y', $row2['date']) == date('d-M-Y', time())) {
?>
<div class="container">
<div class="or-up">
<div class="row">
<div class="col-md-12">
<a href="match.php?mid=<?php echo $row2['mid']; ?>">
<span class="team-flag-upcoming"><img src="./teams/<?php echo getImageLogo($row2['home']); ?>" alt="" width="123" height="141" /><?php echo $row2['home']; ?></span>
<h2 class="h2-baslik-anasayfa-ozel-up wow fade">
<strong>VS</strong>
</h2>
<span class="team-flag-upcoming"><?php echo $row2['away']; ?><img src="./teams/<?php echo getImageLogo($row2['away']); ?>" alt="" width="123" height="141" /></span>
</a>
</div>
</div>
</div>
</div>
<div class="container">
<div class="or-date">
<div class="row">
<div class="col-md-12">
<span class="icon-detailw"><i class="flaticon-timetable icon-r"></i><?php echo date('M d, Y', $row2['date']) . ' - ' . date('H:i', $row2['time']); ?></span>
</div>
</div>
</div>
</div>
<?php
} else {
continue;
}
}
}
$query = "SELECT * FROM `competitions` WHERE `sport`='$sport' ORDER BY `competition` ASC";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
while ($row = mysqli_fetch_array($run)) {
$cid = $row['cid'];
?>
<div class="container">
<div class="row">
<div class="col-md-12">
<h2 class="h2-baslik-hizmetler-21 wow fade animated" style="visibility: visible">
<?php echo $row['competition']; ?>
</h2>
</div>
</div>
</div>
<?php
$query2 = "SELECT * FROM `fixtures` WHERE `cid`=$cid ORDER BY `fid` DESC";
$run2 = mysqli_query($conn, $query2) or die(mysqli_error($conn));
$count = mysqli_num_rows($run2);
if ($count > 0) {
while ($row2 = mysqli_fetch_array($run2)) {
if (date('d-M-Y', $row2['date']) == date('d-M-Y', time())) {
?>
<div class="container">
<div class="or-up">
<div class="row">
<div class="col-md-12">
<a href="match.php?fid=<?php echo $row2['fid']; ?>">
<span class="team-flag-upcoming"><img src="./teams/<?php echo getImageLogo($row2['home']); ?>" alt="" width="123" height="141" /><?php echo $row2['home']; ?></span>
<h2 class="h2-baslik-anasayfa-ozel-up wow fade">
<strong>VS</strong>
</h2>
<span class="team-flag-upcoming"><?php echo $row2['away']; ?><img src="./teams/<?php echo getImageLogo($row2['away']); ?>" alt="" width="123" height="141" /></span>
</a>
</div>
</div>
</div>
</div>
<div class="container">
<div class="or-date">
<div class="row">
<div class="col-md-12">
<span class="icon-detailw"><i class="flaticon-timetable icon-r"></i><?php echo date('M d, Y', $row2['date']) . ' - ' . date('H:i', $row2['time']); ?>
<i class="flaticon-add icon-r1"></i><?php echo $row2['venue']; ?></span>
</div>
</div>
</div>
</div>
<?php
} else {
continue;
}
}
?>
<?php
} else {
?>
<div class="container">
<div class="row d-flex justify-content-center">
<div class="col-12 no-match">No Matches Today</div>
</div>
</div>
<?php
}
}
?>
</section>
</main>