asked on

PHP survey form

Hi!

I am creating an online PHP survey form.

I have two problems:
Problem 1:
I want to display "Your response is valid. Please try again" message only when any of the survey respondent's input failed validation. Currently, even though a suubject' response failed validation, it continues and display an invalid response on the screen.

Problem 2:

When a respondent's input passed validation, I would like to display the input in a table with the field name being placed at the first column (usually, field name is located in the first row of a table) and respondent's input being placed in the second column.

Hope and believe that you experts may kindly help me again!

In a few minutes, I am going to upoad my work in my web page (www.nice-man.com), and click "Download survey scripts".

Thanks a lot!

duta
May 25, 2006, at 1 pm

___________________________ form.php _____________________________________

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body bgcolor="cccccc">

<form action="process.php" method="POST">
<ul>
<h2 align="center">Online Survey</h2></FONT></ul><br><br>

<ul><ul>

<p><li><strong>Name:</strong>           
     
<input TYPE="TEXT" NAME="name" size="35" /><br>

</li>

<p><li><strong>Email Address:</strong>  
<input TYPE="TEXT" NAME="email" size="35" /><br>

</li>

<p><li><strong>Year in School:</strong><br><br>
<input TYPE="RADIO" NAME="year" value="freshman" size="35" />            Freshman ;
<input TYPE="RADIO" NAME="year" value="sophomore" size="35" />        Sophomore ;
<input TYPE="RADIO" NAME="year" value="junior" size="35" />                  Junior ;
<input TYPE="RADIO" NAME="year" value="senior" size="35" />                  Senior ;

</ul></ul>
<ul><ul>
<br><br>
<input TYPE      ="SUBMIT" NAME="SUBMIT"            VALUE="Submit" />
<input TYPE      ="RESET"        NAME="RESET"            VALUE="Reset" />

</li>
</ul></ul>
</form>
</body>
</html>
__________________________________ dbconnect.php _______________________________

<?php
//Set up variables

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'root';

?>

<?php
//Include Connection File
require_once("db.php");
?>

<?php
//Connect to MYSQL
$dbh = mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to connect to MySQL");

//Select database
$selected = mysql_select_db("lab",$dbh) or die("Could not select database table");

//Establish a database connection
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
?>

________________________________ process.php _____________________________________________

<?php

require_once("dbconnect.php");
?>

<?php



$pass                  = true;
$name            = "";
$email            = "";
$year                  = "";

function check_name ($name)
      {
     $watch= '^[[:alpha:]\.\' \-]{2,15}$';

            if (eregi ($watch, stripslashes(trim($name))))

            return true;
      else return false;
      }

function check_email($email)
      {
     $watch = '^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]{2,})+$';
     if (eregi($watch, $email))
return true;
     else return false;
      }

// name
if(empty($_POST["name"]))
      {
            $pass = false;
            echo "You didn't enter your name accurately.<br><br>";

      }
elseif (!check_name($_POST["name"]))
      {
            echo "Invalid name.";
      }
else
      {

            $name = trim($_POST["name"]);
      }

// email
if(empty($_POST["email"]))
      {
            $pass = false;
            echo "You didn't enter your email address accurately.<br><br>";

      }
elseif (!check_email($_POST["email"]))
      {
            echo "Invalid email address.";
            $pass = false;
      }
else
      {
            //use trim() just to remove any leading or trailing empty spaces
            $email = trim($_POST["email"]);
            $pass = true;
      }

// Year
if(empty($_POST["year"]))
      {
            $pass = false;
            echo "Select your year in school.<br><br>";
      }
else
      {
            //use trim() just to remove any leading or trailing empty spaces
            $year = trim($_POST["year"]);
      }

?>

<?php
//Now, if validation fails, display "You put an invalid response. Please try again" message, and quit.
// Currently, even if some of client's response were invalid, it continues.
if($pass = false )
{
      echo "You put an invalid response. Please try again!";
}

// If any of above validation fails,
else
{
?>

<br><br>
<h3> <?php echo $name; ?>, thank you for your response. Here are your records <br> which has been recorded in our database: </h3>

<?php
//Display inputs

            echo "<strong>Name:      </strong>                              ".$name.                              "<br />";
            echo "<strong>Email Address:      </strong>                  ".$email.                              "<br/ >";
            echo "<strong>Year in School:      </strong>            ".$year.                              "<br />";


<?php
}//End main IF
?>

<?php
//Close connection
mysql_close();
?>
_________________________________________________________________________________________

BogoJoker

What you asked could take very little code, or a bunch. Here is an example:

>Problem 1:
> I want to display "Your response is valid. Please try again" message only when any of the survey respondent's input
> failed validation. Currently, even though a suubject' response failed validation, it continues and display an invalid
> response on the screen.

The easy part is:
YOUR CODE:
if($pass = false )
CORRECT CODE:
if($pass == false )

You correctly used a boolean ($pass) and you used it correctly all the way down to that comparison.

Problem 2:
> When a respondent's input passed validation, I would like to display the input in a table with the field name being
> placed at the first column (usually, field name is located in the first row of a table) and respondent's input being
> placed in the second column.

Just format your code at the end into a table:
echo "<strong>Name: </strong> ".$name. "<br />";
echo "<strong>Email Address: </strong> ".$email. "<br/ >";
echo "<strong>Year in School: </strong> ".$year. "<br />";

Something like:
echo "<table>";
echo "<tr><th>Name:</th><td>$name</td></tr>";
echo "<tr><th>Email Address:</th><td>$email</td></tr>";
echo "<tr><th>Year in School:</th><td>$year</td></tr>";
echo "</table>";

Notice the double string optimazation. A varaible $name has its value printed in a double quoted string.
$name = 'Joe';
print "$name"; // prints Joe
print '$name'; // prints $name

And the table formatting is pretty straightforward. Normally you see just <tr> (table row) and <td> (table data). <th> is table hearder and bolds (strong's) the text inside it.

Enjoy
Joe P

(Also you can stop many of your errors by putting some javascript validation on the html page, ask if you would like some!)