1#@!#!123s

: / home3 / encodto1 / newpcjewellers.in / newadminpc /
Filename : edit_gallery.php
back
<?php
session_start();
include 'config.php';

if (!isset($_SESSION['admin_name'])) {
    echo '<script>window.location.href = "login.php";</script>';
    exit;
}

// Function to handle image upload
function image_upload($file) {
    // Check if the file was uploaded and is valid
    if ($file['error'] == 0) {
        $targetDir = "uploads/";
        $targetFile = $targetDir . basename($file["name"]);
        $imageFileType = strtolower(pathinfo($targetFile, PATHINFO_EXTENSION));
        
        // Check if the file is an image
        $check = getimagesize($file["tmp_name"]);
        if ($check !== false && in_array($imageFileType, ['jpg', 'jpeg', 'png', 'svg'])) {
            // Move the uploaded file to the target directory
            if (move_uploaded_file($file["tmp_name"], $targetFile)) {
                return basename($file["name"]);
            }
        }
    }
    return ''; // Return empty if the upload fails or file is not valid
}

// Check if form is submitted
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Validate and sanitize form inputs
    $name = mysqli_real_escape_string($conn, $_POST['name']);
    $category = mysqli_real_escape_string($conn, $_POST['category']);
    
    // Handle image upload
    $imagePath = '';
    if (isset($_FILES['image']) && $_FILES['image']['error'] != 4) {
        $imagePath = image_upload($_FILES['image']);
    }
    
    // Fetch existing image path if updating
    if (isset($_POST['edit_gallery'])) {
        $id = intval($_POST['id']);
        $query = "SELECT `image` FROM `gallery` WHERE `id`=$id";
        $result = mysqli_query($conn, $query);
        if ($result && mysqli_num_rows($result) > 0) {
            $row = mysqli_fetch_assoc($result);
            if ($imagePath == '') {
                $imagePath = $row['image']; // Retain old image if no new image is uploaded
            }
        }
    }

    // Insert or update gallery details
    if (isset($_POST['add_gallery'])) {
        $query = "INSERT INTO `gallery` (`name`, `category`, `image`) VALUES ('$name', '$category', '$imagePath')";
    } elseif (isset($_POST['edit_gallery'])) {
        $id = intval($_POST['id']);
        $query = "UPDATE `gallery` SET `name`='$name', `category`='$category', `image`='$imagePath' WHERE `id`=$id";
    }

    if (mysqli_query($conn, $query)) {
        header("Location: gallery.php");
        exit;
    } else {
        // Debugging message
        echo "Error updating gallery: " . mysqli_error($conn);
        exit;
    }
}

// Fetch gallery details for editing
$gallery = null;
if (isset($_GET['id'])) {
    $id = intval($_GET['id']);
    $query = "SELECT * FROM `gallery` WHERE `id`=$id";
    $result = mysqli_query($conn, $query);
    if ($result && mysqli_num_rows($result) > 0) {
        $gallery = mysqli_fetch_assoc($result);
    } else {
        // Debugging message
        echo "Gallery not found!";
        exit;
    }
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <?php require('style.php'); ?>
</head>
<body>
    <div class="page-wrapper default-wrapper" id="pageWrapper">
        <div class="page-header">
            <div class="header-wrapper row m-0">
                <div class="header-logo-wrapper col-auto p-0">
                    <div class="logo-wrapper"><a href="index.php"><img class="img-fluid" src="assets/images/newpclogo.png" alt=""></a></div>
                </div>
                <div class="nav-right col-auto ms-auto">
                    <ul class="nav-menus">
                        <li class="profile-nav onhover-dropdown p-0">
                            <div class="d-flex align-items-center profile-media">
                                <img class="b-r-10 img-40" src="assets/images/dashboard/profile.png" alt="">
                                <div class="flex-grow-1">
                                    <span>New PC Jewellery</span>
                                    <p class="mb-0">Welcome Admin</p>
                                </div>
                            </div>
                        </li>
                    </ul>
                </div>
            </div>
        </div>
        <div class="page-body-wrapper default-menu">
            <?php require('sidebar.php') ?>
            <div class="page-body">
                <div class="container-fluid">
                    <div class="page-title">
                        <div class="row">
                            <div class="col-sm-6">
                                <h3><?php echo $gallery ? "Update Gallery" : "Create Gallery"; ?></h3>
                            </div>
                        </div>
                    </div>
                    <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="POST" enctype="multipart/form-data">
                        <div class="container-fluid">
                            <div class="row">
                                <div class="col-sm-12">
                                    <div class="card">
                                        <div class="card-body">
                                            <div class="form theme-form">
                                                <div class="row">
                                                    <div class="col">
                                                        <div class="mb-3">
                                                            <label>Gallery Name</label>
                                                            <input class="form-control" type="text" name="name" placeholder="Gallery Name *" value="<?php echo $gallery ? htmlspecialchars($gallery['name'], ENT_QUOTES, 'UTF-8') : ''; ?>" required>
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="row">
                                                    <div class="col">
                                                        <div class="mb-3">
                                                            <label>Category</label>
                                                            <select class="form-control" name="category" required>
                                                            <option value="">Select Category</option>
                                                            <?php
                                                            $categories = ['Our Members', 'Our Customers', 'Precious Jewelleries'];
                                                            foreach ($categories as $category) {
                                                                $selected = ($gallery && $gallery['category'] == $category) ? 'selected' : '';
                                                                echo "<option value=\"$category\" $selected>$category</option>";
                                                            }
                                                            ?>
                                                        </select>
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="row">
                                                    <div class="col">
                                                        <div class="mb-3">
                                                            <label>Upload Gallery Image</label><br>
                                                            <?php if ($gallery && $gallery['image']): ?>
                                                                <img src="uploads/<?php echo htmlspecialchars($gallery['image'], ENT_QUOTES, 'UTF-8'); ?>" alt="Gallery Image" width="150px"><br>
                                                            <?php endif; ?>
                                                            <input type="file" name="image" placeholder="Upload Image" class="form-control" accept=".jpg, .jpeg, .png, .svg">
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="row">
                                                    <div class="col">
                                                        <button type="submit" class="btn btn-success" name="<?php echo $gallery ? 'edit_gallery' : 'add_gallery'; ?>">
                                                            <?php echo $gallery ? 'Update Gallery' : 'Create Gallery'; ?>
                                                        </button>
                                                        <button type="reset" class="btn btn-outline-secondary">Cancel</button>
                                                    </div>
                                                </div>
                                                <?php if ($gallery): ?>
                                                    <input type="hidden" name="id" value="<?php echo htmlspecialchars($gallery['id'], ENT_QUOTES, 'UTF-8'); ?>">
                                                <?php endif; ?>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
                <?php require('footer.php') ?>
            </div>
        </div>
    </div>
</body>
</html>