In Progress

Manage Db Data with Ajax/Php/Mysql

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.

i. Further clarifications to be discussed.

Skills: AJAX, PHP

See more: ajax edit mysql, mysql ajax table editor, ajax mysql table, mysql row order, ajax save mysql, ajax checkbox mysql, edit data ajax php, ajax mysql checkbox, php mysql order, tables in data structure, table data structure, set in data structure, set data structure, set data, php create table, data structure with c, data structure that, data structure set, c using data structure, create table php, php ajax manage table, table ajax php mysql, show data mysql edit ajax, rows ajax php, php ajax edit save row table

About the Employer:
( 1 review ) Constanta, Romania

Project ID: #220171