<?php
include 'ominterior_db.php';

$id = $_GET['id'];
$query = "SELECT photo FROM team_members WHERE id = $id";
$result = $conn->query($query);
$row = $result->fetch_assoc();

if ($row && !empty($row['photo'])) {
    $filePath = "uploads/team_members/" . $row['photo'];
    if (file_exists($filePath)) {
        unlink($filePath); // delete image file
    }

    // Remove image name from DB
    $conn->query("UPDATE team_members SET photo ='' WHERE id = $id");
}

header("Location: edit-team-member.php?id=$id&img_deleted=1");
exit;
?>