prepare(" INSERT INTO team_members (name, designation, image, phone, email, social_facebook, social_twitter, social_instagram, sort_order, member_type, status, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW()) "); $stmt->execute([$name, $designation, $image, $phone, $email, $social_facebook, $social_twitter, $social_instagram, $sort_order, $member_type, $status]); $message = 'Team member added successfully!'; } else { // Keep existing image if no new image uploaded if (empty($image)) { $stmt = $db->prepare("SELECT image FROM team_members WHERE id = ?"); $stmt->execute([$id]); $existing = $stmt->fetch(); $image = $existing['image'] ?? ''; } $stmt = $db->prepare(" UPDATE team_members SET name = ?, designation = ?, image = ?, phone = ?, email = ?, social_facebook = ?, social_twitter = ?, social_instagram = ?, sort_order = ?, member_type = ?, status = ? WHERE id = ? "); $stmt->execute([$name, $designation, $image, $phone, $email, $social_facebook, $social_twitter, $social_instagram, $sort_order, $member_type, $status, $id]); $message = 'Team member updated successfully!'; } $action = 'list'; } catch (Exception $e) { $error = 'Error: ' . $e->getMessage(); } break; case 'delete': try { $delete_id = $_POST['id']; // Get image filename before deleting $stmt = $db->prepare("SELECT image FROM team_members WHERE id = ?"); $stmt->execute([$delete_id]); $member = $stmt->fetch(); // Delete team member $stmt = $db->prepare("DELETE FROM team_members WHERE id = ?"); $stmt->execute([$delete_id]); // Delete image if it exists if (!empty($member['image']) && file_exists('../uploads/team/' . $member['image'])) { unlink('../uploads/team/' . $member['image']); } $message = 'Team member deleted successfully!'; } catch (Exception $e) { $error = 'Error deleting: ' . $e->getMessage(); } break; } } } // Get team member data for editing $member_data = null; if ($action === 'edit' && $id > 0) { $stmt = $db->prepare("SELECT * FROM team_members WHERE id = ?"); $stmt->execute([$id]); $member_data = $stmt->fetch(); if (!$member_data) { $error = 'Team member not found!'; $action = 'list'; } } // Get team members list $team_members = []; if ($action === 'list') { $stmt = $db->prepare("SELECT * FROM team_members ORDER BY sort_order ASC, created_at DESC"); $stmt->execute(); $team_members = $stmt->fetchAll(); } include 'includes/header.php'; ?>

Team Member List

Image	Name	Designation	Type	Status	Created	Actions

Name *

Designation *

Phone

Facebook

Twitter

Instagram

Sort Order

Member Type *

Status *

Image

Cancel

Team Member Management

Team Member List

No team members found.