<?php
require_once '../config/config.php';

// Check if admin is logged in
if (!is_admin_logged_in()) {
    redirect(SITE_URL . ADMIN_PATH . '/');
}

if (!isset($_GET['id'])) {
    redirect(SITE_URL . ADMIN_PATH . '/manage-surveys.php');
}

$survey_id = (int)$_GET['id'];

// Get survey details to delete image
$sql = "SELECT image FROM survey_sites WHERE id = $survey_id";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $survey = $result->fetch_assoc();
    
    // Delete survey from database
    $delete_sql = "DELETE FROM survey_sites WHERE id = $survey_id";
    
    if ($conn->query($delete_sql)) {
        // Delete image file
        $image_path = '../uploads/' . $survey['image'];
        if (file_exists($image_path)) {
            unlink($image_path);
        }
    }
}

redirect(SITE_URL . ADMIN_PATH . '/manage-surveys.php');
?>