<?php

$servername = "localhost:3306";
$username = "xgx2741";
$password = "Izaacmarc20";
$dbname = "PostDB";
$statcode = "";
$status = "";
$share = "";
$date = "";
$ptype = "";


if($_SERVER["REQUEST_METHOD"] == "POST") {

    $statcode = user_input($_POST["statcode"]);

    if(strcmp($_POST["statcode"]) == 0){
        echo "<span style = 'font-size: 30px; font-family: Arial, tahoma, sans-serif; color: red'> Please Enter a valid Status Code    </span>;";
    } else {
        $statcode = user_input($_POST["statcode"]);
    }

    if(strcmp($_POST["status"]) == 0) {
        echo "<span style = 'font-size: 16px; font-family: Arial, tahoma, sans-serif; color: red'> Please Enter a Status</span>;";
    } else {
        $status = user_input($_POST["status"]);
    }

    if(strcmp($_POST["share"]) == 0) {
        echo "<span style = 'font-size: 16px; font-family: Arial, tahoma, sans-serif; color: red'> Opps you forgot to select a share preference</span>;";
    } else {
        $share = user_input($_POST["share"]);
    }

    $date = user_input($_POST["date"]);

    if(strcmp($_POST["ptype"]) == 0) {
        echo "<span style = 'font-size: 16px; font-family: Arial, tahoma, sans-serif; color: red'> Opps you forgot to select a permission type</span>;";
    } else {
        $ptype = user_input($_POST["ptype"]);
    }


}

function user_input($data)
{
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    return $data;
}

echo $statcode;
echo $status;
echo $share;
echo $date;
echo $ptype;

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

 $sql = "CREATE TABLE StatusData {
statcode VARCHAR(10) NOT NULL,
status VARCHAR(80) NOT NULL,
share VARCHAR(50),
datetime VARCHAR(10),
ptype VARCHAR(50)
)}";

if ($conn->query($sql) === TRUE) {
    echo "Table has been successfully created";
} else {
    echo "Error creating table: " . $conn->error;
}


$sql = "INSERT INTO StatusData (statcode, status, share, datetime, ptype)
VALUES ($statcode, $status, $share, $date, $ptype)";

if ($conn->query($sql) === TRUE) {
    echo "New Status Successfully Updated";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();


?>