Untitled

<html>
<body>
<h2 align="center">Add New Player</h2>
<p align="center">
<a href="index.php">Home<br></a>

<?php

if(isset($_POST['insert'])){

    $playername = $_POST[player_name_];
    $username_ = $_POST[player_handle_];
    $team = $_POST[player_team_];
    $position = $_POST[player_position_];
    $origincountry = $_POST[player_country_];

    echo nl2br("Insert Pressed \n ");
    echo $type;

$servername = "localhost";
$username = "james";
$password = "student";
$dbname = "OpticGaming";

$link = @mysqli_connect('localhost','james','student', 'OpticGaming');

    if (!$link) {
    die('Connect Error: ' . mysqli_connect_error());
    }

    $sql = "INSERT INTO
    players(player_id, player_name, player_handle, player_team, player_country, player_position)
    VALUES (0, '$playername', '$username_', '$team', '$origincountry', $position)";

    $result = mysqli_query($link, $sql);

    if($result)
    {
        echo n12br("Records inserted successfully\n");
    } else {
           echo "Error: " . $sql . "<br>" . mysqli_error($link);
    }
}

?>
<form  method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
Player's Full Name:<br> <input type="text" name="player_name_"><br>
Player's Handle:<br> <input type="text" name="player_handle_"><br>
Player's Team:<br> <input type="text" name = "player_team_"><br>
Player's Country:<br> <input type"text" name = "player_country_"><br>
Player's Position:<br> <input type"text" name = "player_position_"><br>
<input type="submit" value="Insert" name="insert"/>
</form>
</body>
</html>