All,
First of all thanks. I've looked over adn found some good information on this issue, from this site but I just can't quite get it to work. I'm new to both php and mysql. I'm normally the os server guy who makes things work programing is not my usual area.
I'm taking a paper survey and used it as a template for an html form online. This form is to be used to place the data into the mysl database.
HTML CODE
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<!-- Created with the CoffeeCup HTML Editor 2008 -->
<!-- http://www.example.com/ -->
<!-- Brewed on 12/30/2008 6:31:01 PM -->
<head>
<title></title>
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
</head>
<body>
<form name="Health and Habit Study - Spring 08" action="survey.php" method="post">
1. My health at this time is best described as<br>
<input type="radio" name="q1" value="1"> Excellent <input type="radio" name="q1" value="2"> Good <input type="radio" name="q1" value="3"> Fair <input type="radio" name="q1" value="4"> Poor
<br><br>
My major health concern/problem is <input type="text" name="q1a" value="N/A">
<br>
2. I am<br> taking about ___ hours at SAC this semester.<br>
<input type="radio" name="q2" value="1">12-16Hrs. <input type="radio" name="q2" value="2">9-11Hrs. <input type="radio" name="q2" value="3">7-9 Hrs. <input type="radio" name="q2" value="4">4-6 Hrs <input type="radio" name="q2" value="5"> 1-3 Hrs. <br><br>
3. How many hours per week do you work for pay?<br>
<input type="radio" name="q3" value="1">40 or more <input type="radio" name="q3" value="2"> 30-39 <input type="radio" name="q3" value="3"> 20-29 <input type="radio" name="q3" value="4"> 10-19 <input type="radio" name="q3" value="5"> 1-9 <input type="radio" name="q3" value="6"> 0<br>
I am paid $<input type="text" name="q3a" value="N/A">/hour or average $<input type="text" name="q3b" value="N/A"> per week<br><br>
4. How much sleep do you average per week day? <br>
<input type="radio" name="q4" value="1"> 10+ <input type="radio" name="q4" value="2"> 8-9 <input type="radio" name="q4" value="3"> 6-7 <input type="radio" name="q4" value="4"> 4-5 <input type="radio" name="q4" value="5"> 2-3 <input type="radio" name="q4" value="6"> 0-1 <br><br>
5. I usually eat 2/3 healthy meals per day<br>
<input type="radio" name="q5" value="1"> Nearly daily <input type="radio" name="q5" value="2"> Often <input type="radio" name="q5" value="3"> Sometimes <input type="radio" name="q5" value="4"> Seldom <input type="radio" name="q5" value="5"> Rarely<br><br>
6. Do you use tobacco products on a regular basis?<br>
<input type="radio" name="q6" value="1"> Nearly daily <input type="radio" name="q6" value="2"> Often <input type="radio" name="q6" value="3"> Sometimes <input type="radio" name="q6" value="4"> Seldom <input type="radio" name="q6" value="5"> Never<br><br>
7. I drink alcoholic beverages on a regular basis<br>
<input type="radio" name="q7" value="1"> Nearly daily <input type="radio" name="q7" value="2"> Often <input type="radio" name="q7" value="3"> Sometimes <input type="radio" name="q7" value="4"> Seldom <input type="radio" name="q7" value="5"> Never<br><br>
What kind? <input type="text" name="q7a" value="N/A"> How much?<input type="text" name="q7b" value="N/A"><br><br>
8. I use illegal drugs/substances regularly.
<input type="radio" name="q8" value="1"> Nearly daily <input type="radio" name="q8" value="2"> Often <input type="radio" name="q8" value="3"> Sometimes <input type="radio" name="q8" value="4"> Seldom <input type="radio" name="q8" value="5"> Never<br><br>
Describe drug/substance use<input type="text" name="q8a" value="N/A"><br><br>
9. I live/make my home/with the following people:
<input type="radio" name="q9" value="1"> Parent(s) <input type="radio" name="q9" value="2"> Relatives <input type="radio" name="q9" value="3"> Friend(s) <input type="radio" name="q9" value="4"> Lover(s) <input type="radio" name="q9" value="5"> Alone<input type="radio" name="q9" value="6"> Boarding House <input type="radio" name="q9" value="7"> Other <br><br>
10. I spend about ____ hrs/weeks studying my courses.<br>
<input type="radio" name="q10" value="1"> 0-1 <input type="radio" name="q10" value="2"> 2-3 <input type="radio" name="q10" value="3"> 4-5 <input type="radio" name="q10" value="4"> 6-7 <input type="radio" name="q10" value="5"> 8-9 <input type="radio" name="q10" value="6"> 10-12 <input type="radio" name="q10" value="7"> 13-15 <input type="radio" name="q10" value="8"> 16-18 <input type="radio" name="q10" value="9">19+<br><br>
Gender
<input type="radio" name="q11" value="m"> Male <input type="radio" name="q11" value="f"> Female<br><br>
Age:<input type="text" name="q12" value="N/A"> Ht:<input type="text" name="q13" value="N/A"> Wt:<input type="text" name="q14" value="N/A"> Major:<input type="text" name="q15" value="N/A"> GPA=<input type="text" name="q16" value="N/A">
</form>
</body>
</html>
survey.php script
<?php
$con = mysql_connect("localhost","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("psyclub", $con);
$sql="INSERT INTO age (answer)
VALUES ('$_POST[q12]')";
$sql="INSERT INTO alcohol (answer)
VALUES ('$_POST[q7]')";
$sql="INSERT INTO alochol_amount (answer)
VALUES ('$_POST[q7b]')";
$sql="INSERT INTO alcohol_kind (answer)
VALUES ('$_POST[q7a]')";
$sql="INSERT INTO course_hours (answer)
VALUES ('$_POST[q2]')";
$sql="INSERT INTO gender (answer)
VALUES ('$_POST[q11]')";
$sql="INSERT INTO gpa (answer)
VALUES ('$_POST[q16]')";
$sql="INSERT INTO health (answer)
VALUES ('$_POST[q1]')";
$sql="INSERT INTO health_concerns (answer)
VALUES ('$_POST[q1a]')";
$sql="INSERT INTO healthy_meals (answer)
VALUES ('$_POST[q5]')";
$sql="INSERT INTO height (answer)
VALUES ('$_POST[q13]')";
$sql="INSERT INTO home (answer)
VALUES ('$_POST[q9]')";
$sql="INSERT INTO illegal_drugs (answer)
VALUES ('$_POST[q8]')";
$sql="INSERT INTO illegal_drugs_describe (answer)
VALUES ('$_POST[q8a]')";
$sql="INSERT INTO major (answer)
VALUES ('$_POST[q15]')";
$sql="INSERT INTO sleep (answer)
VALUES ('$_POST[q4]')";
$sql="INSERT INTO study (answer)
VALUES ('$_POST[q10]')";
$sql="INSERT INTO tobacco (answer)
VALUES ('$_POST[q6]')";
$sql="INSERT INTO weight (answer)
VALUES ('$_POST[q14]')";
$sql="INSERT INTO work_hours (answer)
VALUES ('$_POST[q3]')";
$sql="INSERT INTO work_hours_daily_pay (answer)
VALUES ('$_POST[q3a]')";
$sql="INSERT INTO work_hours_weekly_pay (answer)
VALUES ('$_POST[q3b]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con);
?>
The script runs with no errors however the last table is all that is updated. I can insert data into any one table. I'm not tied to using mulitple tables I just have been told it's better for queries.
[edited by: dreamcatcher at 9:43 am (utc) on Jan. 12, 2009]
[edit reason] No urls please! [/edit]
