<?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">⬅ Back to films</a>
</div>
</article>
<?php
} else {
showMessage("Film not found.");
}
mysqli_stmt_close($stmt);
} else {
showMessage("Database error");
}
?>