1#@!#!123s

: / home / schoolcampuserp / hpspatna.com / admin /
Filename : topper.php
back
<?php
include('includes/header.php');
include('includes/navbar.php');
include('security.php');


$currentYear = date('Y');
$nextYear = $currentYear + 1;
$currentSession = "$currentYear-" . substr($nextYear, -2);
?>

<div class="container-fluid">
    <?php
    if (isset($_SESSION['status']) && $_SESSION['status'] != "") {
        ?>
        <div class="alert alert-<?php echo ($_SESSION['status_code'] == "success") ? "success" : "danger"; ?> alert-dismissible fade show" role="alert">
            <?php echo $_SESSION['status']; ?>
            <!--<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>-->
        </div>
        <?php
        unset($_SESSION['status']);
        unset($_SESSION['status_code']);
    }
    ?>
    <div class="modal fade" id="addadminprofile" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h6 class="modal-title" id="exampleModalLabel">Add a new topper</h6>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <!--LOGIN FORM PHP-->

                <form action="code.php" method="POST" enctype="multipart/form-data">
                    <div class="modal-body">
                        <div class="form-group">
                            <label>Name</label>
                            <input type="text" name="name" class="form-control form-control-sm" placeholder="Name">
                        </div>
                        <div class="form-group">
                            <label>Class</label>
                            <input type="text" name="class" class="form-control form-control-sm" placeholder="Class">
                        </div>
                        <div class="form-group">
                            <label>Percentage</label>
                            <input type="text" name="percentage" class="form-control form-control-sm" placeholder="Percentage">
                        </div>
                        <div class="form-group">
                            <label>Session</label>
                            <select class="form-control form-control-sm" name="session">
                                <option value="" disabled>Select</option>
                                <?php 
                                for ($startYear = 2020; $startYear <= 2029; $startYear++) {
                                    $endYear = $startYear + 1;
                                    $session = "$startYear-" . substr($endYear, -2);
                                    $selected = ($session === $currentSession) ? "selected" : "";
                                    echo "<option value='$session' $selected>$session</option>";
                                }
                                ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label>Photo</label>
                            <input type="file" name="photo" id="photo" class="form-control form-control-sm">
                        </div>

                    </div>
                    <div class="modal-footer">
                        <button type="submit" name="add_topper_btn" class="btn btn-primary btn-sm">Save</button>
                    </div>
                </form>

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

    


<div class="row">
    <div class="col-md-6">
         <div class="card shadow mb-4">
        <div class="card-header py-2" style="display: flex; justify-content: space-between; align-items: center;">
            <h6 class="m-0 font-weight-bold text-primary">X<sup>th</sup> Topper's List</h6>
            <button type="button" class="btn btn-primary btn-sm" data-toggle="modal" data-target="#addadminprofile">
                Add Topper
            </button>
        </div>
        <div class="card-body">
            <div class="table-responsive">

                <?php
                $query = "SELECT * FROM toppers WHERE class='X'";
                $query_run = mysqli_query($conn, $query);
                ?>

                <table class="table table-striped text-center" id="dataTable" width="100%" cellspacing="0">
                    <thead>
                        <tr>
                            <th>Sl</th>
                            <th>Name</th>
                            <th>Class</th>
                            <th>Percentage</th>
                            <th>Session</th>
                            <th>Photo</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                        if (mysqli_num_rows($query_run) > 0) {
                            $sl = 1;
                            while ($row = mysqli_fetch_assoc($query_run)) {
                        ?>
                                <tr>
                                    <td><?php echo $sl++; ?></td>
                                    <td><?php echo $row['name']; ?></td>
                                    <td><?php echo $row['class']; ?></td>
                                    <td><?php echo $row['percentage']; ?></td>
                                    <td><?php echo $row['session']; ?></td>
                                    <td><img src="<?php echo $row['photo_path']; ?>" height="70" width="70"></img></td>
                                  
                                    <td>
                                        <form action="code.php" method="post">
                                            <input type="hidden" name="toppper_id" value="<?php echo $row['id']; ?>">
                                            <button type="submit" name="topper_delete_btn" class="btn btn-danger btn-sm"> DELETE</button>
                                        </form>
                                    </td>
                                </tr>
                        <?php
                            }
                        } else {
                            echo "No Record Found";
                        }
                        ?>
                    </tbody>
                </table>

            </div>
        </div>
    </div>
    </div>
    <div class="col-md-6">
         <div class="card shadow mb-4">
        <div class="card-header py-2" style="display: flex; justify-content: space-between; align-items: center;">
            <h6 class="m-0 font-weight-bold text-primary">XII<sup>th</sup> Topper's List</h6>
            <button type="button" class="btn btn-primary btn-sm" data-toggle="modal" data-target="#addadminprofile">
                Add Topper
            </button>
        </div>
        <div class="card-body">
            <div class="table-responsive">

                <?php
                $query1 = "SELECT * FROM toppers WHERE class='XII'";
                $query_run1 = mysqli_query($conn, $query1);
                ?>

                <table class="table table-striped text-center" id="dataTable" width="100%" cellspacing="0">
                    <thead>
                        <tr>
                            <th>Sl</th>
                            <th>Name</th>
                            <th>Class</th>
                            <th>Percentage</th>
                            <th>Session</th>
                            <th>Photo</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                        if (mysqli_num_rows($query_run1) > 0) {
                            $sl = 1;
                            while ($row1 = mysqli_fetch_assoc($query_run1)) {
                        ?>
                                <tr>
                                    <td><?php echo $sl++; ?></td>
                                    <td><?php echo $row1['name']; ?></td>
                                    <td><?php echo $row1['class']; ?></td>
                                    <td><?php echo $row1['percentage']; ?></td>
                                    <td><?php echo $row1['session']; ?></td>
                                    <td><img src="<?php echo $row1['photo_path']; ?>" height="70" width="70"></img></td>
                                  
                                    <td>
                                        <form action="code.php" method="post">
                                            <input type="hidden" name="toppper_id" value="<?php echo $row1['id']; ?>">
                                            <button type="submit" name="topper_delete_btn" class="btn btn-danger btn-sm"> DELETE</button>
                                        </form>
                                    </td>
                                </tr>
                        <?php
                            }
                        } else {
                            echo "No Record Found";
                        }
                        ?>
                    </tbody>
                </table>

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

</div>
<!-- /.container-fluid -->

<?php
include('includes/scripts.php');
include('includes/footer.php');
?>