1#@!#!123s

��JFIF�� 1#@!#!123s
: / home2 / argusmeast / public_html / admin-panel / blog /
Filename : edit-blog.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 blog ID from URL parameter
    $blog_id = intval($_GET['blog_id']);

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

    if (isset($_POST['submit'])) {
        $blog_title = mysqli_real_escape_string($con, $_POST['blog_title']);
        $blog_description = mysqli_real_escape_string($con, $_POST['blog_description']);
        $blog_slug = mysqli_real_escape_string($con, $_POST['blog_slug']);

        // Handle image upload
        $blog_image = $_FILES["blog_image"]["name"];
        if ($blog_image) {
            $dir = "blog-images/$blog_id";
            if (!is_dir($dir)) {
                mkdir($dir);
            }
            move_uploaded_file($_FILES["blog_image"]["tmp_name"], "$dir/" . $blog_image);
        } else {
            $blog_image = $row['blog_image']; // Keep existing image if no new image is uploaded
        }

        // Update query
        $sql = mysqli_query($con, "UPDATE blog SET blog_title='$blog_title', blog_description='$blog_description', blog_image='$blog_image', blog_slug='$blog_slug' WHERE blog_id='$blog_id'");

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

    <!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 Blog | 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 Blog</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 Blog</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">Blog Title</h4>
                                        </div>
                                        <div class="card-body">
                                            <input type="text" name="blog_title" class="form-control" value="<?php echo htmlentities($row['blog_title']); ?>" placeholder="Type the blog title">
                                        </div>
                                    </div>
                                </div>
                                <div class="col-12">
                                    <div class="card">
                                        <div class="card-header">
                                            <h4 class="card-title">Blog Description</h4>
                                        </div>
                                        <div class="card-body">
                                            <textarea id="summernote" name="blog_description"><?php echo htmlentities($row['blog_description']); ?></textarea>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-12">
                                    <div class="card">
                                        <div class="card-header">
                                            <h4 class="card-title">Blog Image</h4>
                                        </div>
                                        <div class="card-body">
                                            <input class="form-control" type="file" id="formFile" name="blog_image">
                                            <p>Current Image: <?php echo htmlentities($row['blog_image']); ?></p>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-12">
                                    <div class="card">
                                        <div class="card-header">
                                            <h4 class="card-title">Blog Slug URL</h4>
                                        </div>
                                        <div class="card-body">
                                            <input type="text" name="blog_slug" class="form-control" value="<?php echo htmlentities($row['blog_slug']); ?>" placeholder="Type the blog slug URL">
                                        </div>
                                    </div>
                                </div>
                                <div class="col-12">
                                    <div class="card">
                                        <div class="card-body">
                                            <button type="submit" name="submit" class="btn btn-primary">Update Blog</button>
                                            <button type="reset" class="btn btn-danger">Reset</button>
                                            <a href="../blog/manage-blog.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>
            $('#summernote').summernote({
                tabsize: 2,
                height: 120,
            });
        </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-blog.php?blog_id=<?php echo $row['blog_id'] ?>';
                });
            </script>
            <?php unset($_SESSION['msg']); ?>
        <?php } ?>
    </body>

    </html>

<?php } ?>