Manage Director's Desk

query("SELECT id FROM director_desk LIMIT 1"); if ($check && $check->num_rows > 0) { $row = $check->fetch_assoc(); $id = $row['id']; $sql = "UPDATE director_desk SET badge=?, title=?, subtitle=?, director_name=?, designation=? {$image_update_sql}, quote=? WHERE id=?"; $types .= "i"; $params[] = $id; $stmt = $conn->prepare($sql); $stmt->bind_param($types, ...$params); $stmt->execute(); } else { $stmt = $conn->prepare("INSERT INTO director_desk (badge, title, subtitle, director_name, designation, quote) VALUES (?, ?, ?, ?, ?, ?)"); $stmt->bind_param("ssssss", $badge, $title, $subtitle, $director_name, $designation, $quote); $stmt->execute(); } $message = "Director's Desk details updated successfully!"; } } // Fetch current details $director = [ 'badge' => "DIRECTOR'S DESK", 'title' => "From Director's Desk", 'subtitle' => "BSPS leadership vision and message for holistic education.", 'director_name' => "Dr. Furkan Saifi", 'designation' => "Principle", 'image' => "secretary_furkan.webp", 'quote' => "BS Public School & AH International School is committed to transforming education through modern curriculum, moral discipline, and holistic development to build real-world careers and empower students for future success.", 'stamp_image' => "images/logo_bsps.png" ]; $res = $conn->query("SELECT * FROM director_desk LIMIT 1"); if ($res && $res->num_rows > 0) { $row = $res->fetch_assoc(); $director = array_merge($director, array_filter($row)); } $img_display = (str_starts_with($director['image'], 'http') || str_starts_with($director['image'], 'images/')) ? $director['image'] : (file_exists($upload_dir . $director['image']) ? $upload_dir . $director['image'] : '../images/' . $director['image']); ?> Manage Director's Desk | BSPS Admin

Director's Desk Configuration

Control the photo, name, title, designation, and message shown in the "From Director's Desk" box.

Top Badge Text

Box Heading

Subtitle Description

Name *

Designation *

Change Photo (Leave empty to keep current)

Director's Message / Quote

Live Box Preview

<?php echo htmlspecialchars($director['director_name']); ?>

“”

BSPS ADMIN

Director's Desk Configuration

Live Box Preview