<?php
$dbhost = 'localhost';
$user = 'root';
$password = 'root';
$dbname = 'inventory';
$pdo = new PDO("mysql:host=" . $dbhost . ";dbname=" . $dbname, $user, $password);
?>
<html>
<head>
<title>Add to Inventory</title>
</head>
<body>
<?php
if($_POST['action']=="create") {
$stmt = $pdo->prepare("INSERT INTO `sedan`(`year`,`make`,`model`,`color`,`price`) VALUES(:year, :make, :model, :color, :price);");
$result = $stmt->execute(array(":year" => $_POST['year'],":make" => $_POST['make'],":model"=> $_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>
<p>
Make:
<select name="carmake">
<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>
<p>
Model: <input name="text" name="model"/>
</p>
<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>
<p>
Price: <input type="text" name="price"/>
</p>
<input type="submit" value="Add to Inventory" name="submit"/>
</form>
</body>
</html>