API using Php | How to design API using php (Mysql Addon)

index.php

<?php

$url = "your url";

$web = curl_init();

curl_setopt($web,CURLOPT_URL,$url);

curl_setopt($web,CURLOPT_RETURNTRANSFER,true);

$final = curl_exec($web);

curl_close($web);

$final = json_decode($final,true);

?>

<table border="1">

<tr>

<td>Id</td>

<td>Username</td>

<td>Password</td>

<td>Status</td>

<td>Role</td>

</tr>

<?php

foreach($final['data'] as $val){

echo "<tr>";

echo "<td>".$val['id']."</td>";

echo "<td>".$val['username']."</td>";

echo "<td>".$val['password']."</td>";

echo "<td>".$val['status']."</td>";

echo "<td>".$val['role']."</td>";

echo "</tr>";

}

?>

</table>

getdata.php

<?php

$connect= mysqli_connect("localhost","USERNAME","PASSWORD","DATABASE NAME");

header('Content-Type:application/json');

$sql = mysqli_query($connect,"select * from TABLE NAME");

while($result = mysqli_fetch_assoc($sql)){

   

    $mydata[] = $result;

}

echo json_encode(['data'=>$mydata]);

?>