Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement