Welcome ".$_SESSION['username']."";
// Check if the user is logged in, if not redirect to login page
if (!isset($_SESSION['username']) || $_SESSION['usertype'] != 'admin') {
header('location:login.php');
exit;
}
$contract_id = $_GET['contract_id'];
$query_player = "SELECT * FROM Contracts NATURAL JOIN Installment WHERE contract_id = '$contract_id'";
$result = mysqli_query($conn, $query_player);
$row = mysqli_fetch_assoc($result);
?>
Player Info
HONORARIUM PAYMENT
alert('Please fill all required fields')";
} else {
//query to get the payment status
$query_payment_status = "SELECT payment_status FROM Installment WHERE contract_id = '$contract_id'";
$result_payment_status = mysqli_query($conn, $query_payment_status);
$row_payment_status = mysqli_fetch_assoc($result_payment_status);
$payment_status = $row_payment_status['payment_status'];
if($payment_status == 'Paid') {
echo "";
}else{
// Query to get the total contract amount
$query_total_amount = "SELECT total_amount FROM Contracts WHERE contract_id = '$contract_id'";
$result_total_amount = mysqli_query($conn, $query_total_amount);
$row_total_amount = mysqli_fetch_assoc($result_total_amount);
$total_amount = $row_total_amount['total_amount'];
if($existing_user_amount <= $installment_amount) {
// Construct SQL queries
$query = "UPDATE Installment
SET installment_amount = '$installment_amount', installment_date = '$installment_date', payment_status = 'Paid'
WHERE contract_id = '$contract_id'";
// Execute SQL queries
$result1 = mysqli_query($conn, $query);
// Check for query execution success
if($result1) {
echo "";
header('location:player_contracts.php');
} else {
echo "";
echo "Error: " . mysqli_error($conn);
}
} else {
echo "";
}
}
}
}
?>