DaniWeb Forum Index > Web Development > PHP

survey for school grads... Another question

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

Last »

•

Join Date: Dec 2007

Posts: 63

Reputation: dani190 is an unknown quantity at this point

Solved Threads: 0

dani190

Offline

Junior Poster in Training

survey for school grads... Another question

Jan 13th, 2008

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?

•

Join Date: Nov 2007

Posts: 3,748

Reputation: nav33n is a jewel in the rough

Solved Threads: 331

nav33n

Offline

Senior Poster

Re: survey for school grads... Another question

Jan 14th, 2008

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
 CREATE TABLE test (
id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
name VARCHAR( 100 ) NOT NULL ,
address VARCHAR( 100 ) NOT NULL
) ENGINE = InnoDB
 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!)

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?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>
<?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

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Dec 2007

Posts: 63

Reputation: dani190 is an unknown quantity at this point

Solved Threads: 0

dani190

Offline

Junior Poster in Training

Re: survey for school grads... Another question

Jan 14th, 2008

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?

Last edited by dani190; Jan 14th, 2008 at 2:35 pm.

•

Join Date: Nov 2007

Posts: 3,748

Reputation: nav33n is a jewel in the rough

Solved Threads: 331

nav33n

Offline

Senior Poster

Re: survey for school grads... Another question

Jan 14th, 2008

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

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Dec 2007

Posts: 63

Reputation: dani190 is an unknown quantity at this point

Solved Threads: 0

dani190

Offline

Junior Poster in Training

Re: survey for school grads... Another question

Jan 14th, 2008

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

•

Join Date: Nov 2007

Posts: 3,748

Reputation: nav33n is a jewel in the rough

Solved Threads: 331

nav33n

Offline

Senior Poster

Re: survey for school grads... Another question

Jan 14th, 2008

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

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
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");
}
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.

Last edited by nav33n; Jan 14th, 2008 at 2:58 pm.

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Dec 2007

Posts: 63

Reputation: dani190 is an unknown quantity at this point

Solved Threads: 0

dani190

Offline

Junior Poster in Training

Re: survey for school grads... Another question

Jan 14th, 2008

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

•

Join Date: Nov 2007

Posts: 3,748

Reputation: nav33n is a jewel in the rough

Solved Threads: 331

nav33n

Offline

Senior Poster

Re: survey for school grads... Another question

Jan 15th, 2008

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

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Dec 2007

Posts: 63

Reputation: dani190 is an unknown quantity at this point

Solved Threads: 0

dani190

Offline

Junior Poster in Training

Re: survey for school grads... Another question

Jan 16th, 2008

k so 1 more thing

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

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<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>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

•

Join Date: Nov 2007

Posts: 3,748

Reputation: nav33n is a jewel in the rough

Solved Threads: 331

nav33n

Offline

Senior Poster

Re: survey for school grads... Another question

#10

Jan 16th, 2008

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

Ignorance is definitely not bliss!

*PM asking for help will be ignored*