<?php

// php code to Insert data into mysql database from input text
if(isset($_POST['insert']))
{
    $hostname = "localhost";
    $username = "root";
    $password = "REMOVED BY USER";
    $databaseName = "emergelogs";

    // get values form input text and number

    $targetname = $_POST['targetname'];
    $staffname = $_POST['staffname'];
    $actiontaken = $_POST['actiontaken'];
    $description = $_POST['description'];
    $date_of_action = $_POST['date_of_action'];
    $evidence = $_POST['evidence'];

    // connect to mysql database using mysqli

    $connect = mysqli_connect($hostname, $username, $password, $databaseName);

    // mysql query to insert data

    $query = "INSERT INTO modlogs(`targetname`, `staffname`, `actiontaken`, `description`, `date_of_action`, `evidence`) VALUES ('$targetname', '$staffname' ,'$actiontaken', '$description', '$date_of_action', '$evidence')";

//THIS WILL GIVE YOU USEFUL INFORMATION
echo $query;


    $result = mysqli_query($connect,$query);

    // check if mysql query successful

    if($result)
    {
        echo 'Data Inserted';
    }

    else{
        echo 'Data Not Inserted';
    }

    //mysqli_free_result($result);
    mysqli_close($connect);
}

?>