D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
universalhomedecor.in
/
admin
/
Filename :
edit_gallery.php
back
Copy
<?php require('config.php'); require('style.php'); // Check if admin is logged in if (!isset($_SESSION['admin_name'])) { echo '<script> window.location.href = "login.php";</script>'; exit; } // Function to get the current page name function getCurrentPage() { return basename($_SERVER['PHP_SELF']); } // Variable to hold the current page name $current_page = getCurrentPage(); $page_name = pathinfo($current_page, PATHINFO_FILENAME); // Fetch categories $categories = []; $categoryQuery = "SELECT * FROM `product_category`"; $categoryResult = mysqli_query($conn, $categoryQuery); if ($categoryResult) { while ($row = mysqli_fetch_assoc($categoryResult)) { $categories[] = $row; } } // Check if product ID is provided in the URL if (!isset($_GET['id'])) { echo "Gallery ID is missing!"; exit; } $id = intval($_GET['id']); $query = "SELECT * FROM `gallery` WHERE `id`=$id"; $result = mysqli_query($conn, $query); if (!$result || mysqli_num_rows($result) === 0) { echo "Banner not found!"; exit; } $item = mysqli_fetch_assoc($result); $imageSrc = htmlspecialchars($item['image'], ENT_QUOTES, 'UTF-8'); // 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 $imgpath = image_upload($_FILES['image']); // Update product details $query = "UPDATE `gallery` SET `name`='$name', `category`='$category', `image`='$imgpath' WHERE `id`=$id"; if (mysqli_query($conn, $query)) { header("Location: gallery.php"); exit; } else { echo "Error updating product: " . mysqli_error($conn); exit; } } ?> <!DOCTYPE html> <html lang="en"> <head> <?php include('style.php'); ?> </head> <body> <!-- loader starts--> <div class="loader-wrapper"> <div class="loader"> <div class="box"></div> <div class="box"></div> <div class="box"></div> <div class="box"></div> <div class="box"></div> </div> </div> <!-- loader ends--> <!-- tap on top starts--> <div class="tap-top"><i data-feather="chevrons-up"></i></div> <!-- tap on tap ends--> <!-- page-wrapper Start--> <div class="page-wrapper default-wrapper" id="pageWrapper"> <!-- Page Body Start--> <div class="page-body-wrapper default-menu default-menu"> <!-- Page Sidebar Start--> <?php include('sidebar.php') ?> <!-- Page Sidebar Ends--> <div class="page-body"> <div class="container-fluid"> <div class="page-title"> <div class="row"> <div class="col-sm-6 ps-0"> <h3>Edit Gallery</h3> </div> </div> </div> </div> <!-- Container-fluid starts--> <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>?id=<?php echo $id; ?>" 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>Product Name</label> <input type="text" name="name" id="name" class="form-control" value="<?php echo $item['name']; ?>"> </div> </div> </div> <div class="row"> <div class="col-sm-4"> <div class="mb-3"> <label for="category" class="form-label">Category</label> <select class="form-control" id="category" name="category"> <?php foreach ($categories as $category) { $selected = ($item['category'] == $category['category_name']) ? 'selected' : ''; echo '<option value="' . htmlspecialchars($category['id'], ENT_QUOTES, 'UTF-8') . '" ' . $selected . '>' . htmlspecialchars($category['category_name'], ENT_QUOTES, 'UTF-8') . '</option>'; } ?> </select> </div> </div> </div> <div class="row"> <div class="col"> <div class="mb-3"> <label>Upload project file</label> <h4>Drop files here or click to upload.</h4><span class="note needsclick">(This is just a demo dropzone. Selected files are <strong>not</strong> actually uploaded.)</span><br> <input type="file" name="image" placeholder="Upload Image" class="form-control" accept=".jpg, .jpeg, .png, .svg" required> </div> </div> </div> </div> </div> <div class="row"> <div class="modal-footer"> <button type="submit" class="btn btn-success" name="edit_gallery">Update Gallery</button> <button type="reset" class="btn btn-outline-secondary" data-bs-dismiss="modal">Cancel</button> </div> </div> </div> </div> </div> </div> </div> </form> <!-- Container-fluid Ends--> </div> <!-- footer start--> <footer class="footer"> <div class="container-fluid"> <div class="row"> <div class="col-md-6 p-0 footer-copyright"> <p class="mb-0">Copyright 2024 © Crocs theme by pixelstrap.</p> </div> <div class="col-md-6 p-0"> <p class="heart mb-0">Hand crafted & made with <svg class="footer-icon"> <use href="https://admin.pixelstrap.net/crocs/assets/svg/icon-sprite.svg#heart"></use> </svg> </p> </div> </div> </div> </footer> </div> </div> <!-- latest jquery--> <?php include('footer.php') ?> </body> </html>