D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
attraction.encodersunlimited.com
/
attadminraction
/
Filename :
edit_gallery.php
back
Copy
<?php include 'config.php'; if (!isset($_SESSION['admin_name'])) { echo '<script>window.location.href = "login.php";</script>'; exit; } // 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/ashwikalogo.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>Attraction Salon</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 = ['Salon', 'Academy']; foreach ($categories as $cat) { $selected = ($gallery && $gallery['category'] == $cat) ? 'selected' : ''; echo "<option value=\"$cat\" $selected>$cat</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>