survey for school grads... Another question

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 361,626 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,224 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 1914 | Replies: 62 | Solved

Page 1 of 7

Last »

•

Join Date: Dec 2007

Posts: 59

Reputation: dani190 is an unknown quantity at this point

Rep Power: 1

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

Location: Bangalore, India

Posts: 2,861

Reputation: nav33n has a spectacular aura about

Rep Power: 7

Solved Threads: 205

nav33n

Offline

Posting Maven

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

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

*PM asking for help will be ignored*

•

Join Date: Dec 2007

Posts: 59

Reputation: dani190 is an unknown quantity at this point

Rep Power: 1

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 1:35 pm.

•

Join Date: Nov 2007

Location: Bangalore, India

Posts: 2,861

Reputation: nav33n has a spectacular aura about

Rep Power: 7

Solved Threads: 205

nav33n

Offline

Posting Maven

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");

•

Join Date: Dec 2007

Posts: 59

Reputation: dani190 is an unknown quantity at this point

Rep Power: 1

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

Location: Bangalore, India

Posts: 2,861

Reputation: nav33n has a spectacular aura about

Rep Power: 7

Solved Threads: 205

nav33n

Offline

Posting Maven

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 1:58 pm.

•

Join Date: Dec 2007

Posts: 59

Reputation: dani190 is an unknown quantity at this point

Rep Power: 1

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

Location: Bangalore, India

Posts: 2,861

Reputation: nav33n has a spectacular aura about

Rep Power: 7

Solved Threads: 205

nav33n

Offline

Posting Maven

Re: survey for school grads... Another question

Jan 14th, 2008

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

•

Join Date: Dec 2007

Posts: 59

Reputation: dani190 is an unknown quantity at this point

Rep Power: 1

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

(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 />

...

Thanks, Dani

•

Join Date: Nov 2007

Location: Bangalore, India

Posts: 2,861

Reputation: nav33n has a spectacular aura about

Rep Power: 7

Solved Threads: 205

nav33n

Offline

Posting Maven

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.