Welcome Admin, ".$_SESSION['username']."";
?>
Player Info
alert('Please fill all required fields')";
} else {
// Construct SQL queries
$query_basic = "INSERT INTO Player (first_name, middle_name, last_name, email, phone_number, nationality, dob, age)
VALUES('$first_name', '$middle_name', '$last_name', '$email', '$phone_number', '$nationality', '$dob', '$age')";
// Execute SQL query for Players table
$result1 = mysqli_query($conn, $query_basic);
// Check for query execution success
if ($result1) {
// Insertion into Players table successful, get the last inserted player_id
$player_id = mysqli_insert_id($conn);
// Construct SQL queries for Player_Education and Player_Training tables
$query_education = "INSERT INTO Player_Education (player_id, degree, institution, passing_year) VALUES('$player_id', '$degree', '$institution', '$passing_year')";
$query_training = "INSERT INTO Player_Training (player_id, academy, specialization) VALUES('$player_id', '$academy', '$specialization')";
$query_login = "INSERT INTO Player_Login (player_id, username, password) VALUES('$player_id','$username', '$password')";
// Execute SQL queries for Player_Education and Player_Training tables
$result2 = mysqli_query($conn, $query_education);
$result3 = mysqli_query($conn, $query_training);
$result4 = mysqli_query($conn, $query_login);
// Check for query execution success
if ($result2 && $result3 && $result4) {
// Insert into Registration table
$query_registration = "INSERT INTO Registration (player_id) VALUES ('$player_id')";
$query_contract = "INSERT INTO Contracts (player_id) VALUES ('$player_id')";
$result5 = mysqli_query($conn, $query_registration);
$result6 = mysqli_query($conn, $query_contract);
if ($result5 && $result6) {
// Insertion into Contracts table successful, read the contract_id from Contracts table
$contract_id = mysqli_insert_id($conn);
//insert into installment table
$query_installment = "INSERT INTO Installment (contract_id) VALUES ('$contract_id')";
$result7 = mysqli_query($conn, $query_installment);
if($result7){
echo "";
header('location:display.php');
}
} else {
echo "";
echo "Error: " . mysqli_error($conn);
}
} else {
echo "";
echo "Error: " . mysqli_error($conn);
}
} else {
// Error inserting into Players table
echo "";
echo "Error: " . mysqli_error($conn);
}
}
}
?>