Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="UTF-8">
- <title>Product Management Console</title>
- </head>
- <body>
- <?php
- $username = "i7448189";
- $password = "e0e24014f041f71480ad652f5668cadd";
- $host = "127.0.0.1";
- $db = $username;
- $connection = mysqli_connect($host, $username, $password, $db);
- if (mysqli_connect_error()) {
- echo "Failed to connect to MySQL: " . mysqli_connect_error();
- } else {
- echo "<h1>Add product</h1>";
- if (isset($_POST["addSubmit"])) { // Code to check that all collums have values
- if ((!empty($_POST["nameame"])) && (!empty($_POST["description"]))
- && (!empty($_POST["price"])) && (!empty($_POST["cost_price"]))
- && (!empty($_POST["stock"])) && (!empty($_POST["link"]))
- && (!empty($_POST["ean"]))) {
- //Code to add/insert new data into the table
- $query = "INSERT INTO tbl_products (name, description, price, cost_price, stock, ean, link) "
- . "VALUES ('" . $_POST["name"] . "', '" . $_POST["description"] . "', "
- . "'" . $_POST["price"] . "', '" . $_POST["cost_price"] . "', "
- . $_POST["stock"] . ", '" . $_POST["ean"] . "','" . $_POST["link"] . "');";
- $result = mysqli_query($connection, $query);
- //Code to check if the insert query was successful or not
- if ($result == false) {
- echo "<p>Adding product " . $_POST["name"] . " failed.</p>";
- } else {
- echo "<p>The product \"" . $_POST["name"] . "\" has been added to the product "
- . "catalogue. The product details are:"
- . "<ul>"
- . "<li>Name: " . $_POST["name"] . "</li>"
- . "<li>Description: " . $_POST["description"] . "</li>"
- . "<li>Price: £" . $_POST["price"] . "</li>"
- . "<li>Cost price: £" . $_POST["cost_price"] . "</li>"
- . "<li>Stock: " . $_POST["stock"] . "</li>"
- . "<li>EAN (Barcode): " . $_POST["ean"] . "</li>"
- . "<li>Image Link: " . $_POST["link"] . "</li>"
- . "</ul>";
- }
- //Code to display error if user has not added all of the information
- } else {
- echo "<p>Please fill in all of the add form</p>";
- }
- }
- ?>
- <!-- Code to process the form data-->
- <form id="addForm" name="addForm" action="?" method="post">
- <div>
- <label for="addFormname">Product name</label>
- <input id="addFormname" name="name" type="text">
- </div>
- <div>
- <label for="addFormdescription">Product description</label>
- <textarea rows="4" cols="50" id="addFormdescription" name="description"></textarea>
- </div>
- <div>
- <label for="addFormprice">Product price (£)</label>
- <input id="addFormprice" name="price" type="text">
- </div>
- <div>
- <label for="addFormcost_price">Product cost price (£)</label>
- <input id="addFormcost_price" name="cost_price" type="text">
- </div>
- <div>
- <label for="addFormstock">Product stock</label>
- <input id="addFormstock" name="stock" type="text">
- </div>
- <div>
- <label for="addFormean">Product EAN (Barcode)</label>
- <input id="addFormean" name="ean" type="text">
- </div>
- <div>
- <label for="addFormlink">Product image (URL)</label>
- <textarea rows="1" cols="50" id="addFormlink" name="link"></textarea>
- </div>
- <div>
- <input id="addSubmit" name="addSubmit" value="Add product" type="submit">
- </div>
- </form>
- <!-- Code to Update the data within the database -->
- <?php
- if (((!empty($_GET["mode"])) && (!empty($_GET["id"]))) && ($_GET["mode"] == "update")) {
- echo "<h1>Update product</h1>";
- if (isset($_POST["updateSubmit"])) {
- if ((!empty($_POST["name"])) && (!empty($_POST["description"]))
- && (!empty($_POST["price"])) && (!empty($_POST["cost_price"]))
- && (!empty($_POST["stock"])) && (!empty($_POST["link"]))
- && (!empty($_POST["ean"]))) {
- $query = "UPDATE products "
- . "SET name = '" . $_POST["name"] . "', "
- . "description = '" . $_POST["description"] . "', "
- . "price = '" . $_POST["price"] . "', "
- . "cost_price = '" . $_POST["cost_price"] . "', "
- . "stock = " . $_POST["stock"] . ", "
- . "ean = '" . $_POST["ean"] . "', "
- . "link = '" . $_POST["link"] . "' "
- . "WHERE id=" . $_GET['id'] . ";";
- $result = mysqli_query($connection, $query);
- if ($result == false) {
- echo "<p>Updating product " . $_POST["name"] . " failed.</p>";
- } else{
- echo "<p>The product \"" . $_POST["name"] . "\" has been updated in the "
- . "product catalogue. The new product details are:"
- . "<ul>"
- . "<li>Name: " . $_POST["name"] . "</li>"
- . "<li>Description: " . $_POST["description"] . "</li>"
- . "<li>Price: £" . $_POST["price"] . "</li>"
- . "<li>Cost price: £" . $_POST["cost_price"] . "</li>"
- . "<li>Stock: " . $_POST["stock"] . "</li>"
- . "<li>EAN (Barcode): " . $_POST["ean"] . "</li>"
- . "</ul>";
- }
- } else {
- echo "<p>Please fill in all of the data requested in the form.</p>";
- }
- }
- $query = "SELECT * FROM tbl_products WHERE id=" . $_GET["id"] . ";";
- $result = mysqli_query($connection, $query);
- if ($result == false) {
- echo "<p>Failed to find product details. </p>";
- } else {
- $productDetails = mysqli_fetch_array($result, MYSQLI_ASSOC);
- if (empty($productDetails)) {
- echo "<p>No product details were found.</p>";
- }
- }
- ?>
- <!--Code to process update form -->
- <form id="updateForm" name="updateForm" action="<?php echo "?mode=update&id=" . $productDetails["id"]; ?>" method="post">
- <div>
- <label for="updateFormname">Product name</label>
- <input id="updateFormname" name="name" type="text" value="<?php echo $productDetails["name"]; ?>">
- </div>
- <div>
- <label for="updateFormdescription">Product Description</label>
- <textarea rows="4" cols="50" id="updateFormdescription"
- name="description"><?php echo $productDetails["description"]; ?></textarea>
- </div>
- <div>
- <label for="updateFormprice">Product price (£)</label>
- <input id="updateFormprice" name="price" type="text"
- value="<?php echo $productDetails["price"]; ?>">
- </div>
- <div>
- <label for="updateFormcost_price">Product cost price (£)</label>
- <input id="updateFormcost_price" name="cost_price" type="text"
- value="<?php echo $productDetails["cost_price"]; ?>">
- </div>
- <div>
- <label for="updateFormstock">Product stock</label>
- <input id="updateFormstock" name="stock" type="text"
- value="<?php echo $productDetails["stock"]; ?>">
- </div>
- <div>
- <label for="updateFormean">Product EAN (Barcode)</label>
- <input id="updateFormean" name="ean" type="text"
- value="<?php echo $productDetails["ean"]; ?>">
- </div>
- <div>
- <label for="updateFormlink">Product Image</label>
- <textarea rows="1" cols="50" id="updateFormlink"
- name="link"><?php echo $productDetails["link"]; ?></textarea>
- </div>
- <div>
- <input id="updateSubmit" name="updateSubmit" value="Update product" type="submit">
- </div>
- </form>
- <?php
- }
- //Code to delete information from the database
- if (((!empty($_GET["mode"])) && (!empty($_GET["id"]))) && ($_GET["mode"] == "delete")) {
- $query = "SELECT name FROM tbl_products WHERE id=" . $_GET["id"] . ";";
- $result = mysqli_query($connection, $query);
- if ($result == false) {
- echo "<p>Getting product details failed.</p>";
- } else {
- $productDetails = mysqli_fetch_array($result, MYSQLI_ASSOC);
- if (empty($productDetails)) {
- echo "<p>The ID that you entered has not found anything, please try again. </p>";
- } else {
- $query = "DELETE FROM tbl_products WHERE id=" . $_GET["id"] . ";";
- $result = mysqli_query($connection, $query);
- if ($result == false) {
- echo "<p>The product with id of " . $_GET["id"] . " (" . $productDetails["name"]
- . ") has not been deleted.</p>";
- } else {
- echo "<p>The product with id of " . $_GET["id"] . " (" . $productDetails["name"]
- . ") has been deleted.</p>";
- }
- }
- }
- }
- ?>
- <!--Code to check current stock information -->
- <h1>Products in stock</h1>
- <ul>
- <?php
- $query = "SELECT * FROM tbl_products;";
- $result = mysqli_query($connection, $query);
- //Code to display all stock/product information held within the database
- if ($result == false) {
- echo "<p>Unable to retrieve stock information.</p>";
- } else {
- while ($productDetails = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
- ?>
- <li>
- <strong></strong> <?php echo "<img src='",$productDetails["link"],"' width='200' height='200' />"; ?>
- <strong>Name:</strong> <?php echo $productDetails["name"]; ?>,
- <strong>Description:</strong> <?php echo $productDetails["description"]; ?>,
- <strong>Price:</strong> £<?php echo $productDetails["price"]; ?>,
- <strong>Cost price:</strong> £<?php echo $productDetails["cost_price"]; ?>,
- <strong>Stock:</strong> <?php echo $productDetails["stock"]; ?>,
- <strong>EAN (Barcode):</strong> <?php echo $productDetails["ean"]; ?>.
- <a href="?mode=update&id=<?php echo $productDetails["id"]; ?>"
- title="Update <?php echo $productDetails["name"]; ?>">Update</a>
- <a href="?mode=delete&id=<?php echo $productDetails["id"]; ?>"
- title="Delete <?php echo $productDetails["name"]; ?>">Delete</a>
- </li>
- <?php } ?>
- </ul>
- <?php
- }
- mysqli_close($connection); // Disconnect the database connection
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement