<?php
$dbhost = 'localhost';
$user = 'root';
$password = 'root';
$dbname = 'inventory';
$pdo = new PDO("mysql:host=$dbhost; $dbname", $user, $password);
?>
<html>
<head>
<title>Inventory List</title>
</head>
<body>
<?php
include 'inventory.php';
$list = $pdo->query("SELECT year, make, model, color, price FROM cars ORDER BY price ASC");
$results = $list->fetchAll(PDO::FETCH_OBJ);
?>
<table>
<thead>
<tr>Year</tr>
<tr>Make</tr>
<tr>Model</tr>
<tr>Color</tr>
<tr>Price</tr>
</thead>
<tbody>
<tr>
<?php foreach($results as $entry); ?>
<td><?php echo $entry->year; ?></td>
<td><?php echo $entry->make; ?></td>
<td><?php echo $entry->model; ?></td>
<td><?php echo $entry->color; ?></td>
<td><?php echo $entry->price; ?></td>
<td><a href="edit.php?id=<?php echo $entry->id; ?>">Edit</a>
<a href="delete.php?id=<?php echo $entry->id; ?>">Delete</a></td>
</tr>
</tbody>
</table>
</body>
</html>