How to get all records from the database via an endpoint in PHP

Here is the endpoint

http://localhost/mudb/unitedapi/

I need to get all the records in a json format from my table when i load the url in my browser. I can now only get a single record using the id from http://localhost/mudb/unitedapi/1. How can I get them all?

My .htaccess

RewriteEngine On    # Turn on the rewriting engine

RewriteRule ^unitedapi/([0-9a-zA-Z_-]*)$ api.php?player_id=$1 [NC,L]

My code

<?php

 header("Content-Type:application/json");
 if (isset($_GET['player_id']) && $_GET['player_id']!="") {
   include('db.php');
   $player_id = $_GET['player_id'];

   $result = mysqli_query($con, "SELECT * FROM `players` ");

   if(mysqli_num_rows($result)>0)
   {
     $row = mysqli_fetch_array($result);
     $fname = $row['fname'];
     $lname = $row['lname'];
     $shirtno = $row['shirtno'];
     $position = $row['position'];
     $response_code = $row['response_code'];
     $response_desc = $row['response_desc'];

     response($player_id, $fname,$lname,$shirtno,$position, 
 $response_code,$response_desc);
     mysqli_close($con);
    }
    else {
      response(NULL, NULL,NULL, NULL, NULL, 200,"No Record Found");
    }
 } 
 else {
   response(NULL, NULL,NULL, NULL, NULL,400, "Invalid Request");
 }

 function response($player_id, $fname,$lname,$shirtno,$position, 
 $response_code,$response_desc)
 {
   $response['player_id'] = $player_id;
   $response['fname'] = $fname;
   $response['lname'] = $lname;
   $response['shirtno'] = $shirtno;
   $response['position'] = $position;
   $response['response_code'] = $response_code;
   $response['response_desc'] = $response_desc;

   $json_response = json_encode($response);
   echo $json_response;
 }
 ?>