<form action="connect.php" method="POST">
Flavour of your Ice cream: <input type="text" name="flavour"  />
<br>
Description of your Ice cream: <input type="text" name="Description" />
<br>
price of your Ice cream: <input type="number" step="0.01" name="Price" />
<br>
Amount Available of your Ice cream: <input type="number" name="Available" />
<br>
<input type="submit" value="Submit" />
</form>


<?php
if(isset($_POST['flavour']))
{
    $Icecream1 = $_POST['flavour'];
}
if(isset($_POST['Description']))
{
    $Description1 = $_POST['Description'];
}
if(isset($_POST['Price']))
{
    $Price1 = $_POST['Price'];
}
if(isset($_POST['Available']))
{
    $Available1 = $_POST['Available'];
}

if($Icecream1 != "" || $Description1 != "" || $Price1 != "" || $Available1 != "")
{

$servername = "localhost";
$username = "sgoldinglloyd";
$password = "college";
$dbname = "sgoldinglloyd";


static $alreadyConnected = FALSE;

if ($alreadyConnected == FALSE)
{
    $conn = new mysqli($servername, $username, $password, $dbname);
    if ($conn->connect_error)
    {
        die("Connection failed: " . $conn->connect_error);
    }
    echo "Connected successfully";
    $alreadyConnected = TRUE;
}

$sql = "INSERT INTO IceCreams (Flavour, Description, Price, Available) VAlUES ('$Icecream1', '$Description1', '$Price1', '$Available1')";


if($conn->query($sql) == TRUE)
{
    echo " New record created successfully";
}
else
{
    echo " Error: " . $sql . "<br>" . $conn->error;
}
}
?>