survey for school grads... Another question

Question

dani190 0 Junior Poster in Training

16 Years Ago

Hey Sorry to bug you guys again. I had one more question. As i am developing this program now i realize that i have no clue how to save the data to the database.

basically the whole point in making this program was to be able to export a table in my database that would store all the submitted data from the survey.

I will have like 30 questions and almost 400 grads. all that data needs to be recorded.

What is going to be the easiest table structure to do that type of thing?

Or is e-mail just going to end up being easier?

php

2 Contributors
62 Replies
354 Views
1 Week Discussion Span
Latest Post 16 Years Ago Latest Post by dani190

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 1 · 2008-01-14T14:06:14+00:00

CREATE TABLE test (
id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
name VARCHAR( 100 ) NOT NULL ,
address VARCHAR( 100 ) NOT NULL
) ENGINE = InnoDB

If that's my table, and I have a form with 2 fields name and address, this is how I would be inserting the values to the table test. This should get you started.(I hope!)

<?php
if(isset($_POST['submit'])){
$conn=mysql_connect("localhost","root");
mysql_select_db("exact");
$name=$_POST['name'];
$address=$_POST['address'];
$query="INSERT INTO TEST (ID,NAME,ADDRESS) VALUES ('','$name','$address')";
mysql_query($query);
}
?>
<html>
<body>
<form method="post" action="insert_example.php">
Enter Name: <input type="text" name="name"><br />
Enter Address: <textarea rows="10" cols="20" name="address"></textarea>
<br />
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>

Cheers,
Nav

dani190 0 Junior Poster in Training · Answer 2 · 2008-01-15T00:29:34+00:00

so if i wanted to send all the results via e-mail i would do something similar? i am going to search on that site you gave me and that book lets see if i can get it....

I found out how to mail it i just need some help with the security now.

I want to stop people from just going to the page vote.php, i want them going through the login how is that done?

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 3 · 2008-01-15T00:43:41+00:00

You can use mail function.
Eg. mail("to address","subject","message contents","from: from address");

dani190 0 Junior Poster in Training · Answer 4 · 2008-01-15T00:51:53+00:00

so i know that part but how do i then integrate it with the submit button? And how do i tell the mail function what to mail... Like what form questions I wasnt able to find out how to do that yet

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 5 · 2008-01-15T00:55:42+00:00

Well, you can have a condition to check if the submit button was pressed.

if(isset($_POST['submit'])){
$message="This is the body of this mail. blah blah blah..........some more text... ";
mail("test@gmail.com","test mail",$message,"from: someone@gmail.com");
}

you can send all the data in the message part of the mail.

dani190 0 Junior Poster in Training · Answer 6 · 2008-01-15T05:07:54+00:00

ok so basically i can wrap that around the whole form were they are entering the info?

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 7 · 2008-01-15T10:50:52+00:00

Yep. Get all the form information, align it as you want. Put it in the 'message' part of the mail.

dani190 0 Junior Poster in Training · Answer 8 · 2008-01-17T01:50:56+00:00

k so 1 more thing

In the email part i dont know how to retrieve the persons answers from the folllowing...

<label>40. Funniest</label><br />
<select name="funniest">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

...

Thanks, Dani

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 9 · 2008-01-17T02:41:49+00:00

On submitting the page, if the user has selected a value from the select box, it will be in $_POST. So, you can do something like $x=$_POST. $x will have his selection.

dani190 0 Junior Poster in Training · Answer 10 · 2008-01-17T05:05:24+00:00

just goes to show i dont know php enough yet... I actually bought another book so i will be learning it for sure.

Thank you very very much for your help, so glad someone was able to as i had to get this done.

Thanks again

dani190 0 Junior Poster in Training · Answer 11 · 2008-01-17T09:24:48+00:00

Ok after about an hour of trying to figure this part out i wasn't able to....

So i have those variables

$a=$_REQUEST['priceisright'];

"I read that i should be using request and post in the message part obviouslly..."

Now when i go to e-mail

// Mail Script
if(isset($_POST['submit'])){
$message = "Thank you for registering with our site!\nYour selection was '{$_POST['style']}'.\n\nSincerely,\nUs";
mail("****@anblickstudios.com","Grad Survey 08",$message,"from: *****@anblickstudios.com");
}
?>

Now i am pretty sure i have the wrong format in this portion

'{$_POST['style']}'.

Mind helping me with my format there. I almost have it

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 12 · 2008-01-17T09:31:29+00:00

no problemo! :)

Instead of {$_POST}, you can assign that to a variable and use that variable. Its little confusing for starters on how php handles strings.

// Mail Script
if(isset($_POST['submit'])){
$selection=$_POST['style'];
$message = "Thank you for registering with our site!\nYour selection was $selection.\n\nSincerely,\nUs";
mail("****@anblickstudios.com","Grad Survey 08",$message,"from: *****@anblickstudios.com");
}
?>

You can do that.

dani190 0 Junior Poster in Training · Answer 13 · 2008-01-17T09:36:47+00:00

so then for multiple selections i just use commas?

so it would be

$selection=$_POST['style'], $_POST['funniest'];

or can i just go and use what i already typed?

$a=$_POST['priceisright'];
$b=$_POST['millionaire'];
$c=$_POST['loosepassport'];
$d=$_POST['vanriver'];
$e=$_POST['spusecheat'];
$f=$_POST['marrymoney'];
$g=$_POST['5divorces'];
$h=$_POST['primeminister'];
$i=$_POST['teacheci'];

I am guessing that would work now wont it?

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 14 · 2008-01-17T09:42:44+00:00

Yep. What you have done is correct.

$x=$_POST['field1'];
$y=$_POST['field2'];
$z=$_POST['field3'];
....

//In case you want to concat them, you can do it this way. 
$string = $x." ".$y." ".$z; //This will concat all the three variables separated by a space.
...

:) Hope that helps.

dani190 0 Junior Poster in Training · Answer 15 · 2008-01-17T09:44:28+00:00

hmm only issue is it will still send me back nothing...

Thats so weird? I select something and it just sends me nothing

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 16 · 2008-01-17T09:47:08+00:00

Try out a sample mail first to your own id. If you get it, then the problem is with your script. If you dont get a mail, then probably, your smtp is not configured properly.

dani190 0 Junior Poster in Training · Answer 17 · 2008-01-17T09:49:13+00:00

sorry i didn't get what you said.

I get the e-mail it says this exactly

Thank you for registering with our site!
Your selection was .

Sincerely,
Us

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 18 · 2008-01-17T09:57:33+00:00

ok..Then the problem is not with smtp.. Check if $_POST is sending a value.

dani190 0 Junior Poster in Training · Answer 19 · 2008-01-17T09:59:13+00:00

lol sorry man i dont even know how to do that yet....

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 20 · 2008-01-17T10:08:27+00:00

comment out mail(...) line in your script and on top of the script, right after <?php put this line. print_r($_POST); Then fill out the form once again, click on submit. Check If any value assigned to .

dani190 0 Junior Poster in Training · Answer 21 · 2008-01-17T10:11:19+00:00

ok checked. Absolutely nothing is being assigned. I tried it on a bunch of other ones also. Nothing changes with the post message at the top...

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 22 · 2008-01-17T10:15:26+00:00

nav33n 472 Purple hazed!

16 Years Ago

Well, you need to post your script then.

dani190 0 Junior Poster in Training · Answer 23 · 2008-01-17T10:16:35+00:00

<?php
print_r($_POST);
$conn=mysql_connect("***********.anblickstudios.com","************","*******"); 
mysql_select_db("gradsurvey");
$query="select user_id from grads";
$result=mysql_query($query);
$option="";
while($row=mysql_fetch_array($result)) {
   $option.="<option value=".$row['grads'].">".$row['user_id']."</option>";    
}
if(isset($_POST['submit'])) {
$query="UPDATE TABLE SET VOTE_STATUS = 1 WHERE USER_ID ='".$_POST['grads']."'";	
mysql_query($query);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Etobicoke Collegiate Institute's Grad Survey 2008</title>
</head>
<body>


<?php
// Welcome the user
echo '<h2>Welcome';
if (isset($_SESSION['user_id'])) {
	echo ", {$_SESSION['user_id']}!";
}
echo '</h2>';


?>



<?php
// Mail Script
if(isset($_POST['submit'])){
$selection=$_POST['style'];
$a=$_POST['priceisright'];
$b=$_POST['millionaire'];
$c=$_POST['loosepassport'];
$d=$_POST['vanriver'];
$e=$_POST['spusecheat'];
$f=$_POST['marrymoney'];
$g=$_POST['5divorces'];
$h=$_POST['primeminister'];
$i=$_POST['teacheci'];
$j=$_POST['40yearoldvirgin'];
$k=$_POST['livewparents'];
$l=$_POST['dieholdingcell'];
$m=$_POST['damagedliver'];
$n=$_POST['jail'];
$q=$_POST['plasticsurgery'];
$r=$_POST['adoptchildren'];
$s=$_POST['buyfriends'];
$t=$_POST['Dictionary'];
$u=$_POST['guitarhero'];
$v=$_POST['convent'];
$w=$_POST['souljaboywedding'];
$x=$_POST['nobelpeace'];
$y=$_POST['huggerenvironment'];
$z=$_POST['mack'];
$aa=$_POST['ego'];
$ab=$_POST['partier'];
$ac=$_POST['cougar'];
$ad=$_POST['awkward'];
$ae=$_POST['dramtic'];
$af=$_POST['gossip'];
$ag=$_POST['cluts'];
$ah=$_POST['car'];
$ai=$_POST['style'];
$aj=$_POST['hair'];
$ak=$_POST['cutestcouple'];
$al=$_POST['hottestparents'];
$am=$_POST['playboygirl'];
$an=$_POST['kingswaymd'];
$aq=$_POST['funniest'];
$ar=$_POST['athletic'];

$message = "Price is right: $a";
mail("email@anblickstudios.com","Grad Survey 08",$message,"from: email@anblickstudios.com");
}

// Mail Script
if(isset($_POST['submit'])){
$selection=$_POST['style'];
$message = "Thank you for registering with our site!\nYour selection was $selection.\n\nSincerely,\nUs";
mail("****@anblickstudios.com","Grad Survey 08",$message,"from: *****@anblickstudios.com");
}
?>

<form action="vote.php" method="post">
<fieldset><legend>Please complete the following questions. Thanks!</legend>




<Label> <b>Most likely to...</b></Label><br />


<label>1. Be on the price is right</label><br />
<select name="priceisright">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>2. Become a millionaire</label><br />
<select name="millionaire">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>3. Loose passport in Europe</label><br />
<select name="loosepassport">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>4. Live in a van by the river</label><br />
<select name="vanriver">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>5. Cheat on Spouse</label><br />
<select name="spusecheat">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>6. Marry for money</label><br />
<select name="marrymoney">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>7. have 5 divorces before 30</label><br />
<select name="5divorces">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>8. Be prime minister of Canada</label><br />
<select name="primeminister">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>9. Teach at ECI</label><br />
<select name="teacheci">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>10. Be a 40 year old virgin</label><br />
<select name="40yearoldvirgin">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>11. Live with their parents</label><br />
<select name="livewparents">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>12. Die holding their cell phone</label><br />
<select name="dieholdingcell">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>13. Have a damaged liver before 19</label><br />
<select name="damagedliver">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>14. End up in jail</label><br />
<select name="jail">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>15. Get plastic surgery on their whole body</label><br />
<select name="plasticsurgery">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>16. Adopt children from a 3rd world</label><br />
<select name="adoptchildren">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>17. Buy their friends</label><br />
<select name="buyfriends">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>18. Memorize the Dictionary</label><br />
<select name="Dictionary">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>19. Still be at ECI in 5 years</label><br />
<select name="eci5years">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>20. Become the true Guitar Hero</label><br />
<select name="guitarhero">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>21. Join a Convent</label><br />
<select name="convent">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>22. Dance to Soulja boy at their wedding</label><br />
<select name="souljaboywedding">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>23. Win the nobel peace prize</label><br />
<select name="nobelpeace">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>24. Be the biggest tree hugger/environmentally friendly</label><br />
<select name="huggerenvironment">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label><b>Biggest</b></label><br />

<label>25. Mack </label><br />
<select name="mack">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>26. Ego</label><br />
<select name="ego">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>27. Partier</label><br />
<select name="partier">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>28. Cougar</label><br />
<select name="cougar">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>29. Awkward</label><br />
<select name="awkward">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>30. Dramatic</label><br />
<select name="dramatic">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>31. Gossip</label><br />
<select name="gossip">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>32. Cluts</label><br />
<select name="cluts">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label><b> Best</b></label><br />

<label>33. Car</label><br />
<select name="car">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>34. Style</label><br />
<select name="style">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>35. Hair</label><br />
<select name="hair">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label> <b>------------------------------------------------------------</b></label><br />

<label>36. Cutest Couple</label><br />
<select name="cutestcouple">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>37. Hottest Parents</label><br />
<select name="hottestparents">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>38. Playboy/Playgirl</label><br />
<select name="playboygirl">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>39. Kingsway Mom & Dad</label><br />
<select name="kingswaymd">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<label>40. Funniest</label><br />
<select name="funniest>
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>

<br />

<label>41. Most athletic</label><br />
<select name="athletic">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />

<input name="submit" value="submit" type="submit">





</form>


</body>
</html>

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 24 · 2008-01-17T10:37:49+00:00

Weird. This script is running fine on my system. Print out the message! I get,

Thank you for registering with our site! Your selection was naveen2. Sincerely, Us

. Also check if you are populating the dropdown list! Or, I think you probably selected either "Please Choose One Person" or "Not Voting". Assign some value to these options and test.

dani190 0 Junior Poster in Training · Answer 25 · 2008-01-18T00:33:08+00:00

ok but how do i check? When i click the drop down menu i see all the names. That all works...

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 26 · 2008-01-18T05:51:38+00:00

huh! Right click on your page and click on view source. Check if the value for <option value=''> is being set. Check if its not null. Then select some dropdown list values and check again. When you submit, if you get something like, array([priceisright]=>your choice,......) , then your code has no problem!

dani190 0 Junior Poster in Training · Answer 27 · 2008-01-18T06:16:45+00:00

well if you mean this

<option value=>Jacob Anderson</option><option value=>Mohammed Abbas</option><option value=>Hiroaki Abe</option>

Yes they are being populated properly. I tried selecting but nothing. So maybe something is wrong with the script?

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 28 · 2008-01-18T06:24:19+00:00

See! I told you. Values are not being assigned to the option :) ! This should have been,

<option value=Jacob Anderson>Jacob Anderson</option><option value=Mohammed Abbas>Mohammed Abbas</option><option value=Hiroaki Abe>Hiroaki Abe</option>

:)

Edit: Change $query="select user_id from grads"; to $query="select user_id,grads from grads"; It should work.

dani190 0 Junior Poster in Training · Answer 29 · 2008-01-18T06:27:30+00:00

so hows that fixed? thats straight from the database? Its not importing correctly possibly

FIXED!

I hope... :P 1 second