View difference between Paste ID: W5tas7J9 and VjBfUdtF
SHOW: | | - or go back to the newest paste.
1
<?php
2-
2+
$dbhost = 'localhost'; 
3-
$dbhost = 'localhost';
3+
4-
4+
$password = 'root'; 
5
$dbname = 'inventory'; 
6-
6+
$pdo = new PDO("mysql:host=" . $dbhost . ";dbname=" . $dbname, $user, $password); 
7-
$password = 'root';
7+
8-
8+
9-
$dbname = 'inventory';
9+
	<head>
10-
10+
		<title>Add to Inventory</title>
11-
$con = mysql_connect($dbhost, $user, $password);
11+
	</head>
12-
12+
	<body>
13-
13+
		<?php 
14-
mysql_connect($dbname);
14+
		if($_POST['action']=="create") {
15-
15+
			$stmt = $pdo->prepare("INSERT INTO `sedan`(`year`,`make`,`model`,`color`,`price`) VALUES(:year, :make, :model, :color, :price);");
16-
16+
			$result = $stmt->execute(array(":year" => $_POST['year'],":make" => $_POST['make'],":model"=> $_POST['color'],":price"=> $_POST['price']));
17
			if($result) {
18
				echo 'New record was saved.';
19-
<title>Add to Inventory</title>
19+
			} else{
20-
<head>
20+
				echo 'Error occurred';
21-
</head>
21+
			}
22-
<body>
22+
		?> 
23
		<form method="post" action="#">
24-
require_once "inventory.php";
24+
			<p>Year: <input type="text" name="year" /></p>
25-
25+
			<p>
26-
if($_POST['action']='create"){
26+
				Make: 
27-
include 'inventory.php';
27+
				<select name="carmake">
28-
$sql = "INSERT INTO sedan ( year, make, model, color, price)
28+
					<option value="Acura">Acura</option>
29-
29+
					<option value="Audi">Audi</option>
30-
('{$_POST['year']}','{$_POST['make']}', '{$_POST['model']}', '{$_POST['color']}', '{$_POST['price']}')";
30+
					<option value="Ferrari">Ferrari</option>
31-
31+
					<option value="Infiniti">Infiniti</option>
32-
if (mysql_query($sql){
32+
					<option value="Lamborghini">Lamborghini</option>
33-
echo 'New record was saved.';
33+
					<option value="Maserati">Maserati</option>
34-
} else{
34+
					<option value="Tesla">Tesla</option>
35-
echo 'Error occurred';
35+
				</select>
36-
}
36+
			</p>
37
			<p>
38-
38+
				Model: <input name="text" name="model"/>
39-
<form method="post" action="#">
39+
			</p>
40-
<table>
40+
			<p>
41-
<TD>
41+
				Color: 
42-
<tr>
42+
				<select name="color">
43-
<p>Year: <input type="text" name="year"/></p></tr>
43+
					<option value="black">Midnight Black</option>
44-
Make: <select name="carmake">
44+
					<option value="blue">Clear Sky Blue</option>
45-
<option value="Acura">Acura</option>
45+
					<option value="gray">Gunmetal Grey</option>
46-
<option value="Audi">Audi</option>
46+
					<option value="white">Cloud White</option>
47-
<option value="Ferrari">Ferrari</option>
47+
					<option value="yellow">Yellowjacket</option>
48-
<option value="Infiniti">Infiniti</option>
48+
				</select>
49-
<option value="Lamborghini">Lamborghini</option>
49+
			</p>
50-
<option value="Maserati">Maserati</option>
50+
			<p>
51-
<option value="Tesla">Tesla</option>
51+
				Price: <input type="text" name="price"/>
52-
</select></p>
52+
			</p>
53-
Model: <input name="text" name="model"/>
53+
			<input type="submit" value="Add to Inventory" name="submit"/>
54-
</p>
54+
		</form>
55-
Color: <select name="color"> 
55+
	</body>
56-
<option value="black">Midnight Black</option>
56+