Welcome " . $_SESSION['username'] . "";
$player_id = $_GET['player_id'];
// Fetch player contract & installment details
$query_player = "SELECT * FROM Contracts NATURAL JOIN Installment NATURAL JOIN Player NATURAL JOIN Club NATURAL JOIN Team WHERE player_id = '$player_id'";
$result = mysqli_query($conn, $query_player);
$row = mysqli_fetch_assoc($result);
// Fetch all clubs
$query_clubs = "SELECT club_id, club_name FROM Club";
$result_clubs = mysqli_query($conn, $query_clubs);
$clubs = mysqli_fetch_all($result_clubs, MYSQLI_ASSOC);
// Fetch all teams
$query_teams = "SELECT team_id, team_name FROM Team";
$result_teams = mysqli_query($conn, $query_teams);
$teams = mysqli_fetch_all($result_teams, MYSQLI_ASSOC);
?>
Player Info
alert('Please fill all required fields')";
} else {
// Construct SQL query
$query_contract = "UPDATE Contracts
SET total_amount = '$total_amount', terms = '$terms', start_date = '$start_date', end_date = '$end_date', club_id = '$club_id', team_id = '$team_id'
WHERE player_id = '$player_id'";
// Execute SQL query
$result1 = mysqli_query($conn, $query_contract);
// Check for query execution success
if ($result1) {
echo "";
header('location:player_contracts.php');
} else {
echo "";
echo "Error: " . mysqli_error($conn);
}
}
}
?>