IS265 – Scripting Technologies IS265 – Scripting Technologies HenryBooks Carry List (PHP #1: 50 points) 2021 For this assignment you will use PHP to develop a web page that reads the Henry Books...

Please help me with this javascript using PHP


IS265 – Scripting Technologies IS265 – Scripting Technologies HenryBooks Carry List (PHP #1: 50 points) 2021 For this assignment you will use PHP to develop a web page that reads the Henry Books database and displays a list of the books carried by all the bookstores – sorted in book title order. The page does not need to do anything other than produce a formatted list, as shown in the following sample: The assignment should implement PHP using the following techniques: 1) a separate DB connection script loaded from the main form using a require_once() call 2) an embedded SQL command to create and return the data result set 3) mysqli_query and mysqli_fetch_array calls to obtain and process the database data 4) an error message output if the number of rows returned by the query is zero (or if the database connection called in item 1 above failed). Note that the fields needed in the output are those shown in the sample above. The HenryBooks database has a somewhat unusual structure, making a query that returns both a book title and its author name somewhat complex. The tables needed for the above list are book, wrote, author, and publisher; a query to obtain the required data would be: SELECT book.book_code, book_title, author_name, author_first, publisher_name, book_type, book_price, paperback FROM book, publisher, wrote, author WHERE book.book_code = wrote.book_code AND wrote.author_number = author.author_number AND book.publisher_code = publisher.publisher_code ORDER BY book_title;