<?php
    
require_once "./Functions/Films/getFilmImagePath.php";
    require_once 
"./Functions/Films/formatFilmDuration.php";

    if (!isset(
$_GET["film_id"])) {
        
showMessage("No film selected");
        return;
    }

    
$film_id intval($_GET["film_id"]);

    
$query "SELECT title, duration, ageLimit, releaseYear, issuedDate, overview FROM citeLeParis_film WHERE pk_filmID = ?";
    
$stmt mysqli_prepare($dbc$query);

    if (
$stmt) {
        
mysqli_stmt_bind_param($stmt"i"$film_id);
        
mysqli_stmt_execute($stmt);
        
$result mysqli_stmt_get_result($stmt);
        
$film mysqli_fetch_assoc($result);

        if (
$film) {
                
$fullImagePath getFilmImagePath($film["title"], $film["imagePath"] ?? "Assets/Images/Films/");
                
$durationMinutes $film["duration"];
                
$formattedDuration formatFilmDuration($durationMinutes);
            
?>
            <article class="film-detail">
                <header>
                    <h1><?= htmlspecialchars($film["title"]) ?></h1>
                </header>

                <img src="<?= htmlspecialchars($fullImagePath?>" alt="<?= htmlspecialchars($film["title"]) ?>"
                    onerror="this.onerror=null; this.src='Assets/Images/Icons/image_not_found.svg';">

                <section class="film-info">
                    <p><strong>Duration:</strong> <?= htmlspecialchars($formattedDuration?> (<?= $durationMinutes ?> minutes)</p>
                    <p><strong>Age Limit:</strong> <?= htmlspecialchars($film["ageLimit"]) ?>+</p>
                    <p><strong>Release Year:</strong> <?= htmlspecialchars($film["releaseYear"] ?? 'N/A'?></p>
                    <p><strong>Issued Date:</strong> <?= htmlspecialchars($film["issuedDate"] ?? 'N/A'?></p>

                    <?php if (!empty($film["overview"])): ?>
                        <p><strong>Overview:</strong><br><?= nl2br(htmlspecialchars($film["overview"])) ?></p>
                    <?php endif; ?>
                </section>
                <div>
                    <a href="index.php?page=films" class="btn">&#11013; Back to films</a>
                </div>
            </article>
            <?php
        
} else {
            
showMessage("Film not found.");
        }

        
mysqli_stmt_close($stmt);
    } else {
        
showMessage("Database error");
    }
?>