Results after submit form????

[kpowning]

I was wondering if anyone has any ideas to how I can call a result page after submitting a form? Right now I have this in my script:

if ($sendmail == 1) { 
echo "An email was sent to $thisEmail"; 
}else{ 
echo 'No email sent'; 
} 

*No matter what happens, it always shows :"An email was sent to bla_bla_bla..... No matter if an email address was submitted or not.

If the Email address that the user submits is not in my database, it still goes to the next page and states exactly what I said above. It will never say, "No email sent". Why is this? And do I have to use this scipt, or can I have it point to a confirmation page and an error page?

Any information would be greatly appreciated... Thanks, Kyle😕

[kpowning]

Can somebody please help me on this, I would really appreciate it.. I'm a beginner with all of the .php scripting stuff. Help a brother out...😕

[Shadeless]

perhaps u need some more code.. if u can post rest of code people might be able to help u..

[kpowning]

Ok, here is my .php script.

<?php 
require_once('Connections/GspotMembers.php'); 

// if form has been submitted 
if (isset($_POST['Remind_Me'])) { 

// My SQL statement 
$sql = "SELECT UserName,Password,EmailAddress FROM Members WHERE EmailAddress='$EmailAddress'"; 

// Pick my DB 
// Are you sure that Connections/GSpotMembers.php 
// doesn't select your DB? 
mysql_select_db($database_GspotMembers, $GspotMembers); 

// Query the DB 
$query = mysql_query($sql) or die(mysql_error());
// Use the the query in an array called result 
$result= mysql_fetch_array($query); 
$UserName = $result['UserName'];
$Password = $result['Password']; 
$thisEmail = $result['EmailAddress']; 
$message = "So, you forgot your password huh? 
Well sniffing those exhaust fumes don't help much,
but I think we can help you get back on the trail..

Here is the information that you requested!!!
Your UserName is: $UserName
Your password is: $Password
To Login, please click here: [url]http://www.gspotracing.com/Login.php[/url]"; 
$sendmail = mail("$thisEmail","G-Spot Racing Member Information.","$message","From:[e-mail]\n"); 

if ($sendmail == 1) { 
echo "An email was sent to $thisEmail"; 
}else{ 
echo 'No email sent'; 
} 
?>
<?php
} else { 
?>

[barand]

mail() returns a boolean result. What happens if you use

if (mail (......)) {
echo "Mail sent"
} else {
echo "Not sent"
}

[kpowning]

I receive this error:
Parse error: parse error, unexpected '.', expecting ')' in /webapp/vhosts/[e-mail]/TMPb4ba57pas.php on line 66

Thanks for your help on this. Is there something I need to change to make this work?

[barand]

I didn't mean it literally. I was suggesting you place your mail function in the if statement.

if (mail("$thisEmail","G-Spot Racing Member Information.","$message","From:[e-mail]\n") ) { 
echo "An email was sent to $thisEmail"; 
}else{ 
echo 'No email sent'; 
} 

[kpowning]

Still no matter what I type in as an email address. I sill get "an email was sent to: it is left blank. Why is this?

It won't look in the database to verify he email address. And it won't post the script "No email was sent".

Thanks,
Kyle

[barand]

I've just noticed that the variable holding the email address is inside quotes, as is $message.

I'm experiencing a strong sense of deja vu here.

[kpowning]

OK, I tried to get rid of the "" on the $message & email address. I still get the same thing. nothing has changed yet...

[barand]

After the line

$result= mysql_fetch_array($query);

put

foreach($result as $k => $v) {echo "$k = $v<br>";}

This should confirm what values you have in the result fields.

[wilsonodk]

Kyle,

The reason that is occuring is that mail() returns true if PHP believes that it has successful sent the email, unfortunately, it is not smart enough to know whether or not the email is correct. It simply knows that "Yes, PHP successfully sent this email information to the SMTP daemon."

You'll need some other code to determine email addresses.

Barand,

There is no flaw using the double quotes, in fact it is a good habit to get into. If you want to sent an email to multiple To: addresses you could do this:

// multiple To:
mail("$recipient1, $recipient2, $recipient3","$subject","$message $companyinfo","$header1");
// without the double quotes
$recipient = $recipient1 . ' ,' . recipient2 . ' ,' . $recipient3;
// i have to have those commas in there
// and most DB aren't going to return them
// i probably could add them earlier
$message = $msg . $companyinfo;
mail($recipient, $subject, $message, $header);

The bottom line is that the double quotes don't hurt, and they might help, and they make sure that the $variable is a string.

[kpowning]

Hey man, long time no hear huh? Anyways, is there anyway to validate the EmailAddress field so it checks the email addresses in the registered database? And if there Email is not registered with my database, it will open an "sorry your email address is not is our database" script?

Thanks,
Kyle

[wilsonodk]

Kyle,

Work has gotten the better of me.
In your $message variable notice the \",
You'll need those to escape any double quotes that are used in the HTML inside long strings

<?php 
require_once('Connections/GspotMembers.php'); 

// if form has been submitted 
if (isset($_POST['Remind_Me'])) { 

// My SQL statement 
$sql = "SELECT UserName,Password,EmailAddress FROM Members WHERE EmailAddress='$EmailAddress'"; 

// Pick my DB 
// Are you sure that Connections/GSpotMembers.php 
// doesn't select your DB? 
mysql_select_db($database_GspotMembers, $GspotMembers); 

// Query the DB 
$query = mysql_query($sql) or die(mysql_error());
// Use the the query in an array called result 
$result= mysql_fetch_array($query); 
$UserName = $result['UserName'];
$Password = $result['Password']; 
$thisEmail = $result['EmailAddress']; 
$message = "So, you forgot your password huh? 
Well sniffing those exhaust fumes don't help much,
but I think we can help you get back on the trail..

Here is the information that you requested!!!
Your UserName is: $UserName
Your password is: $Password
To Login, please click here: <a href=\"http://www.gspotracing.com/Login.php\">http://www.gspotracing.com/Login.php</a>"; 

if (mysql_num_rows($query) > 0) {
// An email address was found that matched the DB
$sendmail = mail("$thisEmail","G-Spot Racing Member Information.","$message","From:[e-mail]\n"); 
echo = "An email was sent to $thisEmail. Thanks, see you soon!";
} else {
// No email was found
echo = "Sorry. Your Username did not return a Email Address. Are you sure you are a member?";
// You could add a link that goes to the Sign up page if you like
}

?>
<?php
} else { 
?>

A little info,
[FONT=courier new][man]mysql_num_rows/man[/FONT] returns a number that indictates the number of rows that a SELECT query affected. In this case it should be only one row. It is very useful when doing loops through a DB return.

If you want the number of rows that were changed by an INSERT, DELETE, or UPDATE query, use [font=courier new][man]mysql_affected_rows/man[/font].

HTH

[kpowning]

Ok, I tried that script and i got an error:

Parse error: parse error, unexpected '=', expecting ',' or ';' in /webapp/vhosts/[e-mail]/TMPeu80h5884q.php on line 69

Line 69=

echo = "An email was sent to $thisEmail. Thanks, see you soon!";

ANY IDEAS? I know man, work always gets the best of us. I appreciate you helping me on this again. I can't tell you enough.

Thanks,
Kyle

[wilsonodk]

:eek:

delete the equals ("=") sign

echo "An email was sent to $thisEmail. Thanks, see you soon!";

Damn those pesky mistypes! 😃

[kpowning]

😃 Ya buddy.... It finally works.
Thanks for all of your help man I really, really, appreciate it. Take care and I know I'll yell at ya if I get stuck again..

Hope that's ok.

Thanks,
Kyle