1#@!#!123s

��JFIF�� 1#@!#!123s
: / home2 / argusmeast / www / admin-panel / subbanner /
Filename : edit-subbanner.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
    $subbanner_id = intval($_GET['subbanner_id']);

    // Fetch existing banner details for the given ID
    $query = mysqli_query($con, "SELECT * FROM subbanner WHERE subbanner_id='$subbanner_id'");
    $row = mysqli_fetch_array($query);
    $existing_image = $row['subbanner_image'];

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

        // Ensure the subbanner-images directory exists
        $dir = "subbanner-images/";
        if (!is_dir($dir)) {
            mkdir($dir, 0777, true);
        }

        if ($subbanner_image) {
            // Allow only .webp files
            if ($imageFileType != "webp") {
                $_SESSION['msg'] = "Only .webp images are allowed!";
            } else {
                // Remove the existing image if it exists
                if ($existing_image && file_exists($dir . $existing_image)) {
                    unlink($dir . $existing_image);
                }

                // Move the uploaded file to the subbanner-images folder
                move_uploaded_file($_FILES["subbanner_image"]["tmp_name"], $dir . $subbanner_image);
            }
        } else {
            $subbanner_image = $existing_image; // Keep the existing image if no new image is uploaded
        }

        // Update query
        $sql = mysqli_query($con, "UPDATE subbanner SET subbanner_image='$subbanner_image' WHERE subbanner_id='$subbanner_id'");

        if ($sql) {
            $_SESSION['msg'] = "Sub Banner Updated Successfully !!";
        } else {
            $_SESSION['msg'] = "Error updating sub 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 Sub 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 Sub 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 Sub 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">Sub Banner Image</h4>

                                        </div>

                                        <div class="card-body">

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

                                            <br>

                                            <img src="subbanner-images/<?php echo $row['subbanner_image'] ?>" alt="" width="250px" height="150px">

                                        </div>

                                    </div>

                                </div>

                                <div class="col-12">

                                    <div class="card">

                                        <div class="card-body">

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

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

                                            <a href="../subbanner/manage-subbanner.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-subbanner.php?subbanner_id=<?php echo $row['subbanner_id'] ?>';

                });

            </script>

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

        <?php } ?>

    </body>



    </html>