I have this code and it is giving me an undefined index for each one can anyone please help me, it's for a college project
PHP SCRIPT:
<?php
require ("db_conn.php");
$con=mysqli_connect($mysql_hostname, $mysql_user, $mysql_password, $mysql_database);
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$FirstName = $_GET['firstname'];
$SurName = $_GET['surname'];
$Club = $_GET['club'];
$Nationality = $_GET['nationality'];
$DOB = $_GET['dob'];
$WorkVisa = $_GET['workvisa'];
$sql= "INSERT into Player(FirstName, SurName, Club, Nationality, DOB, WorkVisa) values ('$FirstName', '$SurName', '$Club', '$Nationality', '$DOB', '$WorkVisa')";
mysqli_query($con,$sql);
echo "row added";
mysqli_close($con);
?>
HTML FORM:
<html>
<body>
<form action="processForm.php" method="get">
Enter Player FirstName:<input type="text" name="firstname"/>
<br/>
Enter Player SurName:<input type="text" name="surname"/>
<br/>
Enter Current Club:<input type="text" name="club"/>
<br/>
Enter Player Nationality:<input type="text" name="nationality"/>
<br/>
Enter Player DOB:<input type="text" name="dob"/>
<br/>
Enter Yes/No for WorkVisa:<input type="text" name="workvisa"/>
<br/>
<input type="submit"/>
</form>
</body>
</html>
