1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live / user /
Filename : sports-prediction.php
back
<?php
session_start();
error_reporting(0);
include('../../config/conn.php');
include('includes/checklogin.php');
include 'includes/functions.php';


error_reporting(E_ALL);
ini_set('display_errors', 1);

check_login();
$title="Sports Predictions";
include 'includes/header.php'; 
$today = date("Y-m-d");

$uid = $_SESSION['id'];
$username = $_SESSION['username'];
$sql = "SELECT * FROM `users` WHERE `id`=$uid";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);
$sports_balance = $row['sports'];

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['predict'])) {
    $match_id = sanitize_input($_POST['match_id']);
    $score_team1 = sanitize_input($_POST['score_team1']);
    $score_team2 = sanitize_input($_POST['score_team2']);

    $predicted_score = $score_team1 . "-" . $score_team2;

    $query = "INSERT INTO sports_predictions (user_id, match_id, predicted_score, created_at) VALUES ('$uid', '$match_id', '$predicted_score', NOW())";
    if (mysqli_query($con, $query)) {
        $msg = "Prediction submitted successfully!";
        $type = "success";
    } else {
        $msg = "Error submitting prediction. Try again later.";
        $type = "warning";
    }
}

?>

<div class="container min-h-dvh relative overflow-hidden py-8 dark:text-white -z-10 dark:bg-color1">
<!-- Page Title Start -->
<div class="relative z-10 px-6 pb-20">
        <div class="flex justify-between items-center gap-4">
          <div class="flex justify-start items-center gap-4">
            <h2 class="text-2xl font-semibold text-white">
            Sports Prediction
            </h2>
          </div>
        </div>

        <div class="pt-8">
          <div
            class="py-6 px-5 bg-white dark:bg-color9 border border-dashed border-p1 rounded-xl"
            style="margin-top:20px;"
            >
            <div
              class="flex justify-between items-center  border-p1"
            >
           
            Predict the outcome of matches and win big
            </div> 
          </div>
            <!-- End Page Title -->
          <br>
            <!-- Display Messages -->
            <?php if(isset($msg)) { ?>
                        <div class="error-wrapper-<?php echo $type?>">
                        <span class="message-<?php echo $type?>"><?php echo $msg; ?></span>
                        </div>
             <?php }?>

             <div class="grid grid-cols-1 gap-5 pt-5 text-center">
                    <?php 
                    $query = "SELECT * FROM sports_matches WHERE match_date >= '$today' ORDER BY match_date ASC";
                    $result = mysqli_query($con, $query);
                    $current_time = date("H:i:s"); // Get current server time

                    if (mysqli_num_rows($result) > 0) {
                        while ($row = mysqli_fetch_assoc($result)) {
                            $match_id = $row['id'];
                            $team1 = $row['team1'];
                            $team2 = $row['team2'];
                            $match_date = date("jS F, Y", strtotime($row['match_date']));
                            $match_time = $row['match_time'];

                            // Convert match time to timestamp and add 30 minutes
                            $match_datetime = strtotime($row['match_date'] . ' ' . $match_time);
                            $prediction_deadline = strtotime("+5 minutes", $match_datetime);
                            $now = time();

                            // Check if the user has already submitted a prediction for this match
                            $check_query = "SELECT * FROM sports_predictions WHERE user_id = '$uid' AND match_id = '$match_id'";
                            $check_result = mysqli_query($con, $check_query);
                            $prediction_exists = mysqli_num_rows($check_result) > 0;

                    ?>
                    
                    <div class="py-5 px-4 rounded-xl bg-white flex justify-center items-center flex-col relative dark:bg-color9">
                        <p class="text-lg font-semibold"><?php echo $team1; ?> vs <?php echo $team2; ?></p>
                        <p class="text-xs pb-3">Match Date: <?php echo $match_date; ?> | Time: <?php echo date("h:i A", strtotime($match_time)); ?></p>

                        <?php 
                        if ($prediction_exists) { ?>
                            <p class="text-green-500 font-semibold">Prediction submitted ✅</p>
                        <?php 
                        } elseif ($now > $prediction_deadline) { ?>
                            <p class="text-red-500 font-semibold">Prediction closed ⏳</p>
                        <?php 
                        } else { ?>
                            <form action="#" method="post">
                                <input type="hidden" name="match_id" value="<?php echo $match_id; ?>">
                                <div class="flex gap-2">
                                    <input type="number" name="score_team1" placeholder="Team 1 Score" required class="border px-3 py-2 rounded-md text-black" style="width:48%;">
                                    <span class="text-lg font-semibold">-</span>
                                    <input type="number" name="score_team2" placeholder="Team 2 Score" required class="border px-3 py-2 rounded-md text-black" style="width:48%;">
                                </div>
                                <button type="submit" name="predict" class="mt-2 px-4 py-2 bg-p2 text-white rounded-md">Submit Prediction</button>
                            </form>
                        <?php } ?>
                    </div>

                    <?php } } else { ?>
                        <div class="text-center mt-20">
                            <h4>No matches available for prediction.</h4>
                            <p>Check back later for upcoming matches.</p>
                        </div>
                    <?php } ?>
                </div>


                </div>
            </div>
        </div>
    </div>
</div>

<?php include 'includes/footer.php'; ?>