i am working on a footbal game online but this code is not playing properly
<?php //connect to the database $db_hostname = 'localhost'; $db_username = 'root'; $db_password = ''; $db_database = 'football_db'; $mysqli = new mysqli($db_hostname, $db_username, $db_password, $db_database); if ($mysqli->connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } //get the player's ID $player_id = $_GET['player_id']; //get the player's statistics $query = "SELECT * FROM player_stats WHERE player_id = $player_id"; $result = $mysqli->query($query); //calculate the player's total goals, assists, and minutes played $total_goals = 0; $total_assists = 0; $total_minutes = 0; while ($row = $result->fetch_assoc()) { $total_goals += $row['goals']; $total_assists += $row['assists']; $total_minutes += $row['minutes_played']; } //display the player's statistics echo "Player ID: $player_id"; echo "Total goals: $total_goals
"; echo "Total assists: $total_assists
"; echo "Total minutes played: $total_minutes
"; //close the database connection apartments for rent in beirut); ?>