include 'config_file.php';

    $message = '';

    $connection = new mysqli($host_name, $host_user, $host_password, $database_name);
    
    
    if ($connection->connect_error)
    {
        die("Connection failed: " . $connection->connect_error);
    }
    
    $json = json_decode(file_get_contents('php://input'), true);
    
    $check_query = "SELECT * FROM Notification_Times_Table WHERE time_key = '$json[key]'";
    
    $result = $connection->query($check_query);
    
    if ($result->num_rows > 0)
    {
        $text = "This time is already in your table.";
        echo json_encode($text);
        $connection->close();
    }
    else{
        $query = "INSERT INTO Notification_Times_Table(time_display, time_key, user) values('$json[time]', '$json[key]', '$json[user]')";
        
        $query_result = $connection->query($query);
        
        if ($query_result === true)
        {
            $message = 'Success!';
        }
        
        else
        {
            $message = 'Error! Try Again.' . $connection->error;
        }
        
        echo json_encode($message);
        
        $connection->close();
    }
?>