Hello
This is my first post here and I am on the learning curve with php (php3 in
particular as it is all my host has) and need help with a multi-page form.
It is a subscription for users and consists of:
1) subscribe.php3
2) confirm.php3
subscribe.php3 is where the user enters data and then click's the "submit"
button. It is a post action and refers to itself. If no errors are present
it includes confirm.php3 which will display user inputs for them to verify
as correct.
If the click the "submit" button on this page it is supposed to write the
inputs to the database. Herein lies the problem. It does not. For some
reason the user inputs from subscribe.php3 do not write to the database but
if I use <?print $we_first?> they display properly on confirm.php3.
If I by-pass the confirmation and just write to the database it works. If I
try to "halt proceedings" for the user to view it the user inputs disappear
into oblivion. It looks as though the form action from subscribe.php3 and
confirm.php3 are conflicting with each other.
I have offered some code snippets below if anyone would be willing to help.
Thanks
Todd
++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++
Here is what I have in subscribe.php3:
++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++
CODE:
<?
if (count($HTTP_POST_VARS) <> 0)
{
//do stuff here to validate data - works ok
}
# Test form if send
if ($err <> true)
{
include("/home/WWW/domain.com/htdocs/confirm.php3");
exit();
}
}
?>
FORM ACTION:
<form action="subscribe.php3" METHOD="POST" ENCTYPE="multipart/form-data">
<input type="submit" value="Submit Subscription">
++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++
Here is what I have in confirm.php3:
++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++
CODE:
<?
if (count($HTTP_POST_VARS) <> 0)
{
# Test form if send
if (isset($confirm)) // If I remove this and the form action it writes
perfectly but no confirmation available
{
/* declare some relevant variables */
$hostname = "db.domain.com";
$username = "bubba";
$password = "1234";
$userstable = "subscribe"; /* MySQL table created to store the data */
$dbName = "client";
/* make connection to database */
mysql_connect($hostname, $username, $password) OR die("Unable to connect to
database");
mysql_select_db("$dbName") or die( "Unable to select database");
$query = "INSERT INTO $userstable
(we_prefix,we_first,we_last,we_add1,we_add2,we_suite,we_city,we_prov,we_post
al,we_phone,we_email,we_commetns,we_iud) VALUES
('$we_prefix','$we_first','$we_last','$fi_add1','$we_add2','$we_suite','$we_
city','$we_prov','$we_postal','$we_phone','$we_email','$we_cleancom',
Null)";
$result = MYSQL_QUERY($query);
/* Close the database connection */
MYSQL_CLOSE();
exit();
}
}
?>
FORM ACTION:
<form action="confirm.php3" METHOD="POST" ENCTYPE="multipart/form-data">
<input type="submit" name="confirm" value="looks good...sign me up!">
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
