Accepting User Info on 2 Separate Pages

nanovation

Hi All,
I've just spent the last 2 days trying to figure out how to collect a visitors email address on my homepage and their contact info on the second page in the same table of MySQL database.

Here's the simple version of the code I've been working on:

Page 1 Code:

<form name="test" action="page2.php" method="POST">
Enter your email address: <input type="text" name="email" />
<input type="submit" />
</form>

Page 2 Code:

Welcome <?php echo $_POST["email"]; ?>.<br />

<form action="page3.php" method="POST">
Enter your name: <input type="text" name="name" />
<input type="submit" />
</form>

Page 3 Code:

<?php

$DBhost = "mysql15.secureserver.net";
$DBuser = "nanovation";
$DBpass = "Red1";
$DBName = "nanovation";
$table = "visitors";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db("$DBName") or die("Unable to select database $DBName");

$sqlquery = "INSERT INTO $table VALUES('$email','$name')";

$results = mysql_query($sqlquery);

mysql_close();
?>

Result:
Neither the email address nor name are collected into the table. Only when I ask for the visitors email and name on the same page, do they both get entered into the database. :bemused:

Any help would be appreciated.
Sincerely,
Nanovation

mrhappiness

page 2

Welcome <?php echo $_POST["email"]; ?>.<br />

<form action="page3.php" method="POST">
<input type="hidden" name="email" value="<?php echo $_POST["email"]; ?>" />
Enter your name: <input type="text" name="name" />
<input type="submit" />
</form>

thorpe

on page 2, you'll need to add a hidden filed so you can pass the email address to page 3.

<form action="page3.php" method="POST">
<input type="hidden" value="<?php echo $_POST['email'] ?>"/>
Enter your name: <input type="text" name="name" />
<input type="submit" />
</form>

then, you also need to collect your values from the form.

$name = $_POST['name'];
$email = $_POST['email'];
"INSERT INTO $table VALUES('$email','$name')"

nanovation

Awesome!!! Thanks guys!

For over communication purposes, so others can learn from your advice, here's the complete code I used for all 3 pages:

Page 1 Code:
<html><body>
<form name="test" action="page2.php" method="POST">
Enter your email address: <input type="text" name="email" />
<input type="submit" />
</form>
</body></html>

Page 2 Code:
<html><body>
Welcome <?php echo $POST["email"]; ?>.<br />
<form action="page3.php" method="POST">
<input type="hidden" name="email" value="<?php echo $POST["email"]; ?>" />
Enter your name: <input type="text" name="name" />
<input type="submit" />
</form>
</body></html>

Page 3 Code:
<?php
$DBhost = "mysql15.secureserver.net";
$DBuser = "nanovation";
$DBpass = "Red1";
$DBName = "nanovation";
$table = "visitors";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db("$DBName") or die("Unable to select database $DBName");

$email = $POST['email'];
$name = $POST['name'];
$sqlquery = "INSERT INTO $table
VALUES('$email','$name')";

$results = mysql_query($sqlquery);

mysql_close();
?>

nanovation

For simplicty sake, does anyone know how to combine all 3 pages onto one?

Best regards,
Nanovation

kburger

There are lots of different ways it could be done, but here's one method. Use a switch statement. Example:

<html><body>
<?
switch ($action) {
case "entername":
	// do your 'Enter Your Name' form stuff
	?>
	Welcome <? echo $_POST['email']; ?>.<br />
	<form action="" method="POST">
	<input type="hidden" name="email" value="<? echo $_POST['email']; ?>" />
	Enter your name: <input type="text" name="name" />
	<input type="hidden" name="action" value="insertintodb" />
	<input type="submit" />
	</form> 
	<?
	break;
case "insertintodb":
	// do your db insertion stuff
	$DBhost = "mysql15.secureserver.net";
	$DBuser = "nanovation";
	$DBpass = "Red1";
	$DBName = "nanovation";
	$table = "visitors";
	mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db("$DBName") or die("Unable to select database $DBName");

$email = $_POST['email'];
$name = $_POST['name'];
$sqlquery = "INSERT INTO $table
VALUES('$email','$name')";

$results = mysql_query($sqlquery);

mysql_close();
// at this point you'll probably want to do something
break;
default:
	// do your 'Enter Your Email' form stuff
	?>
	<form name="test" action="" method="POST">
	Enter your email address: <input type="text" name="email" />
	<input type="hidden" name="action" value="entername" />
	<input type="submit" />
	</form>
	<?
}
?>
</body></html>