<?php
require 'config.php';

$search = '';
if (isset($_GET['search'])) {
    $search = $_GET['search'];
    $stmt = $pdo->prepare("SELECT cars.*, manufacturers.name AS manufacturer_name
        FROM cars
        JOIN manufacturers ON cars.manufacturer_id = manufacturers.id
        WHERE cars.model LIKE :search OR manufacturers.name LIKE :search");
    $stmt->execute(['search' => "%$search%"]);
} else {
    $stmt = $pdo->query("SELECT cars.*, manufacturers.name AS manufacturer_name
        FROM cars
        JOIN manufacturers ON cars.manufacturer_id = manufacturers.id");
}

$cars = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>

<!DOCTYPE html>
<html>
<head>
    <title>Japanese Sports Cars</title>
</head>
<body>
    <h1>Japanese Sports Cars</h1>
    <form method="get">
        <input type="text" name="search" value="<?php echo e($search); ?>" placeholder="Search cars...">
        <button type="submit">Search</button>
    </form>
    <ul>
        <?php foreach ($cars as $car): ?>
            <li>
                <a href="car.php?id=<?php echo $car['id']; ?>">
                    <?php echo e($car['manufacturer_name'] . ' ' . $car['model'] . ' (' . $car['year'] . ')'); ?>
                </a>
            </li>
        <?php endforeach; ?>
    </ul>
</body>
</html>

