<?php

    $ChannelName = $_POST["ChannelName"];
    $Age = $_POST["Age"];
    $Nationality = $_POST["Nationality"];
    $Description = $_POST["Description"];
    $DisplayName = $_POST["DisplayName"];
    $db_server = "127.0.0.1";
    $db_username = "431PhelanGaming";
    $db_password = "NOT FOR YOUR EYES";
    $db_name = "431PhelanGaming";
    $mysqli = new mysqli($db_server,$db_username,$db_password,$db_name);

    if (mysqli_connect_errno()) {
        printf("Connect failed: %s\n", mysqli_connect_error());
        exit();
    }
    else{
        echo "success";
    }

    $stmt = $mysqli->prepare("INSERT INTO `STREAMERS` (`UUID`, `CHANNELNAME`, `AGE`, `NATIONALITY`, `DESCRIPTION`, `DISPLAYNAME`) VALUES (null, :ChannelName, :Age, :Nationality, :Description, :DisplayName)");
    $stmt->bind_param(':ChannelName', $ChannelName);
    $stmt->bind_param(':Age', $Age);
    $stmt->bind_param(':Nationality', $Nationality);
    $stmt->bind_param(':Description', $Description);
    $stmt->bind_param(':DisplayName', $DisplayName);


    $stmt->execute();

    printf("%d Row inserted.\n", $stmt->affected_rows);

    $stmt->close();


    $mysqli->close();

    echo "test";
?>