Untitled

<?php

$host = "localhost";
$user = "root";
$pass = "";
$db="carded";

$conn = new mysqli($host, $user, $pass, $db);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

if(isset($_POST['insert_data']))
{
	$name= $_POST['name'];
	$ycard= $_POST['ycard'];
	$rcard=0;
	$reason=$_POST['reason'];
	$sql="INSERT INTO players (`name`, `ycard`, `rcard`, `reason`) VALUES ('$name',$ycard, $rcard, '$reason')";
if ($conn->query($sql) === TRUE) {
    echo "New record created successfully </br></br>";
}

}


?>
<!DOCTYPE html>
<html>
<head>
	<title>Carded</title>
</head>
<body>

<form action="<?php $_SERVER ['PHP_SELF']; ?>" method="POST">
<label>Name: </label> <input type="text" name="name"> </br>
<label>Yellow Card: </label>
	<select name="ycard">
		<option value="1">1</option>
		<option value="2">2</option>
	</select><br/>
<label>Reason</label> <input type="text" name="reason"> </br>
	<input type="submit" name ="insert_data" value ="Submit"</input>
</form>


</body>
</html>