How to store temporary data before inserting it to database MySql (PHP)

Question

1.00/5 (1 vote)

See more:

I am making a questionaire for my school project.
I have a "fill-out-form" which is a place for people to fill their data such as name, age, etc.
Then, I have "questionaire form" named "music.html" and "math.html".
If music.html has been answered, then it will go to math.html .
If both of the questionaire forms have been answered, it will show the result like:

Name : John
Age : 20
Music score : 5
Math score : 2

At last, it will store the data (name, age, music score and math score) to database MySql.
How can I do this? Thanks in advance.

Fillform.html

HTML

<html>
<head
</head>
<form name="myform" method="post" action="music.html">
    Username	: <input name="username" type="text"> <br>
    Age	        : <input name="age" type="text"> <br>
<input name="Button" type="button" value="SUBMIT">
</body>
</html>

Here's music.html looks like:

HTML

<html>
<head>
<script type="text/javascript" src="../js/script.js"></script>

<form name="myform" method="post"
 önSubmit="return validateRadio()" action="math.html">

<table class="tftable" border="1">
<tr><th><div align="center" class="tftable th">Questions</div></th><th colspan="2"><div align="center">Answer</div></th>
</tr>
<tr>
  <td>I like to dance</td>
  <td>

  <label>
  <input name="bm1" type="radio" value="1" />
  Yes</label>
  </td>
  <td>

  <label>
  <input name="bm1" type="radio" value="2" />
  No
  </label>
  </td>
  </tr>
  <tr>
  <td>I like to play sports such as baseball, soccer, hockey, or football </td>
  <td>
  <label>
  <input name="bm2" type="radio" value="1" />
  Yes</label>
  </td>
  <td>
  <label>
  <input name="bm2" type="radio" value="2" />
  No </label>
  </td>
  </tr></table>

My math.html looks same like this just different on the questions.
I have put javascript to count how many "yes" answer are there. If there're 4 yes then
music score : 4
I have put javascript to count the "yes" answer

script.js

JavaScript

function validateRadio()
{
// get all the inputs type
var inputs = myform.elements;
var radios = [];

// find the radio type
for (var i = 0; i < inputs.length; ++i) {
if (inputs[i].type == 'radio') {
radios.push(inputs[i]);
}
}
var countChecked = 0;
for (var j = 0; j < radios.length; j++) {
if (radios[j].checked) {
countChecked++;
}
}
//count number of radio button with value=1
var answeramount = 0;
for (var k = 0; k < radios.length; k++){
if(radios[k].checked && radios[k].value==1){
answeramount++;
}
}
if (countChecked != radios.length / 2){
alert("All questions must be answered.");
return false; // abort submit
} else {
alert(answeramount);
return true; // proceed to submit
} 
}

Posted 19-Mar-14 6:30am

monsterchub

Updated 19-Mar-14 6:31am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Accepted Answer · 2014-03-19T07:09:00

Solution 1

This is not going to work, only html and javascript, it goes no where.
You have to include php code in order to pass values from page to page, other things like the setting up of an Apache server, and mysql server too.
To accomplish this project, you have to start learning PHP+MySQL[^]
When you encounter problems subsequently in your php or mysql coding, always ask Google first, then visit CP to post questions related to specific issues.

Posted 19-Mar-14 7:09am

Peter Leow

Updated 19-Mar-14 7:14am

v3

Comments

monsterchub 19-Mar-14 14:53pm

In PHP, what should i use to pass value?
session or is there something else?
or maybe i can store the value in hidden form and pass the value to PHP?

Peter Leow 19-Mar-14 23:03pm

Yes, you are almost there: Specifically, pass form data using either get or post method and place them in some hidden fields in the receiving page. See http://www.w3schools.com/php/php_forms.asp on get and post methods.

monsterchub 20-Mar-14 12:20pm

Great thx Peter Leow