I am utilizing bootstrap datatables to present data retrieved from an API in a tabular format. Below is the sample data:
{
"response_status": {
"status_code": 0,
"status_message": [
{
"reg_number": "123",
"company": "Company A",
"office": "Orlando",
"phone_number": "28122312345",
"postal_address": "000",
"postal_code": "000"
},
{
"reg_number": "552",
"company": "Company B",
"office": "Miami",
"phone_number": "28122312345",
"postal_address": "000",
"postal_code": "000"
},
{
"reg_number": "154",
"company": "Company C",
"office": "San Francisco",
"phone_number": "28122312345",
"postal_address": "000",
"postal_code": "000"
}
]
}
}
While trying to display the data using bootstrap datatables, I aim for the resulting HTML output to resemble this structure:
<table> <thead> <tr> <th>Reg No</th> <th>Company</th> <th>Office</th> <th>Phone Number</th> <th>Postal Address</th> <th>Postal Code</th> </tr> </thead> <tbody> <tr> <td>123</td> <td>Company A</td> <td>San Francisco</td> <td>28122312345</td> <td>000</td> <td>000</td> </tr> <tr> <td>552</td> <td>Company B</td> <td>Miami</td> <td>28122312345</td> <td>000</td> <td>000</td> </tr> <tr> <td>154</td> <td>Company C</td> <td>San Francisco</td> <td>28122312345</td> <td>000</td> <td>000</td> </tr> </tbody> <table>Currently, I have been experimenting with incorporating PHP code into this setup:
<table>
<thead>
<tr>
<th>Reg No</th>
<th>Company</th>
<th>Office</th>
<th>Phone Number</th>
<th>Postal Address</th>
<th>Postal Code</th>
</tr>
</thead>
<tbody>
<?php foreach($data->response_status->status_message as $message) : ?>
<tr>
<td><?php echo $message->reg_number; ?></td>
<td><?php echo $message->company; ?></td>
<td><?php echo $message->office; ?></td>
<td><?php echo $message->phone_number; ?></td>
<td><?php echo $message->postal_address; ?></td>
<td><?php echo $message->postal_code; ?></td>
</tr>
<?php endforeach; ?>
</tbody>
<table>
However, this approach has not yielded the desired outcome. Is there an alternative method that could be employed to achieve the desired result?