I'm building a site for vets to order tests from a lab, so the lab and vet can communicate the results.
1.) vet to register a login/pass, clinic, and name on Lab website and data will be stored in websites Vet table.
2.) the vet would login to access the order form which pre-fills name and clinic information. Vet would fill in requests on the form.
These requests may be one test or multiple. Because of that, the test will have a separate table with a column per test. It will be joined with the others tables for a result page.
The requests are stored in a request table with a form_id that exists in the tables to use for the join. The form_id is used to tie up all the tables for the result page.
3.) Lab to get all data regarding request and who it is from by pulling the information from all relevent tables by joing tables. This will be
emailed to them or they can call the filled out form online.
I am doing the coding on PHP without a framework, except PEAR for the registration form.
Is there a better approach to do this project? Some other PHP framework?