<?php
session_start();
if(!isset($_SESSION['admin_id'])) { header("Location: index.php"); exit; }
require '../includes/db.php';

if(isset($_GET['id'])) {
    $id = $_GET['id'];
    
    // Get file name to delete from server
    $stmt = $pdo->prepare("SELECT media_file FROM portfolio WHERE id = ?");
    $stmt->execute([$id]);
    $file = $stmt->fetchColumn();
    
    if($file && file_exists("../assets/uploads/" . $file)) {
        unlink("../assets/uploads/" . $file);
    }

    $del = $pdo->prepare("DELETE FROM portfolio WHERE id = ?");
    $del->execute([$id]);
}
header("Location: dashboard.php");