Homework 5 (Dynamic HTML with javascript with two forms and a server program with PHP , SQLite) DVD Shopping Website

A server program creates a website for selling DVDs, including two forms (for example showform, realform). Within "showform", AT LEAST a selection for DVDs, one selection or more, for genres, directors, a genre of a selected director etc., a text input for user_id, and a button for listing DVDs for selected genre etc, a button for buying a selected DVD. When the buy button is clicked the information of the selected DVD is sent to the server program with "realform" (i.e. one DVD at a time).

The server program lists data from a DVD database (SQLite) and creates DVD records and inserts them into javascript code. Here is a data format for DVD recordings as:"#name#id#price#genre#director#"

a sample for this data format:"#Life is Beautiful#dvd1#10.5#history#Roberto Benigni#"

There is a "realform" for sending buying information to the server-side. Buying information is listed as: ?DVD_id=123&user_id=456

After receiving the buying information on the server-side, the server program checks whether the user_id is recorded then decreases the stock number of that DVD and refreshes all webpage content with updated stocks. If the previous sold DVD is the last one, it will not list in the refreshed page.

You must send all files to me as: webpage, server program, and database file (SQLite). There are two tables ( DVD table and USERS table)

can you say which editor do you use when you writing ?