connect_error) die("Fatal Error");
$query = "SELECT * FROM classics";
$result = $conn->query($query);
if (!$result) die("Fatal Error");
$rows = $result->num_rows;
for ($j = 0 ; $j < $rows ; ++$j)
{
$row = $result->fetch_array(MYSQLI_ASSOC);
echo 'Author: ' . htmlspecialchars($row['author']) . '
';
echo 'Title: ' . htmlspecialchars($row['title']) . '
';
echo 'Category: ' . htmlspecialchars($row['category']) . '
';
echo 'Year: ' . htmlspecialchars($row['year']) . '
';
echo 'ISBN: ' . htmlspecialchars($row['isbn']) . '
';
}
$result->close();
$conn->close();
?>