query("INSERT INTO sliders (image) VALUES ('$img')"); } header("Location: index.php?page=sliders"); exit; } if($action == 'delete_slider') { $id = (int)$_POST['id']; $conn->query("DELETE FROM sliders WHERE id=$id"); header("Location: index.php?page=sliders"); exit; } if($action == 'update_popup') { $img = handleUpload($_FILES['image'], 'popups'); if($img) { // activate this one, deactivate others $conn->query("UPDATE popup SET status=0"); $conn->query("INSERT INTO popup (image, status) VALUES ('$img', 1)"); } header("Location: index.php?page=popup"); exit; } if($action == 'add_member') { $name = $conn->real_escape_string($_POST['name']); $designation = $conn->real_escape_string($_POST['designation']); $cell = $conn->real_escape_string($_POST['cell']); $sort_order = (int)$_POST['sort_order']; $img = handleUpload($_FILES['image'], 'members'); if(!$img) $img = ''; // fallback string $conn->query("INSERT INTO board_members (name, designation, cell, image, sort_order) VALUES ('$name', '$designation', '$cell', '$img', $sort_order)"); header("Location: index.php?page=members"); exit; } if($action == 'delete_member') { $id = (int)$_POST['id']; $conn->query("DELETE FROM board_members WHERE id=$id"); header("Location: index.php?page=members"); exit; } if($action == 'update_user_status') { $id = (int)$_POST['id']; $status = $conn->real_escape_string($_POST['status']); $conn->query("UPDATE users SET status='$status' WHERE id=$id"); header("Location: index.php?page=users"); exit; } if($action == 'add_notice') { $title = $conn->real_escape_string($_POST['title']); $category = $conn->real_escape_string($_POST['category']); $content = $conn->real_escape_string($_POST['content']); $img = handleUpload($_FILES['image'], 'notices'); $pdf = handleUpload($_FILES['pdf_file'], 'notices'); if(!$img) $img = ''; if(!$pdf) $pdf = ''; $conn->query("INSERT INTO notices (title, category, image, content, pdf_file) VALUES ('$title', '$category', '$img', '$content', '$pdf')"); header("Location: index.php?page=notices"); exit; } if($action == 'delete_notice') { $id = (int)$_POST['id']; $conn->query("DELETE FROM notices WHERE id=$id"); header("Location: index.php?page=notices"); exit; } if($action == 'add_video') { $title = $conn->real_escape_string($_POST['title']); $code = $conn->real_escape_string($_POST['youtube_code']); // e.g. from https://www.youtube.com/watch?v=XXXX, just XXXX $conn->query("INSERT INTO videos (title, youtube_code) VALUES ('$title', '$code')"); header("Location: index.php?page=videos"); exit; } if($action == 'delete_video') { $id = (int)$_POST['id']; $conn->query("DELETE FROM videos WHERE id=$id"); header("Location: index.php?page=videos"); exit; } if($action == 'add_service') { $title = $conn->real_escape_string($_POST['title']); $title_hi = $conn->real_escape_string($_POST['title_hi']); $description = $conn->real_escape_string($_POST['description']); $description_hi = $conn->real_escape_string($_POST['description_hi']); $icon = $conn->real_escape_string($_POST['icon']); $section = $conn->real_escape_string($_POST['section']); $conn->query("INSERT INTO services (title, title_hi, description, description_hi, icon, section) VALUES ('$title', '$title_hi', '$description', '$description_hi', '$icon', '$section')"); header("Location: index.php?page=services"); exit; } if($action == 'delete_service') { $id = (int)$_POST['id']; $conn->query("DELETE FROM services WHERE id=$id"); header("Location: index.php?page=services"); exit; } if($action == 'add_gallery') { $service_id = (int)$_POST['service_id']; $title = $conn->real_escape_string($_POST['title']); $subtitle = $conn->real_escape_string($_POST['subtitle']); $img = handleUpload($_FILES['image'], 'gallery'); if($img) { $conn->query("INSERT INTO service_gallery (service_id, image, title, subtitle) VALUES ($service_id, '$img', '$title', '$subtitle')"); } header("Location: index.php?page=gallery"); exit; } if($action == 'delete_gallery') { $id = (int)$_POST['id']; $conn->query("DELETE FROM service_gallery WHERE id=$id"); header("Location: index.php?page=gallery"); exit; } if($action == 'upload_constitution') { if(isset($_FILES['pdf_file']) && $_FILES['pdf_file']['error'] == 0) { $ext = strtolower(pathinfo($_FILES['pdf_file']['name'], PATHINFO_EXTENSION)); if($ext == 'pdf') { move_uploaded_file($_FILES['pdf_file']['tmp_name'], '../uploads/constitution.pdf'); } else { $_SESSION['upload_error'] = "Only PDF files are allowed for the Constitution."; } } header("Location: index.php?page=constitution"); exit; } if($action == 'update_dynamic_page') { $id = (int)$_POST['id']; $content = $conn->real_escape_string($_POST['content']); $pdf_file = $_POST['existing_pdf']; if(isset($_FILES['pdf_file']) && $_FILES['pdf_file']['error'] == 0) { $ext = strtolower(pathinfo($_FILES['pdf_file']['name'], PATHINFO_EXTENSION)); if($ext == 'pdf') { $pdf_file = time() . '_' . $_FILES['pdf_file']['name']; move_uploaded_file($_FILES['pdf_file']['tmp_name'], '../uploads/' . $pdf_file); } } $conn->query("UPDATE dynamic_pages SET content='$content', pdf_file='$pdf_file' WHERE id=$id"); header("Location: index.php?page=dynamic_pages&edit=$id&success=1"); exit; } } // Fetch dashboard stats $stats = [ 'members' => $conn->query("SELECT COUNT(*) as c FROM board_members")->fetch_assoc()['c'], 'notices' => $conn->query("SELECT COUNT(*) as c FROM notices")->fetch_assoc()['c'], 'sliders' => $conn->query("SELECT COUNT(*) as c FROM sliders")->fetch_assoc()['c'], 'users' => $conn->query("SELECT COUNT(*) as c FROM users")->fetch_assoc()['c'] ]; ?> Admin Dashboard - Bhartiya Seva
Logo
Admin Panel
Dashboard Manage Sliders Entry Popup Board Members Manage Services Services Gallery Important Sites Notices & News Video Gallery Registered Users Constitution Document Pages Logout

Overview

Admin Admin
Total Members

Notices

Active Sliders

Registered Users

Quick Actions
Update Entry Popup Image Add New Scrolling Notice Add New Board Member
System Info

Database Status: Connected

PHP Version:

Last Login:

Welcome to the management portal. From the left sidebar, you can easily control the dynamic elements of the website. The database structures are fully generated to accommodate CRUD operations for all these sections.

Add New Slider
query("SELECT * FROM sliders ORDER BY id DESC"); while($row = $res->fetch_assoc()): ?>
Update Front-Page Popup
query("SELECT * FROM popup WHERE status=1 LIMIT 1"); if($row = $res->fetch_assoc()): ?>
Currently Active Popup
Add New Board Member / Executive
query("SELECT * FROM board_members ORDER BY sort_order ASC, id DESC"); while($row = $res->fetch_assoc()): $img_src = (strpos($row['image'], 'http') === 0) ? $row['image'] : '../uploads/members/'.$row['image']; ?>
Image Name Designation Cell Order Action
Add News / Notice / Order
query("SELECT * FROM notices ORDER BY id DESC"); while($row = $res->fetch_assoc()): ?>
Date Category Title Media Action
Add YouTube Video
query("SELECT * FROM videos ORDER BY id DESC"); while($row = $res->fetch_assoc()): ?>
Add New Service
query("SELECT * FROM services ORDER BY section ASC, id DESC"); while($row = $res->fetch_assoc()): ?>
Icon Title Section Action
Add Image to Service Gallery
query("SELECT g.*, s.title as service_name FROM service_gallery g JOIN services s ON g.service_id = s.id ORDER BY g.id DESC"); while($row = $res->fetch_assoc()): ?>
Add Important Site / External Link
query("SELECT * FROM important_sites ORDER BY id DESC"); if($res): while($row = $res->fetch_assoc()): $img_src = (strpos($row['image'], 'http') === 0) ? $row['image'] : '../uploads/sites/'.$row['image']; ?>

Registered Users
query("SELECT * FROM users ORDER BY id DESC"); if($res && $res->num_rows > 0): while($row = $res->fetch_assoc()): $type = strtolower($row['type'] ?? 'individual'); $status = strtolower($row['status'] ?? 'pending'); ?>
ID Type Name / Institute Email Phone Status Action
No users found.
Upload Constitution PDF
This will overwrite the current Constitution PDF on the homepage.
Current Constitution
A Constitution PDF is currently active.
View Current PDF
No Constitution PDF found. Please upload one.
Page updated successfully.
query("SELECT * FROM dynamic_pages WHERE id=$id")->fetch_assoc(); ?>
Edit Page:
Back to List
Current PDF: View File
Manage Document Pages
query("SELECT * FROM dynamic_pages ORDER BY id ASC"); if($res && $res->num_rows > 0): while($row = $res->fetch_assoc()): ?>
Title Slug / URL Has PDF Action
page.php?slug= Yes No Edit View
No dynamic pages found. Please run the seed script.
Section under construction or not found.