D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
tresboutique.in
/
tresadmin
/
Filename :
edit_banner.php
back
Copy
<?php include 'config.php'; // Get banner ID from the URL if (!isset($_GET['id']) || empty($_GET['id'])) { echo '<script>alert("Invalid banner ID."); window.location.href = "banners.php";</script>'; exit; } $bannerId = intval($_GET['id']); // Fetch the existing banner details $query = "SELECT * FROM banners WHERE banner_id = $bannerId"; $result = mysqli_query($conn, $query); if (mysqli_num_rows($result) === 0) { echo '<script>alert("Banner not found."); window.location.href = "banners.php";</script>'; exit; } $banner = mysqli_fetch_assoc($result); // Handle the form submission for updating the banner if ($_SERVER['REQUEST_METHOD'] === 'POST') { $bannerName = mysqli_real_escape_string($conn, $_POST['banner_name']); $bannerLink = mysqli_real_escape_string($conn, $_POST['banner_link']); $updatedImage = $banner['banner_image']; // Default to existing image // Handle banner image upload if provided if (!empty($_FILES['banner_image']['name'])) { $imageName = time() . '_' . $_FILES['banner_image']['name']; $imagePath = 'uploads/banners/' . $imageName; if (move_uploaded_file($_FILES['banner_image']['tmp_name'], $imagePath)) { $updatedImage = $imageName; // Optionally, delete the old image if (!empty($banner['banner_image']) && file_exists('uploads/banners/' . $banner['banner_image'])) { unlink('uploads/banners/' . $banner['banner_image']); } } else { echo '<script>alert("Error uploading image.");</script>'; } } // Update the banner details in the database $updateQuery = "UPDATE banners SET banner_name = '$bannerName', banner_link = '$bannerLink', banner_image = '$updatedImage' WHERE banner_id = $bannerId"; if (mysqli_query($conn, $updateQuery)) { echo '<script>alert("Banner updated successfully."); window.location.href = "banners.php";</script>'; } else { echo '<script>alert("Error updating banner: ' . mysqli_error($conn) . '");</script>'; } } ?> <!DOCTYPE html> <html lang="en"> <head> <?php require('style.php'); ?> </head> <body> <div class="page-wrapper compact-wrapper" id="pageWrapper"> <div class="page-body-wrapper"> <!-- Page Sidebar Start --> <?php require('sidebar.php'); ?> <!-- Page Sidebar End --> <div class="page-body"> <div class="container-fluid"> <div class="page-title"> <h3>Edit Banner</h3> </div> </div> <div class="container-fluid"> <div class="row"> <div class="col-md-6 offset-md-3"> <div class="card"> <div class="card-header"> <h5>Update Banner</h5> </div> <div class="card-body"> <form action="" method="POST" enctype="multipart/form-data"> <div class="mb-3"> <label for="banner_name" class="form-label">Banner Name</label> <input type="text" name="banner_name" id="banner_name" class="form-control" value="<?php echo htmlspecialchars($banner['banner_name']); ?>" required> </div> <div class="mb-3"> <label for="banner_link" class="form-label">Banner Link</label> <input type="url" name="banner_link" id="banner_link" class="form-control" value="<?php echo htmlspecialchars($banner['banner_link']); ?>" required> </div> <div class="mb-3"> <label for="banner_image" class="form-label">Banner Image</label> <input type="file" name="banner_image" id="banner_image" class="form-control"> <small>Current Image:</small> <div> <img src="uploads/banners/<?php echo htmlspecialchars($banner['banner_image']); ?>" alt="Banner Image" style="width: 150px; height: 75px; margin-top: 10px;"> </div> </div> <div class="text-center"> <button type="submit" class="btn btn-primary">Update Banner</button> <a href="banners.php" class="btn btn-secondary">Cancel</a> </div> </form> </div> </div> </div> </div> </div> </div> </div> </div> <?php require('footer.php'); ?> </body> </html>