<?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);
?>
</body>
</html>