I would like to make an interface that lets the user add, change and delete records in a database.
My idea is to show a data grid of the current records, and next to each record have a "Change" and "Delete" button. At the bottom of the datagrid would be a form containing empty text boxes that can be used to add a new record.
I figure that if I make everything work via AJAX then it would make the interface very much like a typical Windows application, with no page refreshing needed. The user would see their changes immediately in the datagrid, i.e. deleted records are removed from the datagrid, new records added to the datagrid, and changed records updated in the datagrid.
The backend will be written in PHP and will handle the updating of the database where all the records are stored.
I've looked all over the place but haven't really found any jQuery examples of this sort of interface. I've found plenty of examples of datagrids, and some even allow editing of the data, but none of the examples I've looked at covered adding new records.
Can anyone point me to some examples that do what I'm looking for?