Page 1 of 1

Email Not Sending (Quick Problem )

Posted: Fri Mar 21, 2008 3:32 pm
by jimmyp3016
Hey Guys,

My script runs perfect and inserts my form data into the database but it does not email the user.

Can you look at the top part of my script and tell me why?

Is it because its not grabbing the persons address?

I think there is a problem with $to_address = $_GET['email']; email is the value of that field on this same page.

Code: Select all

 
 
<?php
include 'clientmessage.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 = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
 
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO Customers (PlayLevel, Source, SourceDes, WithFriend, School, Sponsor, Asst, HCoach, CoachName, CoachDOB, CoachSSN, ShirtSize, CoachAddr, CoachPh, CoachEmail, Bcheck, Agreement, ModelRel, Name, ChildName, ChildShirt, addr1, addr2, City, `State`, Zip, Phone1, Phone2, email1, email2, Age, Birthday, Location) 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, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['PlayLevel'], "text"),
                       GetSQLValueString($_POST['Source'], "text"),
                       GetSQLValueString($_POST['SourceDes'], "text"),
                       GetSQLValueString($_POST['WithFriend'], "text"),
                       GetSQLValueString($_POST['School'], "text"),
                       GetSQLValueString(isset($_POST['Sponsor']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Asst']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['HCoach']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString($_POST['CoachName'], "text"),
                       GetSQLValueString($_POST['CoachDOB'], "date"),
                       GetSQLValueString($_POST['CoachSSN'], "text"),
                       GetSQLValueString($_POST['ShirtSize'], "text"),
                       GetSQLValueString($_POST['CoachAddr'], "text"),
                       GetSQLValueString($_POST['CoachPh'], "text"),
                       GetSQLValueString($_POST['CoachEmail'], "text"),
                       GetSQLValueString(isset($_POST['Bcheck']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['Agreement']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['ModelRel']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString($_POST['Name'], "text"),
                       GetSQLValueString($_POST['ChildName'], "text"),
                       GetSQLValueString($_POST['ChildShirt'], "text"),
                       GetSQLValueString($_POST['addr1'], "text"),
                       GetSQLValueString($_POST['addr2'], "text"),
                       GetSQLValueString($_POST['City'], "text"),
                       GetSQLValueString($_POST['State'], "text"),
                       GetSQLValueString($_POST['Zip'], "text"),
                       GetSQLValueString($_POST['Phone1'], "text"),
                       GetSQLValueString($_POST['Phone2'], "text"),
                       GetSQLValueString($_POST['email1'], "text"),
                       GetSQLValueString($_POST['email2'], "text"),
                       GetSQLValueString($_POST['Age'], "text"),
                       GetSQLValueString($_POST['Birthday'], "text"),
                       GetSQLValueString($_POST['Location'], "text"));
 
  mysql_select_db($database_custs, $custs);
  $Result1 = mysql_query($insertSQL, $custs) or die(mysql_error());
  
 $to_address        =   $_GET['email'];
 mail ("$to_address", "$subject", "$mail_body", "From: info@mywebsite.com");
  
  $insertGoTo = "/SignupComplete.htm";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
?>

Re: Email Not Sending (Quick Problem )

Posted: Fri Mar 21, 2008 6:05 pm
by kishanprasad
are You submitting the form through POST methos and GET method if POST mns u have to give $_POST[email] and where you are takinng the values for $subject vand $mail_body

if u have still doubt echo onec that forn element (i.e $_GET['email'] or $_post['email']