[Resolved] Form-Validation-Next Page

space1

I've working on this all weekend and still can't figure it out. So here's my problem...
I'm using a form and want to validate the data in the form and then send the user to another php page once the data is validated. This sounds easy, but I've found it quite a challenge. The problem lies in the "action" element in the form tag:
<form ACTION="SignUp3.php" method="post" name="Form1" >

Either the action part is used to bring the user to the next page (after the form validates) or the action part is used in the validation of the form, but then once it validates, there's nothing to take the user to the next page. The Header() function has been suggested to move to the next page but it consistently gives an error.

So please, could you help? I used to do this in ASP and javascript, but my hope was to move entirely to php.

Thank you,
Andrea

kevinsequeira

post the code that you have along with what errors you're getting

reg
kevin

space1

Great, thank you! Here is the full code. I'm using an include file which I can send too. However, the include file doesn't really affect anything. The section in question is where it says: // 1) Form Successfully validated
// 2) Insert into database
// 3) Go to the next page (there will be another form there for user to fill out)

It does everything except #3 which is to send the user to the next page once the form has been validated and the data posted in the database. Thank you!

THE CODE:

<?php
// Check to see if the form has been submitted (by checking the hidden form field $form_complete
if ($_REQUEST['form_complete'])
{
// Include the class
include("./validator-class.php");

	// Initiate a new instance of the class
	$my_form = new validator;

	// Check to see if the form fields have valid data
	// Please check the README.txt file for more info...
	if ($my_form->validate_fields("FirstName, LastName")) 
	{
		// 1) Form Successfully validated
		// 2) Insert into database
		// 3) Go to the next page (there will be another form there for user to fill out)

//------------------------
$username = "u51778201";
$password = "19eed";
$hostname = "mysqlhost";

$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
mysql_select_db("d52778201");
//------------------------

$firstname_var=$REQUEST['FirstName'];
$lastname_var=$REQUEST['LastName'];

$email_var=$REQUEST['Email'];
$zip_var=$REQUEST['Zip'];
$homephone_var=$REQUEST['HomePhone'];
$birthyear_var=$REQUEST['Birthyear'];
$gender_var=$REQUEST['Gender'];
$university_var=$REQUEST['University'];
$heardaboutit_var=$REQUEST['HeardAboutIt'];
$friendemail1_var=$REQUEST['FriendEmail1'];
$friendemail2_var=$REQUEST['FriendEmail2'];
$waiver_var=$REQUEST['Waiver'];

$insert = "INSERT INTO People1
(FirstName, LastName, Email, HomePhone, Birthyear,
Gender, University, HeardAboutIt, FriendEmail1, FriendEmail2, Waiver, DateEntered)

VALUES
('$firstname_var', '$lastname_var', '$email_var', '$homephone_var', '$birthyear_var',
'$gender_var', '$university_var', '$heardaboutit_var',
'$friendemail1_var', '$friendemail2_var', '$waiver_var', now())";

		print("<font face='verdana,arial' size=1><br>\n");
		print($insert);	
		print("<br><br>\n");

mysql_query($insert) or die ("Sorry, there was a problem. Could not add data to the table.");
exit;
}
else{
print($my_form->error . "<br><br>");
}
} // End of 1st If Statement

?>

<form name="SignUp3.php" method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="hidden" name="form_complete" value="1">
<TABLE> 
<TR>
<TD valign="top">
<font face="verdana,arial" size=2><strong>
<br>
Input Info
<br><br>
</strong>
</TD>
</TR>

<TR>
<td width=90 ><font face="verdana,arial" size=1>First Name <font color=orange>*</font></td>
<td><input type="text" name="FirstName" value="<?php echo $_REQUEST['FirstName']; ?>"></td>
</tr>

<tr>
<td><font face="verdana,arial" size=1>Email <font color=orange>*</font></td>
<td><input type="text" name="Email" value="<?php echo $_REQUEST['Email']; ?>"></td>
</tr>

<tr>
<td><font face="verdana,arial" size=1>Home Phone </td>
<td><input type="text" name="HomePhone" value="<?php echo $_REQUEST['HomePhone']; ?>"><font color =#999999 size="1">  (###) ###-#### </font><BR></td>
</tr>

<tr>
<td><font face="verdana,arial" size=1>Birthdate (year only) <font color=orange>*</font> </td>

<td><font face="verdana,arial" size=1>
<input type="text" name="Birthyear" value="<?php echo $_REQUEST['Birthyear']; ?>">
<font face="verdana,arial" size=1 color =#999999>  Example: 1968 </font>
</td>
</tr>

<tr>
<td><font face="verdana,arial" size=1>Gender <font color=orange>*</font> </td>
<td><INPUT TYPE="radio" NAME="Gender" VALUE="Male" CHECKED><font face="verdana,arial" size=2>Male
<INPUT TYPE="radio" NAME="Gender" VALUE="Female" ><font face="verdana,arial" size=2>Female</td>
</tr>

<tr>
<td valign="baseline"><font face="verdana,arial" size=1>Your University </td>

<td valign="baseline"><font face="verdana,arial" size=1>
<input type="text" name="University" value=""><BR><font face="verdana,arial" size=1 color =#999999>(the college from which you graduated...like for a multi-school social or sports event)</font>
</td>
</tr>

<tr>
<td><font face="verdana,arial" size=1>How did you hear about<br> Space City Mixer?</font></td>
<td><INPUT TYPE="text" NAME="HeardAboutIt" size=40> <BR> </td>
</tr>

<tr>
<br>
<td rowspan=2 width="145">
<font face="verdana,arial" size=1>
2's a Company but 3's a Party!! Sign Up a <br>Couple of Friends...<br></td>
<td>
<font face="verdana,arial" size=1>
  Friend's Email #1 <INPUT TYPE="text" NAME="Email_Friend1" size=30></td>
</tr>

<tr>
<td>
<font face="verdana,arial" size=1>
  Friend's Email #2 <INPUT TYPE="text" NAME="Email_Friend2" size=30></td>
</tr>

<tr>
<td colspan=2>
<br>
<input type="checkbox" name="Waiver" value="<?php echo $_REQUEST['Waiver']; ?>"><font face="verdana,arial" size=1>I've read and accepted the <a href="LiabilityWaiver.asp">Terms of Participation</a></font><font color=orange size=1> *</font>
<BR>
</td>
</tr>

<tr><td colspan=2>
<font face="verdana,arial" size=1 color="#ff6600"><BR>
You will receive up to 2-3 invites a week. If you find that it's too many emails,
let us <BR>know and we can put you on a "low email" diet! Thanks!
<BR><BR>
</td>
</tr>

</body>
</html>

kevinsequeira

i think i know what the problem with the header() that you would get.
if you are using the header("location:whatever_page.php"); to automatically move the user to the next page you cannot have any output to the screen before this statement.
ie you cannot have any html tags, or echo or print statement or even blank lines.
so move this part

<?php
// Check to see if the form has been submitted (by checking the hidden form field $form_complete
if ($_REQUEST['form_complete'])
{
// Include the class
include("./validator-class.php");

// Initiate a new instance of the class
$my_form = new validator;

// Check to see if the form fields have valid data
// Please check the README.txt file for more info...
if ($my_form->validate_fields("FirstName, LastName"))
{
// 1) Form Successfully validated
// 2) Insert into database
// 3) Go to the next page (there will be another form there for user to fill out)

//------------------------
$username = "u51778201";
$password = "19eed";
$hostname = "mysqlhost";

$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
mysql_select_db("d52778201");
//------------------------

$firstname_var=$REQUEST['FirstName'];
$lastname_var=$REQUEST['LastName'];
$email_var=$REQUEST['Email'];
$zip_var=$REQUEST['Zip'];
$homephone_var=$REQUEST['HomePhone'];
$birthyear_var=$REQUEST['Birthyear'];
$gender_var=$REQUEST['Gender'];
$university_var=$REQUEST['University'];
$heardaboutit_var=$REQUEST['HeardAboutIt'];
$friendemail1_var=$REQUEST['FriendEmail1'];
$friendemail2_var=$REQUEST['FriendEmail2'];
$waiver_var=$REQUEST['Waiver'];

$insert = "INSERT INTO People1
(FirstName, LastName, Email, HomePhone, Birthyear,
Gender, University, HeardAboutIt, FriendEmail1, FriendEmail2, Waiver, DateEntered)
VALUES
('$firstname_var', '$lastname_var', '$email_var', '$homephone_var', '$birthyear_var',
'$gender_var', '$university_var', '$heardaboutit_var',
'$friendemail1_var', '$friendemail2_var', '$waiver_var', now())";

print("<font face='verdana,arial' size=1><br>\n");
print($insert);
print("<br><br>\n");

mysql_query($insert) or die ("Sorry, there was a problem. Could not add data to the table.");
exit;
}
else{
print($my_form->error . "<br><br>");
}
} // End of 1st If Statement

?>

right to the top of the page, remove all echo or print statements, check the include file also.
then use the header statement to redirect the user after u validate or as required
this should work. if you still have doubts or errors post the edited code and what the error is

reg
kevin

space1

Okay, I did that and I got this error:
Warning: Cannot add header information - headers already sent by (output started at /mnt/web_a/d48/s18/a000ez4b/www/SignUp_1.php:25) in /mnt/web_a/d48/s18/a000ez4b/www/SignUp_1.php on line 57

This is the code that I used with your changes:

<?php
// Check to see if the form has been submitted (by checking the hidden form field $form_complete
if ($_REQUEST['form_complete'])
{
// Include the class
include("./validator-class.php");

// Initiate a new instance of the class
$my_form = new validator;

// Check to see if the form fields have valid data
// Please check the README.txt file for more info...
if ($my_form->validate_fields("FirstName, LastName"))
{
// If we're here, the Form successfully validated, see below
// Now we 1) Insert the Data with SQL statemetn 2) Direct User to another page

// 1) -------SQL Insert Statement-----------------
$username = "u51778201";
$password = "19eed";
$hostname = "mysqlhost";

$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
mysql_select_db("d52778201");

		print("<font face='verdana,arial' size=1><br>\n");
		print($insert);	
		print("<br><br>\n");

//-------Run SQL to MySQL database-----------------
mysql_query($insert) or die ("Sorry, there was a problem. Could not add data to the table.");

// 2) -------* Direct user to another page in Web site -----------------
header("Location: SignUp3.php"); //Just a test page for now

exit;
}
//-------Prints Error Statement if form fails to validate -----------------
else{
print($my_form->error . "<br><br>");
}
} // End of 1st If Statement

<TR>
<td width=90 ><font face="verdana,arial" size=1>First Name <font color=orange>*</font></td>
<td><input type="text" name="FirstName" value="<?php echo $_REQUEST['FirstName']; ?>"></td>
</tr>

<tr>
<td><font face="verdana,arial" size=1>Email <font color=orange>*</font></td>
<td><input type="text" name="Email" value="<?php echo $_REQUEST['Email']; ?>"></td>
</tr>

<tr>
<td><font face="verdana,arial" size=1>How did you hear about<br> Space City Mixer?</font></td>
<td><INPUT TYPE="text" NAME="HeardAboutIt" size=40> <BR> </td>
</tr>

<tr>
<td>
<font face="verdana,arial" size=1>
  Friend's Email #2 <INPUT TYPE="text" NAME="Email_Friend2" size=30></td>
</tr>

</body>
</html>

kevinsequeira

read my post again

i think i know what the problem with the header() that you would get.
if you are using the header("location:whatever_page.php"); to automatically move the user to the next page you cannot have any output to the screen before this statement.
ie you cannot have any html tags, or echo or print statement or even blank lines

you have quite a few print statements before you the header line.
at a glance ...
print("<font face='verdana,arial' size=1><br>\n");
print($insert);
print("<br><br>\n")

there are quite a few before this also, remove the print statements !!!!

reg
kevin

space1

I love you! That did it!
Thank you soo very, very much!!
- Andrea 😃