I am creating a website that allows a customer to enter, query and edit a MySQL database for records that are specific to them. I need a CRUD datagrid that allows inline editing/entry (tab from field to field, then add new row/record when row is complete), that will update the MySQL database when the row is complete. Data will be pre-populated per specific queries related to a customerid and specific data constraints (date, type, etc.). Data is required in all fields so an incomplete row will not be entered when new records are being entered. Some fields are drop down option boxes that are queried from separate tables. Some fields are date fields and will need date formatting and a calendar date picker; a date field will also be pre-populated with today's date. The row will also have a button that will
The project is derived from a MS Access database project that I want to put online and usable to both myself and other businesses. This project is a small piece of the overall website and there may be further work to help complete the website depending on the quality of work from the freelancer.
Attached is a mockup of the datagrid.