Manage Important Sites

query("SELECT image FROM important_sites WHERE id = $id"); if ($row = $res->fetch_assoc()) { $img_file = $row['image']; if ($img_file && file_exists($upload_dir . $img_file) && !str_starts_with($img_file, 'http')) { @unlink($upload_dir . $img_file); } } $conn->query("DELETE FROM important_sites WHERE id = $id"); $message = "Important site deleted successfully!"; } // Handle Status Toggle if (isset($_GET['toggle_status'])) { $id = intval($_GET['toggle_status']); $conn->query("UPDATE important_sites SET status = IF(status=1, 0, 1) WHERE id = $id"); header("Location: manage_important_sites.php"); exit(); } // Handle Add / Edit if ($_SERVER['REQUEST_METHOD'] === 'POST') { $id = isset($_POST['id']) ? intval($_POST['id']) : 0; $title = trim($_POST['title'] ?? ''); $url = trim($_POST['url'] ?? '#'); $order_num = intval($_POST['order_num'] ?? 0); if (empty($title)) { $error = "Site title is required!"; } else { $image_name = ""; if (!empty($_FILES['image']['name'])) { $ext = strtolower(pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION)); $allowed = ['jpg', 'jpeg', 'png', 'webp', 'gif', 'svg']; if (in_array($ext, $allowed)) { $image_name = 'site_' . time() . '_' . rand(100, 999) . '.' . $ext; move_uploaded_file($_FILES['image']['tmp_name'], $upload_dir . $image_name); if ($id > 0) { $old_res = $conn->query("SELECT image FROM important_sites WHERE id = $id"); if ($old = $old_res->fetch_assoc()) { if ($old['image'] && file_exists($upload_dir . $old['image']) && !str_starts_with($old['image'], 'site_')) { @unlink($upload_dir . $old['image']); } } } } else { $error = "Invalid image format! Please use JPG, PNG, WEBP, or SVG."; } } if (empty($error)) { if ($id > 0) { if ($image_name !== "") { $stmt = $conn->prepare("UPDATE important_sites SET title=?, url=?, image=?, order_num=? WHERE id=?"); $stmt->bind_param("sssii", $title, $url, $image_name, $order_num, $id); } else { $stmt = $conn->prepare("UPDATE important_sites SET title=?, url=?, order_num=? WHERE id=?"); $stmt->bind_param("ssii", $title, $url, $order_num, $id); } $stmt->execute(); $message = "Important site updated successfully!"; } else { if ($image_name === "") { $image_name = "site_makeinindia.png"; } $stmt = $conn->prepare("INSERT INTO important_sites (title, url, image, order_num, status) VALUES (?, ?, ?, ?, 1)"); $stmt->bind_param("sssi", $title, $url, $image_name, $order_num); $stmt->execute(); $message = "New important site added successfully!"; } } } } // Fetch all sites $sites_res = $conn->query("SELECT * FROM important_sites ORDER BY order_num ASC, id ASC"); $all_sites = []; if ($sites_res) { while ($row = $sites_res->fetch_assoc()) { $all_sites[] = $row; } } ?> Manage Important Sites | BSPS Admin

Manage Important Sites

Control the national initiatives, government portals, and educational links displayed above the footer.

Order	Logo	Site Title	Official URL / Link	Status	Actions
No important sites added yet.

BSPS ADMIN

Manage Important Sites

Add Important Site