static function show_results($connection, $sql) { if ($received_data = @$connection->query($sql)) { if ($received_data->num_rows > 0) { echo "<table><tr><th>ID</th><th>Name</th><th>FirstName</th><th>Surname</th><th>Shelf Name</th><th>Edit</th><th>Delete</th></tr>"; while ($record = $received_data->fetch_assoc()) { echo "<tr><td>" . $record['id'] . "</td><td>" . $record['name'] . "</td><td>" . $record['firstname'] . "</td><td>" . $record['surname'] . "</td><td>" . $record['shelf_name'] . "</td><td> " . LibraryManager::edit_button($record['id'], $record['name'], $record['firstname'], $record['surname'], $record['shelf_name']) . "</td><td> " . LibraryManager::delete_button($record['id']) . " </td></tr>"; } echo "</table><br></br>"; } else { echo "0 results<br></br>"; } $received_data->close(); } else { echo "WRONG QUERY! <br></br>"; } }