query("CREATE TABLE IF NOT EXISTS banners ( id INT PRIMARY KEY AUTO_INCREMENT, image VARCHAR(255) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP )"); // Auto-initialize about_image setting if missing $conn->query("INSERT IGNORE INTO settings (setting_key, setting_value) VALUES ('about_image', 'banner.png')"); $message = ""; // Handle Settings Updates if(isset($_POST['update_whatsapp'])) { if(!empty($_POST['whatsapp_number'])) { updateSetting('whatsapp_number', $_POST['whatsapp_number']); $message = "WhatsApp number updated!"; } } // Handle Banner Addition if(isset($_POST['add_banner'])) { if(!empty($_FILES['banner_image']['name'])) { $banner = "banner_" . time() . "_" . $_FILES['banner_image']['name']; if(move_uploaded_file($_FILES['banner_image']['tmp_name'], "../assets/img/" . $banner)) { $stmt = $conn->prepare("INSERT INTO banners (image) VALUES (?)"); $stmt->bind_param("s", $banner); $stmt->execute(); $message = "Banner added successfully!"; } } } // Handle Banner Deletion if(isset($_GET['delete_banner'])) { $id = intval($_GET['delete_banner']); $res = $conn->query("SELECT image FROM banners WHERE id = $id"); if($row = $res->fetch_assoc()) { $img_path = "../assets/img/" . $row['image']; if(file_exists($img_path)) unlink($img_path); $conn->query("DELETE FROM banners WHERE id = $id"); $message = "Banner deleted!"; } } // Handle About Image Update if(isset($_POST['update_about_image'])) { if(!empty($_FILES['about_image']['name'])) { $about_img = "about_" . time() . "_" . $_FILES['about_image']['name']; if(move_uploaded_file($_FILES['about_image']['tmp_name'], "../assets/img/" . $about_img)) { updateSetting('about_image', $about_img); $message = "About Us image updated!"; } } } ?>

Site Settings

Contact Details

window.location.href='settings.php';"; } ?>

About Us Image

Homepage Banner Slider

Add New Banner

Existing Banners

query("SELECT * FROM banners ORDER BY id DESC"); if($banners->num_rows > 0): while($b = $banners->fetch_assoc()): ?>

Preview	Action
	Delete
No banners found. Please add one.