Jump to content

Best method for saving online form -> MySQL for output 2 PDF


meOmy

Recommended Posts

Hi guys,

Never done anything like this, so wondering how you would go about doing it.

Imagine a document that has three check boxes (Yes, No, Maybe) and one of them must be marked with an 'X' when printed and handed to some fictional office.

Now online, I would prefer to code a single drop-down menu with the three options that saves the answer to my db. 

However, I'm not sure how I would get the saved data to be placed, in the proper checkbox, on the outputted form when I create a PDF.

Would you save the data to one db field or would you create three separate db fields; one for each possible answer? This way, you could put the output code in each position on the form and then only one of them would appear?

Sorry for this being such an ambiguous write-up. Bottom line, would you save all three possible answers to one db field or would you create three db fields; one for YES, one for NO, and one for MAYBE?

I'll figure out how to do it later, I just want to know the best way to store the data to make it easier to get on a printed document/pdf later.

Thank you!

 

Link to comment
Share on other sites

You only need to save the selected response (Yes, No, or Maybe). Once you know which option was selected, you know the others are not.

 

As for the selection method, I would use radio buttons instead of a drop-down menu. Radio buttons require less interaction from the user. And I wouldn't be surprised to find users who are less than familiar with drop-down menus. However, if space is an issue, a drop down may be better.

  • Like 1
Link to comment
Share on other sites

  • 4 weeks later...

You only need to save the selected response (Yes, No, or Maybe). Once you know which option was selected, you know the others are not.

 

As for the selection method, I would use radio buttons instead of a drop-down menu. Radio buttons require less interaction from the user. And I wouldn't be surprised to find users who are less than familiar with drop-down menus. However, if space is an issue, a drop down may be better.

 

^^ I read somewhere that only if the options are more than 6, then you use a drop-down instead of radio buttons. 

Since you have 3 options, use radios. 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.