Untitled

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