Manage Db Data with Php/Ajax/Mysql
This project is now closed with a project budget of $250 - $750 USD.Get free quotes for a project like this
Project Budget$250 - $750 USD
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online