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;
}
?>