Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>
- Lab 12
- </title>
- </head>
- <body>
- <H1>Please provide the information about your product:</h1>
- <form action="<?php $_SERVER['PHP_SELF'];?>" method="get">
- Product's name:<input type="text" name="name"> <font color=red>*</font><br/><br/>
- Product's maker:<input type="text" name="maker"><br/><br/>
- Product's amount:<input type="text" name="amount"><br/><br/>
- Product's price:<input type="text" name="price"><br/><br/>
- <input type="submit" value="Add Record" name="add">
- <input type="submit" value="Find the Item with the Highest Price" name="highest">
- <input type="submit" value="Display All" name="displayAll"><br/><br/>
- <input type="submit" value="Group by Maker" name="groupByMaker">
- <input type="submit" value="Sort Items by Amount Descendly" name="sort">
- <input type="submit" value="Find the Average Price of all items" name="average"><br/><br/>
- <input type="submit" value="Delete Record by ID" name="delete"> ID to remove: <input type="text" name="id"><br/><br/>
- <input type="submit" value="Show by Maker" name="showByMaker"> Maker: <input type="text" name="maker2show"><br/><br/>
- </form>
- <hr/>
- <?php
- require_once("my_DB_functions.php");
- $conn = My_Connect_DB();
- // ADD RECORD
- if ($_GET["add"])
- {
- if (!empty($_GET["name"]))
- {
- $sql = "INSERT INTO Products (name, maker, amount, price) VALUES('".$_GET['name']."', '".$_GET['maker']."', '".$_GET['amount']."', '".$_GET['price']."');";
- Run_SQL_Show_Table($conn, $sql, "Products");
- }
- else
- echo "Product's name cannot be empty! Please try again.";
- }
- // ITEM WITH HIGHEST PRICE
- if ($_GET["highest"])
- {
- $sql = "SELECT name, maker, amount, price FROM Products WHERE price
- IN (SELECT MAX(price) FROM Products)";
- Run_Select_Show_Table($conn, $sql);
- }
- // DISPLAY ALL PRODUCTS
- if ($_GET["displayAll"])
- {
- $sql = "SELECT * FROM Products;";
- Run_Select_Show_Table($conn, $sql);
- }
- // GROUP BY MAKER
- if ($_GET["groupByMaker"])
- {
- $sql = "SELECT maker, SUM(amount) AS 'TotalItems'
- FROM Products GROUP BY maker ORDER BY TotalItems DESC;";
- Run_Select_Show_Table($conn, $sql);
- }
- // SORT ITEMS DESC
- if ($_GET["sort"])
- {
- $sql = "SELECT * FROM Products ORDER BY amount DESC;";
- Run_Select_Show_Table($conn, $sql);
- }
- // AVERAGE PRICE
- if ($_GET["average"])
- {
- $sql = "SELECT AVG(price) AS 'Average price of all products' FROM Products;";
- Run_Select_Show_Table($conn, $sql);
- }
- // DELETE
- if ($_GET["delete"])
- {
- $sql = "DELETE FROM Products WHERE id = '".$_GET['id']."';";
- Run_SQL_Show_Table($conn, $sql, "Products");
- }
- // SHOW BY MAKER
- if ($_GET["showByMaker"])
- {
- $sql = "SELECT name, maker, amount, price FROM Products WHERE maker='".$_GET['maker2show']."';";
- Run_Select_Show_Table($conn, $sql);
- }
- mysqli_close();
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement