Putting arrays in a table using PHP

Question

I'm a beginner in PHP and working on an API project which has to get results from a server I connected via API.

I am getting the results, but I would like to have them well arranged in a simple table.

This is what I am getting:

I used the following code:

$api = new SplynxAPI($api_url, $key, $secret);

$locationsApiUrl = "admin/administration/locations";

echo "<pre>";

echo "List locations\n";
$result = $api->api_call_get($locationsApiUrl);

echo "Result: ";

if ($result) {
  echo "Ok!\n";
  print_r($api->response);
} else {
  echo "Fail! Error code: $api->response_code\n";
  print_r($api->response);
}

echo "\n-------------------------------------------------\n";

Kindly assist me on this one.

the result array seems okay, maybe what you mean you wanted them to display as json format, since this is api — Beginner, Mar 29 '17 at 09:41
Save $api->response in an array variable and then you can show it in form of table. Better approach is provided here : http://stackoverflow.com/questions/4746079/how-to-create-a-html-table-from-a-php-array — Saili Jaguste, Mar 29 '17 at 09:49
Better to convert it to JSON format. Then render it to your Table. — Deepak swain, Mar 29 '17 at 11:14

score 1 · Accepted Answer · answered Mar 29 '17 at 11:21

The following code will render your response in a HTML <table>.

$api = new SplynxAPI($api_url, $key, $secret);

$locationsApiUrl = "admin/administration/locations";


$result = $api->api_call_get($locationsApiUrl);

if ($result) {
  echo "<table>";
  foreach($api->response as $row){
    echo sprintf('<tr><td>%s</td><td>%s</td></tr>', $row['id'], $row['name']);
  }
  echo '</table>';
} else {
  echo "Fail! Error code: $api->response_code\n";
  print_r($api->response);
}

echo "\n-------------------------------------------------\n";

score 0 · Answer 2 · answered Mar 29 '17 at 11:17

0

You are directly getting the response "$api->response" as an array. So simply use a loop and populate it in table as you like.

Ex:

foreach($api->response as $apiData) {
 // Your code 
}

answered Mar 29 '17 at 11:17

Harish Kanakarajan

684
4
15

Putting arrays in a table using PHP

2 Answers2