1#@!#!123s

��JFIF�� 1#@!#!123s
: / home2 / argusmeast / www / admin-panel / banner /
Filename : edit-banner.php
back
<?php

session_start();
include('../include/connect.php');

if (strlen($_SESSION['alogin']) == 0) {
    header('location:index.php');
} else {
    date_default_timezone_set('Asia/Kolkata'); // Change according to timezone
    $currentTime = date('d-m-Y h:i:s A', time());

    // Get banner ID from URL parameter
    $banner_id = intval($_GET['banner_id']);

    // Fetch existing banner details for the given ID
    $query = mysqli_query($con, "SELECT * FROM banner WHERE banner_id='$banner_id'");
    $row = mysqli_fetch_array($query);

    if (isset($_POST['submit'])) {
        // Handle image upload
        $banner_image = $_FILES["banner_image"]["name"];
        $image_tmp = $_FILES["banner_image"]["tmp_name"];
        $imageFileType = strtolower(pathinfo($banner_image, PATHINFO_EXTENSION));

        // Validate image type (Allow only .webp)
        if (!empty($banner_image) && $imageFileType != "webp") {
            $_SESSION['msg'] = "Only WEBP images are allowed!";
            header("location: edit-banner.php?banner_id=$banner_id"); // Redirect to prevent further execution
            exit();
        }

        // Define the upload directory
        $dir = "banner-images/";
        if (!is_dir($dir)) {
            mkdir($dir, 0777, true);
        }

        // Remove old image if a new one is uploaded
        if (!empty($banner_image)) {
            $old_image = $row['banner_image'];
            if (!empty($old_image) && file_exists($dir . $old_image)) {
                unlink($dir . $old_image);
            }

            // Move uploaded file to the banner-images directory
            move_uploaded_file($image_tmp, $dir . $banner_image);
        } else {
            $banner_image = $row['banner_image']; // Keep existing image if no new image is uploaded
        }

        // Update query
        $sql = mysqli_query($con, "UPDATE banner SET banner_image='$banner_image' WHERE banner_id='$banner_id'");

        if ($sql) {
            $_SESSION['msg'] = "Banner Updated Successfully !!";
        } else {
            $_SESSION['msg'] = "Error updating banner.";
        }
    }
}
?>


    <!DOCTYPE html>

    <html lang="en">



    <head>

        <meta charset="UTF-8">

        <meta name="viewport" content="width=device-width, initial-scale=1.0">

        <title>Argus Computers | Edit Banner | Admin Panel</title>



        <link rel="preconnect" href="https://fonts.gstatic.com">

        <link href="https://fonts.googleapis.com/css2?family=Nunito:wght@300;400;600;700;800&display=swap" rel="stylesheet">

        <link rel="stylesheet" href="../assets/css/bootstrap.css">



        <link rel="stylesheet" href="../assets/vendors/summernote/summernote-lite.min.css">



        <link rel="stylesheet" href="../assets/vendors/sweetalert2/sweetalert2.min.css">



        <link rel="stylesheet" href="../assets/vendors/perfect-scrollbar/perfect-scrollbar.css">

        <link rel="stylesheet" href="../assets/vendors/bootstrap-icons/bootstrap-icons.css">

        <link rel="stylesheet" href="../assets/css/app.css">

        <link rel="shortcut icon" href="../assets/images/logo/argus-favicon.png">

    </head>



    <body>

        <div id="app">

            <div id="sidebar" class="active">

                <div class="sidebar-wrapper active">

                    <?php include('menu.php') ?>

                    <button class="sidebar-toggler btn x"><i data-feather="x"></i></button>

                </div>

            </div>

            <div id="main">

                <header class="mb-3">

                    <a href="#" class="burger-btn d-block d-xl-none">

                        <i class="bi bi-justify fs-3"></i>

                    </a>

                </header>



                <div class="page-heading">

                    <div class="page-title">

                        <div class="row">

                            <div class="col-12 col-md-6 order-md-1 order-last">

                                <h3>Edit Banner</h3>

                            </div>

                            <div class="col-12 col-md-6 order-md-2 order-first">

                                <nav aria-label="breadcrumb" class="breadcrumb-header float-start float-lg-end">

                                    <ol class="breadcrumb">

                                        <li class="breadcrumb-item"><a href="../dashboard.php">Dashboard</a></li>

                                        <li class="breadcrumb-item active" aria-current="page">Edit Banner</li>

                                    </ol>

                                </nav>

                            </div>

                        </div>

                    </div>

                    <section class="section">

                        <div class="row">

                            <form method="POST" enctype="multipart/form-data">

                                <div class="col-12">

                                    <div class="card">

                                        <div class="card-header">

                                            <h4 class="card-title">Banner Image</h4>

                                        </div>

                                        <div class="card-body">

                                            <input class="form-control" type="file" id="formFile" name="banner_image">

                                            <br>

                                            <img src="banner-images/<?php echo $row['banner_id'] ?>/<?php echo $row['banner_image'] ?>" alt="" width="500px" height="250px">

                                        </div>

                                    </div>

                                </div>

                                <div class="col-12">

                                    <div class="card">

                                        <div class="card-body">

                                            <button type="submit" name="submit" class="btn btn-primary">Update Banner</button>

                                            <button type="reset" class="btn btn-danger">Reset</button>

                                            <a href="../banner/manage-banner.php" class="btn btn-success">Go Back</a>

                                        </div>

                                    </div>

                                </div>

                            </form>

                        </div>

                    </section>

                </div>



                <?php include('footer.php') ?>



            </div>

        </div>

        <script src="../assets/vendors/perfect-scrollbar/perfect-scrollbar.min.js"></script>

        <script src="../assets/js/bootstrap.bundle.min.js"></script>

        <script src="../assets/js/extensions/sweetalert2.js"></script>

        <script src="../assets/vendors/sweetalert2/sweetalert2.all.min.js"></script>



        <script src="../assets/vendors/jquery/jquery.min.js"></script>

        <script src="../assets/vendors/summernote/summernote-lite.min.js"></script>



        <script src="../assets/js/main.js"></script>



        <?php if (isset($_SESSION['msg'])) { ?>

            <script>

                Swal.fire({

                    icon: 'success',

                    title: 'Success!',

                    text: "<?php echo $_SESSION['msg']; ?>",

                    showConfirmButton: true

                }).then(function() {

                    window.location = 'edit-banner.php?banner_id=<?php echo $row['banner_id'] ?>';

                });

            </script>

            <?php unset($_SESSION['msg']); ?>

        <?php } ?>

    </body>



    </html>