Dynamically add questions data to html page, creating a survey application that dynamically forms the HTML page Options

[uahmed90]

Hi,

I'm working on a college project. I need to create a Survey application, and the part that I am stuck on is how to bring data into my html form from a database, dynamically?
Basically, there are questions, and the answers, which the user will choose and both the questions and answers will be submitted into a database. That much I can do, but I cannot figure out how to bring the question itself from the database, and make it appear in the HTML page. For example:

Question: <input type="text" id="ques">, this will give me the form field to input the answer to the question and program the submit button to send both question and answer to the database, but how do I RETRIEVE the QUESTION itself, from the database? the Question: <input type="text" id="ques">, this is what I want to bring in from the database.

Also, I am using a firebase database, so if possible, please answer in reference to that, if not thats no problem. I can figure that part out if I can understand how to do that in html.

THanks

[CharlesEF]

Basically, there are questions, and the answers, which the user will choose and both the questions and answers will be submitted into a database. That much I can do, but I cannot figure out how to bring the question itself from the database, and make it appear in the HTML page. For example:

This statement makes me think you are using a server side language. What language is it, PHP ASP or ??? If you're putting data into a database then you must already know how to connect to the database, etc.

Your question is too broad unless you show us your code. How is your database setup? I think it would involve 2 tables, 1 table for questions and 1 table for answers. Each question needs to be tied to the possible answers (I assume you also have incorrect answers for each question). You don't want to store the correct answer in the web page because then you just need to 'View Source' to see the correct answer. This means that each question will have to make an AJAX call to retrieve the correct answer. I could go on but you get the idea.

Put some code together and post it here (or attach it to a post) with a specific question.

[Christian J]

I think it would involve 2 tables, 1 table for questions and 1 table for answers.

Wouldn't one table suffice for that? Each question's row might contain one column each for the question and the answer alternatives. But maybe the chosen answer should be stored in a separate table, with one row for each participating user.

Each question needs to be tied to the possible answers (I assume you also have incorrect answers for each question). You don't want to store the correct answer in the web page because then you just need to 'View Source' to see the correct answer.

Note that it's a survey, not a user test, so I guess the answers must be shown for the user to see.

This means that each question will have to make an AJAX call to retrieve the correct answer.

That sounds like overkill to me, unless it's important to process each separate question one at the time (like in branching questions trees?). Otherwise the whole form could be submitted as a whole without Ajax.