Untitled

<?php

$dbhost = 'localhost';

$user = 'root';

$password = 'root';

$dbname = 'inventory';

$pdo = new PDO("mysql:host=$dbhost; $dbname", $user, $password);


?>

<html>
<head>
<title>Add to inventory</title>
</head>
<body>
<?php


if(isset($_POST['submit'])) {
						require_once "inventory.php";

                        $stmt = $pdo->prepare("INSERT INTO `cars`(`year`,`make`,`model`,`color`,`price`) VALUES(:year, :make, :model, :color, :price);");

                        $result = $stmt->execute(array(":year" => $_POST['year'],":make" => $_POST['make'],":model" => $_POST['model'],":color" => $_POST['color'],":price" => $_POST['price']));

                        if($result) {
                                echo 'New record was saved.';
                        }else{
                        	echo 'Error occurred';
                        }
                        }
 ?>

<form method="post" action="#">

<p>Year: <input type="text" name="year"/></p>

Make: <select name="make">
<option value="Acura">Acura</option>
<option value="Audi">Audi</option>
<option value="Ferrari">Ferrari</option>
<option value="Infiniti">Infiniti</option>
<option value="Lamborghini">Lamborghini</option>
<option value="Maserati">Maserati</option>
<option value="Tesla">Tesla</option>
</select></p>

Model: <input type="text" name="model"/>
</p>

Color: <select name="color">
<option value="black">Midnight Black</option>
<option value="blue">Clear Sky Blue</option>
<option value="gray">Gunmetal Grey</option>
<option value="white">Cloud White</option>
<option value="yellow">Yellowjacket</option>

</select></p>

Price: <input type="text" name="price"/>

</p>

<input type="submit" value="Add to Inventory" name="submit"/>

</form>

</body>

</html>