Hi!
I am trying to create a simple online survey (using PHP and MySQL) which includes radio buttons, checkboxes and textareas.
Before posting this question, I spent quite a while reading the previously posted questions and responses about topics similar to mine. But for some reason, I could not figure out. I am a real novice in PHP and MySQL.
I will truly appreciate if you experts may kindly help me out.
Thanks a lot!
duta
Tuesday (May 23, 2006) at 11:13 a.m.
__________ form.php __________________________
<html>
<head><title>PHP Survey-</title></head>
<body>
<form action="process.php" method="POST">
<ul>
<b>Please fill the form accurately.</b></FONT></ul
<ul><ul>
<P><li><strong>Gender:</st
<INPUT TYPE="RADIO" NAME="gender" value="male" size="35"> Male<br>
<INPUT TYPE="RADIO" NAME="gender" value="female" size="35"> Female<br>
<INPUT TYPE="RADIO" NAME="gender" value="neutral" size="35"> Neutral<br>
</li>
<P><li><strong>Favorite Fruits:</strong><br>
<INPUT TYPE="checkbox" NAME="fruit" value="Apple" size="35"> Apple<br>
<INPUT TYPE="checkbox" NAME="fruit" value="Orange" size="35"> Orange<br>
<INPUT TYPE="checkbox" NAME="fruit" value="Banana" size="35">Banana<br>
</li>
<p><li><strong>What is your evaluation of this movie?</strong><p>
<select name="movie">
<option> Awesome!
<option> Good
<option> Poor
</select>
</li>
</ul></ul>
<ul><ul>
<p><li><strong>Write about Your Work Attitude: </strong><br>
<textarea NAME="block" cols="80" rows="10"><?php echo $_POST['block'] ?></textarea>
<br><br>
<INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="SUBMIT" >
<INPUT TYPE="RESET" NAME="RESET" VALUE="RESET">
</li>
</ul></ul>
</FORM>
<hr>
</body>
</html>
______________ process.php __________________________
<html>
<head>
<title>PHP Survey</title>
</head>
<body>
<?php
$gender = $_POST['gender'];
$fruit=$_POST['fruit'];
$movie = stripslashes($_POST['movie
$attitude =$_POST['block'];
if (!isset($gender))
echo("You didn't enter your gender<br>");
if (!isset($fruit))
echo("You didn't enter your race.<br>");
if (!isset($movie))
echo("You didn't enter your evaluation<br>");
if ( !isset($gender) || !isset($fruit) || !isset($movie) || !isset($attitude))
{
echo("<h3>" .$fname.",You responded the questions accurately; Thanks!</h3>");
echo "<h4> Here are your records </h4>";
echo ("<p>Gender: " . $gender);
echo ("<p>Fruits: " . $fruit);
echo ("<p>Movie: " . $movie);
echo ("<p>Attitude: " . $_POST['block']);
}
else
{
echo("<h2>Please, answer all questions</h2>");
}
$to = 'duta@hotmail.com'';
// subject
$subject = 'Testing survey4 ';
// message
$message1 = "
<html>
<head>
<title>Your Response </title>
</head>
<body>
<p>Here are Your Response</p>
<table width='76%' border='1' cellspacing='1' cellpadding='1'>
<tr>
<th> Gender </th><th>Fruits</th><th>Mo
<tr>
<td align='center'>$gender</td
<td align='center'>$attitude</
</table>
</body>
</html>
";
// $headers="<h2>Online Survey</h2>";
mail($to, $subject, $message1, $headers);
$conn = mysql_connect("localhost",
if (!$conn)
{ die ('Could not connect:' . mysql_error());}
else
{echo "You are connected!<br>";}
$sql="Create database my_db";
mysql_query ($sql, $conn);
mysql_select_db ("my_db", $conn);
// Create table
$sql="create table my_table (gender enum('female', 'male', 'neutral'),fruit enum('apple' 'orange', 'banana'), movie enum('awesome', 'good', 'poor'), attitude text)";
mysql_query($sql, $conn);
// Insert date into MySql table
mysql_query ( "INSERT INTO my_table(gender,fruit,movi
VALUES ('$gender', '$fruit','$movie','$attitu
echo "<br> Data inserted!";
// Output client's input
echo "<table width='76%' border='1' cellspacing='1' cellpadding='1'><tr><th>
Gender</th><th>Fruit</th><
$result =mysql_query("SELECT * FROM my_table");
while ($row=mysql_fetch_array($r
{
echo '<tr><td>';
echo $row['gender'];
echo '</td>';
echo '<td>';
echo $row['fruit'];
echo '</td>';
echo '<td>';
echo $row['movie'];
echo '</td>';
echo '<td>';
echo $row['attitude'];
echo '</td>';
echo "</tr><br>";
}
echo "</table>";
?>
</body>
</html>
__________________________
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi Duta,
On the gender selection, I mistakenly read the options are, male, female, neutered, and thought, 'what the heck kind of survey is this?'
But anyways,
The form.php looks fine, except for one thing, on the "Write about Your Work Attitude:" question, you echo the block variable, I assume so that a user doesn't have to retype their text. But you should check to see if the form was submited first otherwise the script won't find the variable, do this like this:
<?php
$block = ""
if(!empty($_POST["block"))
$block = $_POST["block"];
}
?>
<textarea NAME="block" cols="80" rows="10"><?php echo $_POST['block'] ?></textarea>
as for the process.php script
You should turn this
$gender = $_POST['gender'];
$fruit=$_POST['fruit'];
$movie = stripslashes($_POST['movie
$attitude =$_POST['block'];
if (!isset($gender))
echo("You didn't enter your gender<br>");
into something like this:
$pass_validation = true; //true is a boolean value
if(empty($_POST["gender"])
$pass_validation = false
echo "You didn't select a gender";
}
you can use if(!isset($_POST["gender"]
then only run the mail if
if($pass_validation == true){
send e-mail
do database queries
}
I'm wondering why you're creating the table everytime though. This would fail if you already have a table with the same name as the one you're trying to recreate.
This isn't a complete answer but it should help you out a bit.
-Javier
TO: jmar_click and kkhipple:
Thank you so much for your kind, prompt response.
Yes, some of the questions may look a little weird, but my real survey question is not like that. I tried to make it as simple as possible so that you may better and quicker help me out.
Would you kindly check my table's variable format? I am not quite sure whether I may use enum for radio buttons and checkboxes.
_____________ script to create table __________________________
$sql="create table my_table (gender enum('female', 'male', 'neutral'),fruit enum('apple' 'orange', 'banana'), movie enum('awesome', 'good', 'poor'), attitude text)";
______________ the end of the script __________________________
Thanks a lot!
duta
Tuesday at 11:45 a.m.
TO: All:
There are several problems with my script. One of the biggest problems is that MySQL does not respond to the following script to input client's response into MySQL table:
__________________________
// Insert date into MySql table
mysql_query ( "INSERT INTO my_table(gender,fruit,movi
VALUES ('$gender', '$fruit','$movie','$attitu
echo "<br> Data inserted!";
__________________________
Thanks!
duta
Tuesday at 11:49 a.m.
TO: jmar_click:
Thank you so much for trying so hard to help a real notice out.
I modified the script as you kindly suggested, and responded to the questions and clicked "Submit" button. I got the out as below. The script failed to create a table I intended to create.
_________ Output when "Submit" button was clicked __________________________
Please, answer all questions
You are connected!
INSERT INTO my_table(gender,fruit,movi
__________________________
Hope that this feedback may of any help to you in trying to help me!
Thanks a lot!
duta
Tuesday at 12:21 p.m.
Use this to create your table.
You should create it with a separate script. If you try to create it everytime the process.php script is run you'll get errors, from there you won't be able to insert and your errors will escalade, so its best to make sure the beggining works first.
CREATE TABLE `hriders`.`my_table` (
`surveryID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`gender` VARCHAR(45) NOT NULL DEFAULT '',
`fruit` VARCHAR(45) NOT NULL DEFAULT '',
`attitude` TEXT NOT NULL DEFAULT '',
PRIMARY KEY(`surveryID`)
)
surveryID is a primary key, unisined, can't be null and it auto increments
gender is a varchar field, as is fruit
attitude is a text field so it can store larger amounts of text
I'll be back with your insert query in a bit
TO: jmar_click:
Thanks a lot for kindly trying to help me.
By the way, the radio buttons and check buttons do not work by all means.
I read previous some of previous posts about a similar issue, and I noticed that they used array (something like "check[]") for values of checkboxes. But I could not completely comprehend how it worked. I guess that I might have to use an array to make checkboxe and radio buttons to work properly.
Thanks again!
duta
Tuesday at 1:23 p.m.
TO ALL:
The url of the previous post for an issue similar to mine is :
http://search.experts-exch
The reason why I am asking for your help is that I could not understand it quite clearly.
Thanks!
duta
Tuesday at 1:27 p.m.
You don't need to create an array for the radio buttons because you are only expecting one of the choices. But you do need an array for the check boxes because they all have the same name and you want to get all the choises the user gave you.
This brings up a question. How are you planing to store the fruit choices? one choice per field? or all choices together as a string, maybe a comma delimeted string?
fruit1,fruit2,fruit3
This script also looks kinda odd for a survey? is it for a school project?
TO: jmar_click:
Thanks again for your very kind response and tips.
This is neither a school project nor a work project. I am doing this to create a simple workable online survey as a part of my effort to learn PHP and MySQL. Yes, my work may look very odd. I am going to post my work in my new web site where I will upload my work as a zip file.
I will be back to you as soon as I am done with uploading it.
Thanks again!
duta
Tuesday at 1:55 p.m.
TO: All:
Hi!
I put my scripts in my web site (http://www.nice-man.com).
Hope you experts may kindly help me out.
Thanks again!
duta
Tuesday at 3:09 p.m.
TO: jmar_click:
Thank you so much for your kind response and for extraordinary effort to help me.
Yes, my e-mail address is "youngtiger"@mchsi.com" (Hope that posting my email address here may not violate any site rules).
The biggest bottleneck is that there is no communication between PHP script and MYSQL datebase when radio buttons and/or checkboxes are clicked.
Thanks again!
duta
Tuesday at 4:54 p.m.
Thanks duta,
You're almost there the way you have your script, but you have too much going on and you'll need to break things apart a bit. Especially if you are just learning php and/or mysql. I will show you all of this on the scrips i'll e-mail you.
I also included the code to handle check boxes. Radio buttons aren't a problem and don't need any special attention like checkboxes do.
OK here is the finished code, I didn't add the mail function, but that looked like it worked on your script. I also used the fields from earlier, so I didn't use the e-mail field. Just stick there in your server, and supply your mysql log in information in the connection file
SQL Create Table Code, database name is assumed to be my_db
CREATE TABLE `my_db`.`my_table` (
`surveyID` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`gender` VARCHAR(45) NOT NULL DEFAULT '',
`fruit` VARCHAR(45) NOT NULL DEFAULT '',
`movie` VARCHAR(45) NOT NULL DEFAULT '',
`attitude` TEXT NOT NULL DEFAULT '',
PRIMARY KEY(`surveyID`)
)
ENGINE = InnoDB;
----------------FORM CODE---------------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtm
<html xmlns="http://www.w3.org/1
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<form action="process.php" method="POST">
<ul>
<b>Please fill the form accurately.</b></FONT></ul
<ul><ul>
<p><li><strong>Gender:</st
<input TYPE="RADIO" NAME="gender" value="male" size="35" /> Male<br>
<input TYPE="RADIO" NAME="gender" value="female" size="35" /> Female<br>
<input TYPE="RADIO" NAME="gender" value="neutral" size="35" /> Neutral<br>
</li>
<p><li><strong>Favorite Fruits:</strong><br>
<input TYPE="checkbox" NAME="fruit[]" value="Apple" size="35" /> Apple<br>
<input TYPE="checkbox" NAME="fruit[]" value="Orange" size="35" /> Orange<br>
<input TYPE="checkbox" NAME="fruit[]" value="Banana" size="35" />Banana<br>
</li>
<p><li><strong>What is your evaluation of this movie?</strong><p>
<select name="movie">
<option selected="selected"> Awesome!</option>
<option> Good</option>
<option> Poor</option>
</select>
</li>
</ul></ul>
<ul><ul>
<p><li><strong>Write about Your Work Attitude: </strong><br>
<textarea NAME="block" cols="80" rows="10"><?php echo $_POST['block'] ?></textarea>
<br><br>
<input TYPE="SUBMIT" NAME="SUBMIT" VALUE="SUBMIT" />
<input TYPE="RESET" NAME="RESET" VALUE="RESET" />
</li>
</ul></ul>
</form>
</body>
</html>
--------------------------
<?php
//Include Connection File
require_once("dbconnect.ph
?>
<?php
//We'll use this variable to decide if the form passed validation
$pass = true;
//Get variables from the form POST
#first we're going to initialize them, good practice towards qriting secure php, but not neccessary
$gender = "";
$fruit = "";
$movie = "";
$attitude = "";
if(empty($_POST["gender"])
$pass = false;
echo "Select a gender";
}
else{
//use trim() just to remove any leading or trailing empty spaces
$gender = trim($_POST["gender"]);
}
if(empty($_POST["fruit"]))
echo "Select a fruit";
$pass = false;
}
else{
//use trim() just to remove any leading or trailing empty spaces
while (list ($key,$val) = @each ($_POST["fruit"])) {
$fruit .= "$val,";
}
}
if(empty($_POST["movie"]))
echo "Select a movie";
$pass = false;
}
else{
//use trim() just to remove any leading or trailing empty spaces
$movie = trim($_POST["movie"]);
}
if(empty($_POST["block"]))
echo "Select a attitude";
$pass = false;
}
else{
//use trim() just to remove any leading or trailing empty spaces
$attitude = trim($_POST["block"]);
}
?>
<?php
//Now, if validation was passed, continue
if($pass = true ){
?>
<h3>" .$fname.",You responded the questions accurately; Thanks!</h3>
<h4> Here are your records </h4>
<?php
//Display inputs
echo "Gender: ".$gender."<br />";
echo "Fruits: ".$fruit."<br/ >";
echo "Movie: ".$movie."<br />";
echo "Attitude: ".$attitude."<br />";
//Next we want to insert the values into the table
$insert_qry = "INSERT INTO my_table VALUES (NULL, '$gender', '$fruit', '$movie', '$attitude')";
echo $insert_qry;
$qry_state = mysql_query($insert_qry) OR die("<br><br>This error occured when I tried to insert a record: " .mysql_error());
//If the query was successful, then the function mysql_query() will return a 1 for true which we capture in $qry_state
if($qry_state == 1){
echo "<br><br>Your response has been recorded, thanks.<br><br>";
}
//Now we want to select all the records from the database table
$select_qry = "SELECT * FROM my_table";
$select_results = mysql_query($select_qry);
//$results_count = mysql_num_rows($select_res
?>
<!--Now we can start our HTML table to display the results-->
<table border="1">
<tr>
<td>Gender</td>
<td>Fruit</td>
<td>Movie</td>
<td>Attitude</td>
</tr>
<?php
//The function mysql_fetch_array() converts the records set into an array that we can look through with a WHILE loop
while($row = mysql_fetch_array($select_
?>
<tr>
<td><?php echo $row["gender"];?></td>
<td><?php echo $row["fruit"];?></td>
<td><?php echo $row["movie"];?></td>
<td><?php echo $row["attitude"];?></td>
</tr>
<?
}
?>
</table>
<?php
}//End main IF
?>
<?php
//Close connection
mysql_close();
?>
-----This is your connection string---------------
<?php
//Set up variables
$dbhost = 'xxxx';
$dbuser = 'xxx';
$dbpass = 'xxxx';
//Connect to MYSQL
$dbh = mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to connect to MySQL");
//Select database
$selected = mysql_select_db("my_db",$d
//Establish a database connection
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
?>
This works in my server, it should work on yours too, and may I recommend you read about the functions at php.org
Good luck!
TO: jmar_click:
Thank you so much for your very, very kind, extraordinary help.
Your scripts worked just great. You are a genius. Wish I may be able to reward you with 1 million points, not the 500 points offered.
I will try to learn more and harder so that I may someday be able to help others as you did to me.
You are just fabulous!
Thanks again!
duta
May 23, 2006, at 10:55 p.m.
I'm glad you got it to work duta, do you understand how and why things work?
It wasn't a difficult question really. There are experts here who are much more knowledgeable than I am...they're the real experts. I still have a lot of learning to do to get to their level. But I never mind sharing what I know with others, thats what EE is all about it.
TO: jmar_click:
You are as humble as you are knowledgeable.
It was so thoughtful of you to put a comment on almost each line of your script. I guess you spent quite much time for me. I really love this service and people like you who are always eager to help people who need help.
PHP and MySQL scripts still look not familr to me even though I spent quite much time trying to learn them. I know it takes pain to obtain anything worthy.
My one more salute to you and to others who are always willing to share their knowledge with less knowledgeable people.
duta
Wednesday (May 24, 2006) at 10:27 p.m.
Business Accounts
Answer for Membership
by: kkhipplePosted on 2006-05-23 at 09:22:47ID: 16743865
Something along the lines of if isset( $_POST['gender'] ) { echo $_POST['gender']; } should be able to display the gender value if it is set.