<?php global $Bootstrap; $this->start('clients_list'); $Clients = new Clients(); // check if the query is ok if ($Clients->listClients() === true) { $client_no = 1; // check if query returned results if (empty($Clients->_Data)) { // if query did not return results inform the user echo ' <tr> <td colspan="9" align="center"> <div class="alert alert-info">No clients in the database</div> </td> </tr>'; } else { // if query return results show them in the table foreach ($Clients->_Data as $client) { echo ' <tr> <td>' . $client_no++ . '</td> <td>' . $client['client_name'] . '</td> <td>' . $client['client_email'] . '</td> <td>' . $client['client_phone'] . '</td> <td>' . $client['client_cars'] . '</td> <td>' . date('dS \\o\\f M Y', strtotime($client['client_date_registered'])) . '</td> <td width="1"><a href="#" class="btn btn-warning btn-xs"><i class="fa fa-pencil-square"></i></a></td> <td width="1"><a href="#" class="btn btn-danger btn-xs"><i class="fa fa-trash"></i></a></td> <td width="1"><a href="#" class="btn btn-info btn-xs"><i class="fa fa-car"></i></a></td>