Multiple Email - Anyone Help....

[kpowning]

I'am sending two emails from this .php page and the problem that I'm having is that there are two emails being sent to [e-mail] for the second email script. The first email that I recieve, has all blank fields in it, the second one has the customers information that he/she has entered. Is there a problem with my script? I would appreciate any help on this.

<?php require_once('Connections/smarthomes.php');?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}


if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "Contact1")) {
  $insertSQL = sprintf("INSERT INTO Contact1 (`Contact By`, `Project Location`, `Project Type`, `Number Of Bedrooms`, `Number Of Bathrooms`, `Square Footage`, `Total Home/Office Automation`, `Lighting/Scene Control`, HVAC, `Whole Home/Office Audio`, `Home Theater`, `Advanced Irrigation`, `Enhanced Security Control`, `Touch-Screen Operation Upgrade`, `Advanced Remote Access`, `First Name`, `Last Name`, Address, City, `State`, Zip, `Email Address`, `Home Phone#`, `Personal Info Authorization`, Comments, `Alternate Phone#`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($HTTP_POST_VARS['ContactBy'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['ProjectLocation'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Typeofproject'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Bedrooms'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['Bathrooms'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['Squarefootage'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['Automation'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Lighting'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['HVAC'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Audio'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Theater'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Irrigation'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Enhanced'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Touch'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Remote'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['FirstName'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['LastName'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Address'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['City'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['State'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Zip'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['Email'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['HomePhone'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Authorization'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Comments'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['AlternatePhone'], "text"));

  mysql_select_db($database_smarthomes, $smarthomes);
  $Result1 = mysql_query($insertSQL, $smarthomes) or die(mysql_error());

  $insertGoTo = "Request/Confirm.php";
  if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mail($Email, "Your Request", "Dear: $FirstName\r\n 
Thank you for submitting your request. Our staff is reviewing your information and will contact you soon.\r\n\r\n\r\n\r\n 
--------------------------------------------------------------------------------------------------------------------------------- 
You have recieved this email by submitting a contact form at: [url]http://www.nevadasmarthomes.com[/url] 
---------------------------------------------------------------------------------------------------------------------------------\r\n", 
"From: [email][e-mail][/email]\r\n".
"Reply-To: [email][e-mail][/email]\r\n". 
"Return-Path: [email][e-mail][/email]\r\n");

mail("[e-mail]", "Submitted Contact for [url]www.Nevadasmarthomes.com[/url]", " 
------------------------------------------------------------------------------------------------------------------------------------ 
The following is the clients personal information, submitted at [url]http://www.nevadasmarthomes.com:[/url] 
------------------------------------------------------------------------------------------------------------------------------------\r\n 
First Name: $FirstName\r\n 
LastName: $LastName\r\n 
Address: $Address\r\n 
City: $City, State: $State, Zip: $Zip\r\n 
Email: $Email\r\n 
Home Phone#: $HomePhone\r\n 
Alternate Phone#: $AlternatePhone\r\n 
Please Contact me by: $ContactBy\r\n 
Project Location: $ProjectLocation\r\n 
Project Type: $Typeofproject\r\n 
My home/office has this many bedrooms: $Bedrooms\r\n 
My home/office has this many Bathrooms: $Bathrooms\r\n 
My home/office is approximately this many square feet: $Squarefootage\r\n 
---------------------------------------I'm Interested in:----------------------------------\r\n\r\n 
Total Home/Office Automation: $Automation\r\n 
Lighting/Scene Control: $Lighting\r\n 
HVAC: $HVAC\r\n 
Whole Home/Office Audio: $Audio\r\n 
Home Theater: $Theater\r\n 
Advanced Irrigation Control: $Irrigation\r\n 
Enhanced Security Control: $Enhanced\r\n 
Touch-Screen Operation Upgrade: $Touch\r\n 
Advanced Remote Access: $Remote\r\n 
------------------------------------------------------------------------------------------------\r\n\r\n 
Authorization of use of personal information: $Authorization\r\n 
Comments: $Comments", 
"From: [email][e-mail][/email]\r\n". 
"Reply-To: [email][e-mail][/email]\r\n". 
"Return-Path: [email][e-mail][/email]\r\n"); 
?> 

[kpowning]

Can anyone please help me on this..... I really need this a.s.a.p. I can't figure it out.

[MeX]

hi kpowning!!

the only thing i can see is that you have forgotten some slashes!!

so you have some rn instead of \r\n!!!

i replaced them and the script worked fine!!

oh ... and you have some html code in the mails ( in the 2nd one in the SUBJECT!!! ) ... but the mails are send as plain text ... does not look nice!! 😉

hope that helps!

ceeyaa.MeX

[kpowning]

I really appreciate your help, but I have no idea why, I do have all the \r\n actually in my script, Weird, it didn't actually show that on my posting. Also, I have in the script for the subject: submitted contact for www.nevadasmarthomes.com. I still get the double emails for the last email script: [e-mail] Is there something I'm missing? And, how can I send a better email, besides plain text?

I appreciate any comments or suggestions...

[Duey]

I know why!

<?
mail($Email, "Your Request", "Dear: $FirstName\r\n 

Thank you for submitting your request. Our staff is reviewing your information and will contact you soon.\r\n\r\n\r\n\r\n 

--------------------------------------------------------------------------------------------------------------------------------- 

You have recieved this email by submitting a contact form at: <a href=\"http://www.nevadasmarthomes.com\" target=\"_blank\">http://www.nevadasmarthomes.com</a> 
---------------------------------------------------------------------------------------------------------------------------------rn", 

"From: [email][e-mail][/email]rn".

"Reply-To: [email][e-mail][/email]rn". 

"Return-Path: [email][e-mail][/email]rn");



mail("[e-mail]", "Submitted Contact for <a href=\"http://www.Nevadasmarthomes.com\" target=\"_blank\">www.Nevadasmarthomes.com</a>", " 

------------------------------------------------------------------------------------------------------------------------------------ 

The following is the clients personal information, submitted at <a href=\"http://www.nevadasmarthomes.com:\" target=\"_blank\">http://www.nevadasmarthomes.com:</a> 
------------------------------------------------------------------------------------------------------------------------------------rn 

First Name: $FirstNamern 

LastName: $LastNamern 

Address: $Addressrn 

City: $City, State: $State, Zip: $Ziprn 

Email: $Emailrn 

Home Phone#: $HomePhone\r\n 

Alternate Phone#: $AlternatePhone\r\n 

Please Contact me by: $ContactByrn 

Project Location: $ProjectLocationrn 

Project Type: $Typeofprojectrn 

My home/office has this many bedrooms: $Bedroomsrn 

My home/office has this many Bathrooms: $Bathroomsrn 

My home/office is approximately this many square feet: $Squarefootagern 

---------------------------------------I'm Interested in:----------------------------------\r\n\r\n 

Total Home/Office Automation: $Automation\r\n 

Lighting/Scene Control: $Lighting\r\n 

HVAC: $HVAC\r\n 

Whole Home/Office Audio: $Audio\r\n 

Home Theater: $Theater\r\n 

Advanced Irrigation Control: $Irrigation\r\n 

Enhanced Security Control: $Enhanced\r\n 

Touch-Screen Operation Upgrade: $Touch\r\n 

Advanced Remote Access: $Remote\r\n 

------------------------------------------------------------------------------------------------\r\n\r\n 

Authorization of use of personal information: $Authorization\r\n 

Comments: $Comments", 

"From: [email][e-mail][/email]\r\n". 

"Reply-To: [email][e-mail][/email]\r\n". 

"Return-Path: [email][e-mail][/email]\r\n"); 

?>

you didnt put \"

[diego25]

Maybe it's your mail server? Try sending to an e-mail that's not on nevadasmarthomes.com. Also, try sending from another server.

Diego

[kpowning]

Actually guys, I have tried this script on another server and everything. I still get two emails, only from the second email script. One has the customers information and the other one doesn't shwo the customers information, just the fields. I did use the \r\n in all of the script. I know it doesn't shoe the "\" in my posting on a few of them, but they are there.

Any other ideas, PLEASE?

[MeX]

ok ... check if you have escaped the " character in the strings!

[MeX]

... and try to send these mails in a siplier form ... not so much text, variables ... just to test if the server and mailaddresses etc. are working!

[kpowning]

I have tried a simplier form, actually just using one email script and it did work just fine. What do you mean by seeing if i have escaped the " part? I'm still pretty new to .php, so please explain as we go if you don't mind. It's almost as if the page is being submitted, then reloaded. The funny thing is, the 1st email script only sends out one copy of it's information, the second email script sends out the one with the information, then a blank-one without the information and it just has the fields.

[MeX]

ok ... what i meant with escaping " was:

// WRONG
$string = "<a href="www.anypage.com">anypage</a>";

// RIGHT
$string = "<a href=\"www.anypage.com\">anypage</a>";

if you assign a string with $string = "blahblah"; you must escape the " in the string!!!

if you assign a string with $string = 'blahblah'; you must escape the ' in the string!!!

and you have something similar to that in the first email:
mail($Email, "Your Request", "Dear: $FirstName\r\n Thank you for ......... at: <a href="http://www.nevadasmarthomes.com" target="_blank">http ........

and there might also be the error!!

ceeyaa.MeX

[kpowning]

Ok, I found the problem, but I still need help trying to correct it. What is happening is when the page is loaded, it is automatically submitting the form (so it's blank), then when the customer fills out the form and hits submit, that's when I'm actually getting the customers information in another email. How can I make the .php page from submitting on load? Any one???? Please help.

Also MeX, thanks for the help man, I did look at what you were saying and I tried that as well, it didn't change anything, but I think the problem is exactly what I just explained..

[Duey]

if(!isset($_POST['Submit']){
//show form.
}
else{
//process form
}

replace "Submit" with the name of the submit button

[kpowning]

I'm sorry man, but I tried that script and it won't work. What do I need to add in that script? For the "Show Form" and the "Process Form" ? I'm really new at this...... The form name is "Contact1" if that helps.