You are to apply all the Web technologies (DOM, XML, Flash, Ajax, PHP, Oracle, etc.) learnt from lectures and practicals to make the site that you created in Assignment One fully functional. That is, To create a flash introducing your products/services(e.g books and gift certificates) on your website. To validate the order form using Ajax and PHP on server side. User's input is validated on the fly. If error is found, appropriate information is displayed. All required fields should be checked for completion, and all data that are entered should be checked for 'correctness'. For example, products/services selected, buyer contact details (name, phone number, email address, etc.), delivery address (unit number/street name, city, postal code, etc.) and payment methods (credit card number, expiry date, card holder name, etc.) are fields expected in the order form to be validated. Regular expression is recommended for pattern matching in PHP. To develop the system to respond to the forms by accessing your products/services XML files, querying your Oracle database, generating contents, and adding information to the database. Your PHP code needs to be used to enable search sugguestions: a suggest/autocomplete box similar to Google Suggest, where a user gets suggested products/sevices while typing in the search form. Example: User is typing a book title: harry potter Suggestions which would be displayed: Harry Potter and philosophy Harry Potter and the chamber of secrets the ivory tower and Harry Potter j k rowling's harry potter search function: the search form responds to user's input with retrieved information from server side. shopping cart: it allows a user to place items in the cart and calculates a total for the order, including shipping and handling (i.e. postage and packing) charges and the associated taxes (e.g. GST), as applicable upon checkout. Gift certificate code is 8 characters long and generated automatically by the website (up to you to define the coding rule). Code validity and balance check should be done if used while checkout. After checkout, all the data from the completed form will be inserted into the relevant table. A receipt page confirming the order that has been made should be displayed or in the event of an error, an appropriate error message should be shown to the user. The stock level is updated accordingly in Oracle database. To implement the "my account" and "register" function on your website. On "my account" page, a user can view his last three months' order(s) if any. On "my account" page, a user can view a copy of the electronic gift certificate code he bought. A gift certificate is redeemable via the BookStore website and is valid for 12 months from the date of purchase. Certificate does not have to be used in one transaction. Once logged on, user's registered name should be displayed at a proper location on the pages accordingly. When a logged on user makes an order, the shipping details in the order form can be auto-filled directly with the information collected on register page. The details should be editable. (note: you might need to change the register form to accommodate more information fields used in order form.) You are permitted to change the forms that you created for Assignment One if you believe that they can be improved for the purposes of this assignment.However before receiving your assignment 1 mark, please do not modify the orignial html pages. Copy them to another folder and then copy them back later after the assignment 1 mark has been finalized. Requirements General requirements include: Properly sized flash. The images (and sound if any) used in flash should be appropriate and related to your website products/services (e.g. books). Appropriate server side Ajax and PHP validation of all data. You must provide necessary validation of all form fields where appropriate. You must decide what validation is required and how the validation is performed. For instance, Are all the required fields checked for completion? Are the fields which require a specific length, numeric data or a predetermined format (for example, contact phone numbers, postal codes, credit cards, street numbers) properly checked? Do the messages provided while validation help the user fix the 'problem'? Well developed and structured PHP code. Write functions to re-use code for common tasks. The code should be clear and properly indented; use meaningful variable names; and be free of errors. Your PHP code should maintain users shopping cart, connect to the relevant Oracle database tables, and disconnect 'safely'; it should also generate readable and reasonable output for the user. For instance, if an order has been accepted successfully, a receipt/confirmation page should be sent back. Well documented code. Appropriate and consistent comments should be placed throughout the code. The comments should be sufficiently detailed to allow an assessor to understand what it is doing without having to spend too much time on your code. S