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)
{
$result->data_seek($j);
echo 'Author: ' . htmlspecialchars($result->fetch_assoc()['author']) . '
';
$result->data_seek($j);
echo 'Title: ' . htmlspecialchars($result->fetch_assoc()['title']) . '
';
$result->data_seek($j);
echo 'Category: ' . htmlspecialchars($result->fetch_assoc()['category']) . '
';
$result->data_seek($j);
echo 'Year: ' . htmlspecialchars($result->fetch_assoc()['year']) . '
';
$result->data_seek($j);
echo 'ISBN: ' . htmlspecialchars($result->fetch_assoc()['isbn']) . '
';
}
$result->close();
$conn->close();
?>