include 'database.php'; include 'getAssocList.php'; // connect to database $db = new mysqli('localhost', 'username', 'password', 'database_name'); // retrieve book data from database using getAssocList $books = getAssocList($db, 'SELECT * FROM books'); // display book data in a table echo ''; echo ''; foreach ($books as $book) { echo ''; } echo '
Title | Author | Publisher | Publication Date | ISBN |
---|---|---|---|---|
' . $book['title'] . ' | ' . $book['author'] . ' | ' . $book['publisher'] . ' | ' . $book['publication_date'] . ' | ' . $book['isbn'] . ' |