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 | + |