2. PHPRunner General questions
  3. [SOLVED]  Need help with basic design
This topic is locked
[SOLVED]

 Need help with basic design

 		6/11/2012 5:38:13 PM
PHPRunner General questions
D
 dodgebros author

I am trying to create an app that is based on a set of eleven paper forms. The first form has to be completed each time an incident occurs. Each of the other ten forms may or may not have to be completed based on what type of incident has occurred.
How do I setup database / phprunner to be able to handle this?
Thanks in advance!!!

TD
P
 		procheck 6/12/2012

You will need to learn about database design.
Here is a link which will help you get started. There is a lot of information on the internet

if you don't like this guide.
Database Design
C
 		cgphp 6/12/2012

If the incident doesn't require extra forms save the first form directly to the database.

If the incident requires extra forms, keep data in session variables and save them when all forms are completed.
Sergey Kornilov admin 6/12/2012

I guess you are going to have eleven or twelve tables. One table per form (if all forms vary greatly) and one main table (Incident). Incident table can be your main table in fact, depends on how you want to handle this. Form tables can be linked to the master Incident table as Master-Details. Based on data supplied in the first form you can rediect user to one or more form Add pages.
It would definitely help to learn the very basics of database design. You will have a much better understanding of what is going to work for you.
D
 		dodgebros author 6/12/2012



If the incident doesn't require extra forms save the first form directly to the database.

If the incident requires extra forms, keep data in session variables and save them when all forms are completed.


This is what I was looking for. Can you create the extra forms/pages with phprunner? If so, how?
Thanks,

TD
Sergey Kornilov admin 6/13/2012

You just need to create one form for each table. One form - one table - one Add page.