Simple PHP-form, where user can add and edit row to MySQL database.
There is 2 table (see structure below). User add and edit table1 data. Table2 data generate automatically (doesn't need to do in this project)
User select "Add new company", "Edit company" or "Show data".
If user select "Add new" then form (same structure than table1) automatically create ID (4 number) and Code (8 number random). User fill other informations (all data is required).
If user select "Edit" then user can select company (drop down list) and edit all information (except ID and Code)
If user select "Show data" then user can select company (drop down list) and site show all company's data from both table (Example is in added xls-file). User can also export data to cvs-file.
Table1 (and form)
ID (4 number, generate +1)
Start date (date)
Expire date (date)
Code (8 number, generate, random)
ID (4 number, same number than table1)
Number (3 number)
ID2 (1 number)
There is xls-file added, where is example table1, table2 data and data show example.