I have a web database using MySQL that requires a front end added to it. You must be familiar with using forms in HTML. This should be a very simple project to a seasoned PHP/MySQL developer.
A ERD will be provided with the project.
It will need to do the following functions:
There are 3 tables that will be editable, and for other tables that are connected for reference only (examples being title. plan types etc) You must be familiar with using Joins in SQL
1 - Support a login for people that can view/edit the data
2 - Provide an export for the user table with specific fields.
3 - Add user, and data for supporting tables
Export:
1 - Export a CSV of the user data
Editing:
1 - When a user is edited the old data is saved in a history table.
2 - When the detail table is edited the old data will be saved in a history table
Create (Add) User:
1 - Needs to be able to add a user to the system, as well as supporting data.
2 - New records must be added using GUID as the primary key
Viewing Detail:
1 - The viewing detail will open a form that shows all off the connecting data on forms and allow the user to add new data to the user, or delete data.
Search Abilities:
1 - Perform a search on the users, and list all names similar to the search
2 - Allow a drill down if a user is clicked on to show an editable detail form.
It is a pretty simple front that should only take a couple of days. If you have questions please feel free to contact me.