<?php
$dbhost = 'localhost';
$user = 'root';
$password = 'root';
$dbname = 'inventory';
$con = new PDO ('mysql : host = localhost; $dbname = inventory', $user, $password);
?>
<html>
<head>
<title>Add to Inventory</title>
</head>
<body>
<?php
include "inventory.php";
$add = isset($_POST['add']) ? $_POST['add'] : '';
if ( $add == 'add'){
include 'inventory.php';
try {
$query = "INSERT INTO sedan SET year = ?, make = ?, model = ?, color = ?, price = ?"
$stmt=$con->prepare($query);
$stmt->bindParam(1, $_POST['year']);
$stmt->bindParam(2, $_POST['make']);
$stmt->bindParam(3, $_POST['model']);
$stmt->bindParam(4, $_POST['color']);
$stmt->bindParam(5, $_POST['price']);
$stmt->execute();
echo 'New car added';
} catch (PDOException $exception){
echo "Error: " . $exception->getMessage();
}
}
?>
<form method="post" action="#">
<p>Year: <input type="text" name="year"/></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>
Model: <input name="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>