Create single page application for a bookshop to sell its books. The user enters a search term on the web page. The application will then search the database system for all matching book titles or matching author names and display the information about these matching books on the screen. The matching books are displayed one book per line. At the end of each line, the user can select the number of copies of the book to order, and the application will immediately recalculate and display the total price of all books the user ordered on the web page. The total price is calculated on the server-side. It includes a discount of 8% if the total order value is over $250. The delivery fee is $10 per copy, but if the total order is over $500, the delivery is free of charge.

The computer running the HTTP server also runs a MySQL server and you have an account on the server. Your username and password for the MySQL account are "user" and "passwd" respectively. The only database in your account is named "bookstore" which contains the table "Books". This table is populated with information about all books the bookshop sells, which include BookId (book id, the primary key and is auto increment), Title, Author and Price (the price of the book).