<?php
require '../config.php';
require '../functions.php';
checkLogin();

$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>Admin Dashboard</title></head>
<body>
<h1>Dashboard</h1>
<a href="create.php">Add New Car</a> | <a href="logout.php">Logout</a>
<table border="1" cellpadding="5" cellspacing="0">
<tr>
    <th>ID</th>
    <th>Manufacturer</th>
    <th>Model</th>
    <th>Year</th>
    <th>Horsepower</th>
    <th>Actions</th>
</tr>
<?php foreach ($cars as $car): ?>
<tr>
    <td><?php echo $car['id']; ?></td>
    <td><?php echo e($car['manufacturer_name']); ?></td>
    <td><?php echo e($car['model']); ?></td>
    <td><?php echo e($car['year']); ?></td>
    <td><?php echo e($car['horsepower']); ?></td>
    <td>
        <a href="edit.php?id=<?php echo $car['id']; ?>">Edit</a> |
        <a href="delete.php?id=<?php echo $car['id']; ?>" onclick="return confirm('Are you sure?');">Delete</a>
    </td>
</tr>
<?php endforeach; ?>
</table>
</body>
</html>
