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>";
}
}
