alert('Please fill all required fields');";
} else {
// Construct SQL query
$query = "INSERT INTO Scorer (player_id, match_id, runs, wickets, catches)
VALUES('$player_id', '$match_id', '$runs', '$wickets', '$catches')";
// Execute SQL query
$result = mysqli_query($conn, $query);
// Check for query execution success
if ($result) {
echo "";
header('location:match_scorer.php');
} else {
echo "";
echo "Error: " . mysqli_error($conn);
}
}
}
// Retrieve players and matches for dropdowns
$query_players = "SELECT player_id, CONCAT(first_name, ' ', last_name) AS player_name FROM Player";
$result_players = mysqli_query($conn, $query_players);
$query_matches = "SELECT match_id, match_date FROM Matches";
$result_matches = mysqli_query($conn, $query_matches);
?>
Insert Match Scorer