1. Create one Ajax/Php/Mysql based page for the management of one Mysql Table values.
a. The Ajax/Php/Mysql page relies on the mysql tables attached to this document.(please understand first the structure of the tables and how they’re related and take a look at the scheme on page #2).
b. The user can browse the records which will be divided in pages(each of 50 inserts)
c. The script will only show the columns that have the parameter comp_view set to 1
d. Each row will have the Edit button on the right. When the user clicks on Edit, all the fields change from html text to textboxes(or textareas if the text has newlines in it).
i. When the edit function is activated two buttons appear instead of the Edit button: Save / Discard. When Save is pressed, using the Ajax technology, the row is updated in the DB. Discard will return the row to it’s previous state.
e. Each row will have the Delete button on the right. When the user clicks on Delete, a confirmation box will appear. Ok deletes the row from the table and from the db, Cancel doesn’t do anything.
f. Each row will have a checkbox on the left. The first row(where the titles of the columns are) will have a checkbox for check all / uncheck all
g. The columns in the title have up/down arrows for ordering. Default ordering is by date added desc.
h. If the filter is enabled(there is some text in the filter box), the order up, order down actions will have effect only on the filtered inserts.