<?php
require 'config.php';

if (!isset($_GET['id'])) {
    die("Car ID not provided.");
}

$stmt = $pdo->prepare("SELECT cars.*, manufacturers.name AS manufacturer_name
    FROM cars
    JOIN manufacturers ON cars.manufacturer_id = manufacturers.id
    WHERE cars.id = :id");
$stmt->execute(['id' => $_GET['id']]);
$car = $stmt->fetch(PDO::FETCH_ASSOC);

if (!$car) die("Car not found.");
?>

<!DOCTYPE html>
<html>
<head>
    <title><?php echo e($car['manufacturer_name'] . ' ' . $car['model']); ?></title>
</head>
<body>
    <h1><?php echo e($car['manufacturer_name'] . ' ' . $car['model']); ?></h1>
    <p>Year: <?php echo e($car['year']); ?></p>
    <p>Horsepower: <?php echo e($car['horsepower']); ?></p>
    <p>Description: <?php echo e($car['description']); ?></p>
    <a href="index.php">Back to list</a>
</body>
</html>
