<?php
ob_start();
session_start();
include("../connection.php");
include 'header.php';
include 'sidebar.php'; 

// Fetch blog ID from the URL
$id = $_GET["id"];

// Fetch existing blog data from the database
$stmt = $conn->prepare("SELECT * FROM blog WHERE id=?");
$stmt->execute([$id]); 
$blog = $stmt->fetch();

// Check if form is submitted for update
if(isset($_POST['update'])){
    $blog_name = $_POST['blog_name'];
    $description = $_POST['description'];
    $category = $_POST['category'];
    $image1 = $_FILES['img1']['name'];
    $image2 = $_FILES['img2']['name'];
    $image3 = $_FILES['img3']['name'];
    $image4 = $_FILES['img4']['name'];
    $image5 = $_FILES['img5']['name'];

    // Upload each image if provided
    $target1 = "../uploads/" . basename($image1);
    $target2 = "../uploads/" . basename($image2);
    $target3 = "../uploads/" . basename($image3);
    $target4 = "../uploads/" . basename($image4);
    $target5 = "../uploads/" . basename($image5);

    move_uploaded_file($_FILES['img1']['tmp_name'], $target1);
    move_uploaded_file($_FILES['img2']['tmp_name'], $target2);
    move_uploaded_file($_FILES['img3']['tmp_name'], $target3);
    move_uploaded_file($_FILES['img4']['tmp_name'], $target4);
    move_uploaded_file($_FILES['img5']['tmp_name'], $target5);

    // Prepare SQL query based on which images are provided
    if(!empty($image1) && !empty($image2) && !empty($image3) && !empty($image4) && !empty($image5)){
        $sql = "UPDATE `blog` SET `blog_name`=?, `description`=?, `img1`=?, `img2`=?, `img3`=?, `img4`=?, `img5`=?, `category`=? WHERE `id`=?";
        $update = $conn->prepare($sql)->execute([$blog_name, $description, $image1, $image2, $image3, $image4, $image5, $category, $id]);
    } elseif(!empty($image1) && !empty($image2) && !empty($image3) && !empty($image4)){
        $sql = "UPDATE `blog` SET `blog_name`=?, `description`=?, `img1`=?, `img2`=?, `img3`=?, `img4`=?, `category`=? WHERE `id`=?";
        $update = $conn->prepare($sql)->execute([$blog_name, $description, $image1, $image2, $image3, $image4, $category, $id]);
    } elseif(!empty($image1) && !empty($image2) && !empty($image3)){
        $sql = "UPDATE `blog` SET `blog_name`=?, `description`=?, `img1`=?, `img2`=?, `img3`=?, `category`=? WHERE `id`=?";
        $update = $conn->prepare($sql)->execute([$blog_name, $description, $image1, $image2, $image3, $category, $id]);
    } elseif(!empty($image1) && !empty($image2)){
        $sql = "UPDATE `blog` SET `blog_name`=?, `description`=?, `img1`=?, `img2`=?, `category`=? WHERE `id`=?";
        $update = $conn->prepare($sql)->execute([$blog_name, $description, $image1, $image2, $category, $id]);
    } elseif(!empty($image1)){
        $sql = "UPDATE `blog` SET `blog_name`=?, `description`=?, `img1`=?, `category`=? WHERE `id`=?";
        $update = $conn->prepare($sql)->execute([$blog_name, $description, $image1, $category, $id]);
    } else {
        $sql = "UPDATE `blog` SET `blog_name`=?, `description`=?, `category`=? WHERE `id`=?";
        $update = $conn->prepare($sql)->execute([$blog_name, $description, $category, $id]);
    }

    // Check if update was successful
    if($update) {
        header("Location: all-blog.php?msg=success");
        exit(); // Prevent further execution
    } else {
        header("Location: all-blog.php?msg=failed");
        exit(); // Prevent further execution
    }
}
?>

<div class="page-wrapper">
    <div class="content container-fluid">
        <div class="page-header">
            <div class="row">
                <div class="col-sm-12">
                    <h3 class="page-title">Edit Blog</h3>
                    <ul class="breadcrumb">
                        <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>&nbsp; / 
                        <li class="breadcrumb-item active">Edit Blog</li>
                    </ul>
                </div>
                <div class="col-auto text-end float-end ms-auto">
                    <a href="all-blog.php" class="btn btn-outline-info me-2"><i class="fas fa-eye"></i> View</a>
                </div>
            </div>
        </div>

        <div class="row">
            <div class="col-sm-12">
                <div class="card">
                    <div class="card-body">
                        <form action="" method="post" enctype="multipart/form-data">
                            <div class="row">
                                <div class="col-12">
                                    <h5 class="form-title"><span>Blog Details</span></h5>
                                </div>

                                <div class="col-12 col-sm-4">
                                    <div class="form-group">
                                        <label>Blog Name</label>
                                        <input type="text" name="blog_name" class="form-control" value="<?php echo $blog['blog_name']; ?>">
                                    </div>
                                </div>

                                <div class="col-12 col-sm-4">
                                    <div class="form-group">
                                        <label>Category</label>
                                        <input type="text" name="category" class="form-control" value="<?php echo $blog['category']; ?>">
                                    </div>
                                </div>

                                <div class="col-12 col-sm-12">
                                    <div class="form-group">
                                        <label>Blog Image 1</label>
                                        <input type="file" name="img1" class="form-control">
                                        <?php if(!empty($blog['img1'])): ?>
                                            <img height="60" width="60" class="img-responsive" alt="Blog Image 1" src="../uploads/<?php echo $blog['img1']; ?>">
                                        <?php endif; ?>
                                    </div>
                                </div>

                                <div class="col-12 col-sm-12">
                                    <div class="form-group">
                                        <label>Blog Image 2</label>
                                        <input type="file" name="img2" class="form-control">
                                        <?php if(!empty($blog['img2'])): ?>
                                            <img height="60" width="60" class="img-responsive" alt="Blog Image 2" src="../uploads/<?php echo $blog['img2']; ?>">
                                        <?php endif; ?>
                                    </div>
                                </div>

                                <div class="col-12 col-sm-12">
                                    <div class="form-group">
                                        <label>Blog Image 3</label>
                                        <input type="file" name="img3" class="form-control">
                                        <?php if(!empty($blog['img3'])): ?>
                                            <img height="60" width="60" class="img-responsive" alt="Blog Image 3" src="../uploads/<?php echo $blog['img3']; ?>">
                                        <?php endif; ?>
                                    </div>
                                </div>

                                <div class="col-12 col-sm-12">
                                    <div class="form-group">
                                        <label>Blog Image 4</label>
                                        <input type="file" name="img4" class="form-control">
                                        <?php if(!empty($blog['img4'])): ?>
                                            <img height="60" width="60" class="img-responsive" alt="Blog Image 4" src="../uploads/<?php echo $blog['img4']; ?>">
                                        <?php endif; ?>
                                    </div>
                                </div>

                                <div class="col-12 col-sm-12">
                                    <div class="form-group">
                                        <label>Blog Image 5</label>
                                        <input type="file" name="img5" class="form-control">
                                        <?php if(!empty($blog['img5'])): ?>
                                            <img height="60" width="60" class="img-responsive" alt="Blog Image 5" src="../uploads/<?php echo $blog['img5']; ?>">
                                        <?php endif; ?>
                                    </div>
                                </div>

                                <div class="col-12 col-sm-12">
                                    <div class="form-group">
                                        <label>Description</label>
                                        <textarea class="form-control" name="description" id="editor1"><?php echo $blog['description']; ?></textarea>
                                    </div>
                                </div>

                                <div class="col-12">
                                    <button type="submit" name="update" class="btn btn-primary">Update</button>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<script src="https://cdn.ckeditor.com/4.19.1/standard/ckeditor.js"></script>
<script>
    CKEDITOR.replace('editor1');
</script>
<?php include 'footer.php'; ?>