I wouldn't use header() in this case, unless you plan to create an ungodly
looking URL to pass with it.. All you really need to do is point the form
to a PHP script that validates the information. Then at the end of that
script either include() the form hander if it's valid, or print an error
message if it's not valid. It would be this simple..
<form method="post" action="validate.php">
<input type="text" name="email">
$query = "SELECT * FROM mytable WHERE email = '$email'";
$result = mysql_query($query, $db);
$num = mysql_num_rows($result);
if ($num > 0)
echo "Email already exists.";
A more appropriate place to use header() would be in the "else" statement to
return to the original .html page. You could even brand the .html page with
the error message by placing a unique comment such as <!-ERROR-> within the
html, then do something like...
$file = fread($fp, 10000);
$file = str_replace("<!-ERROR->", $error, $file);
And that's about as sophisticated as you would ever need to get in this
----- Original Message -----
From: "Jim lucas" <[EMAIL PROTECTED]>
To: "Don" <[EMAIL PROTECTED]>; "php list" <[EMAIL PROTECTED]>
Sent: Friday, May 31, 2002 2:56 PM
Subject: Re: [PHP] Running a script to check something before submitting a
form. Can this be done?
> onClick() call in the submit button. but the bad thing is, you wont be
> able to check this with the mysql db, unless you load the entire field set
> into the current page.
> my suggestion would be to send the form to one single page no-matter what.
> do the validating and then if the email address isn't there, redirect with
> the php header() function to the custom page that you are talking about.
> Jim lucas
> ----- Original Message -----
> From: "Don" <[EMAIL PROTECTED]>
> To: "php list" <[EMAIL PROTECTED]>
> Sent: Friday, May 31, 2002 1:46 PM
> Subject: [PHP] Running a script to check something before submitting a
> Can this be done?
> I think I need to use PHP here which is why I'm posting to this ng. I
> a form that upon the user pressing submit, calls a PHP form handler. What
> I'd like to do is upon the user pressing submit, I need to validate an
> field within a MySQL database and only if it does NOT exist, call the form
> handler. If it exists, I'll juets return a custom page and NOT call the
> If PHP is not involved, I apologize for the post.
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php