1#@!#!123s

��JFIF�� 1#@!#!123s
: / www / wwwroot / nagalandsuperleague.co.in / admin /
Filename : add_fixture.php
back
<?php
/********************************************************
 * 1. Database Connection
 ********************************************************/
$servername = "localhost";
$username   = "nagalandsuperleague";
$password   = "nagalandsuperleague";
$dbname     = "nagalandsuperleague";

// Directory for image uploads
$target_dir = "../"; 

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

/********************************************************
 * 2. Handle CRUD Actions
 ********************************************************/
$action  = isset($_GET['action']) ? $_GET['action'] : '';
$message = "";

// Create/Update fixture
if (isset($_POST['save'])) {
    // Retrieve form fields
    $id           = $_POST['id'];
    $fixture_date = $_POST['fixture_date'];
    $fixture_time = $_POST['fixture_time'];
    $home_team    = $_POST['home_team'];
    $away_team    = $_POST['away_team'];
    $venue        = $_POST['venue'];
    $league       = $_POST['league'];
    $status       = $_POST['status'];
    $home_score   = $_POST['home_score'];
    $away_score   = $_POST['away_score'];
    
    // These hidden fields store old logos if user doesn't upload new ones
    $old_home_logo = $_POST['old_home_logo'];
    $old_away_logo = $_POST['old_away_logo'];

    // Handle home_logo upload (if provided)
    if (!empty($_FILES['home_logo']['name'])) {
        $home_logo_name  = basename($_FILES['home_logo']['name']);
        $home_logo_target = $target_dir . $home_logo_name;

        // Move uploaded file to ../img/
        if (move_uploaded_file($_FILES['home_logo']['tmp_name'], $home_logo_target)) {
            $home_logo = $home_logo_name; 
        } else {
            // If move fails, keep old file name or set empty
            $home_logo = $old_home_logo;
        }
    } else {
        // No new file uploaded, keep old
        $home_logo = $old_home_logo;
    }

    // Handle away_logo upload (if provided)
    if (!empty($_FILES['away_logo']['name'])) {
        $away_logo_name  = basename($_FILES['away_logo']['name']);
        $away_logo_target = $target_dir . $away_logo_name;

        if (move_uploaded_file($_FILES['away_logo']['tmp_name'], $away_logo_target)) {
            $away_logo = $away_logo_name; 
        } else {
            $away_logo = $old_away_logo;
        }
    } else {
        $away_logo = $old_away_logo;
    }

    if (empty($id)) {
        // INSERT new fixture
        $sql = "INSERT INTO fixtures (
                    fixture_date, fixture_time, home_team, away_team, 
                    home_logo, away_logo, venue, league, status, 
                    home_score, away_score
                ) VALUES (
                    '$fixture_date', '$fixture_time', '$home_team', '$away_team',
                    '$home_logo', '$away_logo', '$venue', '$league', '$status',
                    ".(empty($home_score) ? "NULL" : (int)$home_score).", 
                    ".(empty($away_score) ? "NULL" : (int)$away_score)."
                )";
        if ($conn->query($sql) === TRUE) {
            $message = "New fixture added successfully.";
        } else {
            $message = "Error: " . $conn->error;
        }
    } else {
        // UPDATE existing fixture
        $sql = "UPDATE fixtures SET
                    fixture_date='$fixture_date',
                    fixture_time='$fixture_time',
                    home_team='$home_team',
                    away_team='$away_team',
                    home_logo='$home_logo',
                    away_logo='$away_logo',
                    venue='$venue',
                    league='$league',
                    status='$status',
                    home_score=".(empty($home_score) ? "NULL" : (int)$home_score).",
                    away_score=".(empty($away_score) ? "NULL" : (int)$away_score)."
                WHERE id='$id'";

        if ($conn->query($sql) === TRUE) {
            $message = "Fixture updated successfully.";
        } else {
            $message = "Error: " . $conn->error;
        }
    }

    // Redirect to avoid form re-submission & to refresh pagination
    header("Location: add_fixture.php");
    exit();
}

// Delete fixture
if ($action == 'delete' && isset($_GET['id'])) {
    $id  = $_GET['id'];
    $sql = "DELETE FROM fixtures WHERE id='$id'";
    if ($conn->query($sql) === TRUE) {
        $message = "Fixture deleted successfully.";
    } else {
        $message = "Error: " . $conn->error;
    }
    // Redirect to refresh list
    header("Location: add_fixture.php");
    exit();
}

// Fetch fixture if we are editing
$editFixture = null;
if ($action == 'edit' && isset($_GET['id'])) {
    $id     = $_GET['id'];
    $sql    = "SELECT * FROM fixtures WHERE id='$id'";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        $editFixture = $result->fetch_assoc();
    }
}

/********************************************************
 * 3. Pagination Setup
 ********************************************************/
$limit = 10; // records per page
$page  = isset($_GET['page']) && is_numeric($_GET['page']) ? (int)$_GET['page'] : 1; 
$page  = max($page, 1); // ensure page is at least 1

// Count total records
$countSql     = "SELECT COUNT(*) AS total FROM fixtures";
$countResult  = $conn->query($countSql);
$countRow     = $countResult->fetch_assoc();
$totalRecords = $countRow['total'];

// Calculate total pages
$totalPages = ceil($totalRecords / $limit);

// Calculate the starting record for this page
$start = ($page - 1) * $limit;

// Fetch fixtures for the current page
$sql = "SELECT * FROM fixtures 
        ORDER BY fixture_date DESC, fixture_time DESC 
        LIMIT $start, $limit";
$fixturesResult = $conn->query($sql);
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Fixtures Admin (Upload & Pagination)</title>
    <!-- Bootstrap CSS (CDN) -->
    <link 
        rel="stylesheet"
        href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css"
    >
</head>
<body class="bg-light">
<div class="container mt-5">
    <h1 class="mb-4">Fixtures Management</h1>

    <!-- Display Info/Error messages -->
    <?php if($message): ?>
        <div class="alert alert-info">
            <?php echo $message; ?>
        </div>
    <?php endif; ?>

    <!-- Add / Edit Form -->
    <?php 
    // If editing, fill the form with existing data
    $id            = $editFixture ? $editFixture['id'] : '';
    $fixture_date  = $editFixture ? $editFixture['fixture_date'] : '';
    $fixture_time  = $editFixture ? $editFixture['fixture_time'] : '';
    $home_team     = $editFixture ? $editFixture['home_team'] : '';
    $away_team     = $editFixture ? $editFixture['away_team'] : '';
    $home_logo     = $editFixture ? $editFixture['home_logo'] : '';
    $away_logo     = $editFixture ? $editFixture['away_logo'] : '';
    $venue         = $editFixture ? $editFixture['venue'] : '';
    $league        = $editFixture ? $editFixture['league'] : '';
    $status        = $editFixture ? $editFixture['status'] : 'Upcoming';
    $home_score    = $editFixture ? $editFixture['home_score'] : '';
    $away_score    = $editFixture ? $editFixture['away_score'] : '';
    ?>

    <div class="card mb-4">
        <div class="card-header">
            <?php echo $editFixture ? "Edit Fixture (ID: $id)" : "Add New Fixture"; ?>
        </div>
        <div class="card-body">
            <!-- Enctype for file uploads -->
            <form method="post" action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>" enctype="multipart/form-data">
                <input type="hidden" name="id" value="<?php echo $id; ?>">

                <!-- Hidden fields to preserve old logo filenames if not replaced -->
                <input type="hidden" name="old_home_logo" value="<?php echo htmlspecialchars($home_logo); ?>">
                <input type="hidden" name="old_away_logo" value="<?php echo htmlspecialchars($away_logo); ?>">

                <div class="form-row">
                    <div class="form-group col-md-3">
                        <label for="fixture_date">Fixture Date</label>
                        <input 
                            type="date" 
                            class="form-control" 
                            name="fixture_date" 
                            id="fixture_date"
                            value="<?php echo htmlspecialchars($fixture_date); ?>" 
                            required
                        >
                    </div>
                    <div class="form-group col-md-3">
                        <label for="fixture_time">Fixture Time</label>
                        <input 
                            type="time" 
                            class="form-control"
                            name="fixture_time"
                            id="fixture_time"
                            value="<?php echo htmlspecialchars($fixture_time); ?>" 
                            required
                        >
                    </div>
                    <div class="form-group col-md-3">
                        <label for="home_team">Home Team</label>
                        <input 
                            type="text" 
                            class="form-control" 
                            name="home_team"
                            id="home_team"
                            value="<?php echo htmlspecialchars($home_team); ?>" 
                            required
                        >
                    </div>
                    <div class="form-group col-md-3">
                        <label for="away_team">Away Team</label>
                        <input 
                            type="text" 
                            class="form-control" 
                            name="away_team"
                            id="away_team"
                            value="<?php echo htmlspecialchars($away_team); ?>" 
                            required
                        >
                    </div>
                </div>

                <div class="form-row">
                    <!-- File input for Home Logo -->
                    <div class="form-group col-md-3">
                        <label for="home_logo">Home Logo</label>
                        <input 
                            type="file"
                            class="form-control-file"
                            name="home_logo"
                            id="home_logo"
                        >
                        <?php if(!empty($home_logo)): ?>
                            <small class="text-muted">
                                Current: <?php echo $home_logo; ?>
                            </small>
                        <?php endif; ?>
                    </div>
                    <!-- File input for Away Logo -->
                    <div class="form-group col-md-3">
                        <label for="away_logo">Away Logo</label>
                        <input 
                            type="file"
                            class="form-control-file"
                            name="away_logo"
                            id="away_logo"
                        >
                        <?php if(!empty($away_logo)): ?>
                            <small class="text-muted">
                                Current: <?php echo $away_logo; ?>
                            </small>
                        <?php endif; ?>
                    </div>
                    <div class="form-group col-md-3">
                        <label for="venue">Venue</label>
                        <input 
                            type="text"
                            class="form-control"
                            name="venue"
                            id="venue"
                            value="<?php echo htmlspecialchars($venue); ?>"
                        >
                    </div>
                    <div class="form-group col-md-3">
                        <label for="league">League</label>
                        <input 
                            type="text"
                            class="form-control"
                            name="league"
                            id="league"
                            value="<?php echo htmlspecialchars($league); ?>"
                        >
                    </div>
                </div>

                <div class="form-row">
                    <div class="form-group col-md-3">
                        <label for="status">Status</label>
                        <select class="form-control" name="status" id="status">
                            <option value="Upcoming"  <?php if($status == 'Upcoming')  echo 'selected'; ?>>Upcoming</option>
                            <option value="Live"      <?php if($status == 'Live')      echo 'selected'; ?>>Live</option>
                            <option value="Finished" <?php if($status == 'Finished') echo 'selected'; ?>>Finished</option>
                        </select>
                    </div>
                    <div class="form-group col-md-3">
                        <label for="home_score">Home Score</label>
                        <input 
                            type="number"
                            class="form-control"
                            name="home_score"
                            id="home_score"
                            value="<?php echo htmlspecialchars($home_score); ?>"
                        >
                    </div>
                    <div class="form-group col-md-3">
                        <label for="away_score">Away Score</label>
                        <input 
                            type="number"
                            class="form-control"
                            name="away_score"
                            id="away_score"
                            value="<?php echo htmlspecialchars($away_score); ?>"
                        >
                    </div>
                </div>

                <button type="submit" name="save" class="btn btn-primary">
                    <?php echo $editFixture ? "Update Fixture" : "Add Fixture"; ?>
                </button>
                <?php if($editFixture): ?>
                    <a href="add_fixture.php" class="btn btn-secondary">Cancel</a>
                <?php endif; ?>
            </form>
        </div>
    </div>

    <!-- Fixtures Table -->
    <div class="card">
        <div class="card-header">
            All Fixtures (Page <?php echo $page; ?> of <?php echo $totalPages; ?>)
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-striped mb-0">
                    <thead class="thead-dark">
                        <tr>
                            <th>ID</th>
                            <th>Date</th>
                            <th>Time</th>
                            <th>Home</th>
                            <th>Away</th>
                            <th>Venue</th>
                            <th>League</th>
                            <th>Status</th>
                            <th>Score</th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                    <?php if ($fixturesResult && $fixturesResult->num_rows > 0): ?>
                        <?php while($row = $fixturesResult->fetch_assoc()): ?>
                            <tr>
                                <td><?php echo $row['id']; ?></td>
                                <td><?php echo $row['fixture_date']; ?></td>
                                <td><?php echo $row['fixture_time']; ?></td>
                                <td>
                                    <?php echo $row['home_team']; ?><br>
                                    <?php if(!empty($row['home_logo'])): ?>
                                        <img 
                                            src="<?php echo $target_dir . $row['home_logo']; ?>" 
                                            alt="Home Logo" 
                                            width="40" 
                                            height="40"
                                        >
                                    <?php endif; ?>
                                </td>
                                <td>
                                    <?php echo $row['away_team']; ?><br>
                                    <?php if(!empty($row['away_logo'])): ?>
                                        <img 
                                            src="<?php echo $target_dir . $row['away_logo']; ?>" 
                                            alt="Away Logo" 
                                            width="40" 
                                            height="40"
                                        >
                                    <?php endif; ?>
                                </td>
                                <td><?php echo $row['venue']; ?></td>
                                <td><?php echo $row['league']; ?></td>
                                <td><?php echo $row['status']; ?></td>
                                <td>
                                    <?php 
                                        $homeScore = is_null($row['home_score']) ? "-" : $row['home_score']; 
                                        $awayScore = is_null($row['away_score']) ? "-" : $row['away_score'];
                                        echo $homeScore . " - " . $awayScore; 
                                    ?>
                                </td>
                                <td>
                                    <a 
                                        class="btn btn-sm btn-info" 
                                        href="?action=edit&id=<?php echo $row['id']; ?>"
                                    >
                                        Edit
                                    </a>
                                    <a 
                                        class="btn btn-sm btn-danger" 
                                        href="?action=delete&id=<?php echo $row['id']; ?>"
                                        onclick="return confirm('Are you sure you want to delete this fixture?')"
                                    >
                                        Delete
                                    </a>
                                </td>
                            </tr>
                        <?php endwhile; ?>
                    <?php else: ?>
                        <tr>
                            <td colspan="10" class="text-center">No fixtures found.</td>
                        </tr>
                    <?php endif; ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <!-- Pagination Links -->
    <nav aria-label="Page navigation" class="mt-3">
        <ul class="pagination justify-content-center">
            <!-- Previous Button -->
            <li class="page-item <?php if($page <= 1) echo 'disabled'; ?>">
                <a 
                    class="page-link" 
                    href="?page=<?php echo max(1, $page - 1); ?>"
                    tabindex="-1"
                >Previous</a>
            </li>

            <!-- Numbered Links -->
            <?php for($i = 1; $i <= $totalPages; $i++): ?>
                <li class="page-item <?php if($i == $page) echo 'active'; ?>">
                    <a class="page-link" href="?page=<?php echo $i; ?>">
                        <?php echo $i; ?>
                    </a>
                </li>
            <?php endfor; ?>

            <!-- Next Button -->
            <li class="page-item <?php if($page >= $totalPages) echo 'disabled'; ?>">
                <a 
                    class="page-link" 
                    href="?page=<?php echo min($totalPages, $page + 1); ?>"
                >Next</a>
            </li>
        </ul>
    </nav>

</div>
<!-- Bootstrap JS (CDN) -->
<script 
    src="https://code.jquery.com/jquery-3.5.1.slim.min.js"
></script>
<script 
    src="https://cdn.jsdelivr.net/npm/bootstrap@4.5.2/dist/js/bootstrap.bundle.min.js"
></script>
</body>
</html>

<?php
// Close the database connection
$conn->close();
?>