[SOLVED] sending email once form submitted

[Emzi]

Hey all, I'm back again...

I have a newsletter form that basically someone inputs their email address and it is submitted to the database.

I want then to send an email to the email address to confirm that they've been put on the newsletter, but I have no clue how to do this.

I've been looking on the internet but most of the stuff is for contact forms etc. which doesn't really help me.

Here's my code:

PHP: Select all

<?php require_once('Connections/ukjobsite.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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 tblNEWSLETTER_SIGNUP (signup_id, email_address, date_registered, client_ip, unsubscribed) VALUES (%s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['signup_id'], "int"),
                       GetSQLValueString($_POST['email_address'], "text"),
                       GetSQLValueString($_POST['date_registered'], "date"),
                       GetSQLValueString($_POST['client_ip'], "text"),
                       GetSQLValueString($_POST['unsubscribed'], "int"));
  mysql_select_db($database_ukjobsite, $ukjobsite);
  $Result1 = mysql_query($insertSQL, $ukjobsite) or die(mysql_error());
  $insertGoTo = "newsletter_signup_success.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  
  ob_get_contents();
  ob_end_clean();
  header(sprintf("Location: %s", $insertGoTo));
  exit();
}
?>
<img src="images/grey_small_top.gif" alt="UK Jobs in Recruitment" /><div class="grey_small">
<div class="small_content_holder"><img src="images/newsletter.gif" alt="UK Jobs in Recruitment" /><br />
Submit your email address to sign up to our 
newsletter.<br />
<div class="form_text">
<div class="form_padding"><b>Email:</b></div>
</div>
<div class="form_object">
<div class="form_padding">
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1"><input name="email_address" type="text" class="textfield"/></div>
<input type="submit" class="submit" value="SUBMIT" />  <input type="hidden" name="signup_id" value="" />
  <input type="hidden" name="client_ip" value="<?php echo $_SERVER['REMOTE_ADDR'] ?>" />
  <input type="hidden" name="unsubscribed" value="0" />
  <input type="hidden" name="MM_insert" value="form1" />
</form></div><div class="clear"></div></div></div><img src="images/grey_small_bot.gif" alt="UK Jobs in Recruitment" />

Anyone care to help? Thanks xx

[c010depunkk]

When you insert the email address, just call the mail() function....

[Emzi]

As I've said in my previous post I'm only familiar with PHP, I'm not an expert, so when you say call the mail function it doesn't mean anything to me.

I tried adding this:

PHP: Select all

if (mail ($email_address, test, test, "From: info@ukjobs.com\r\n\r\n"));
{$sent = true;
}else{
$sent = false;
} 

And I tried it in many various ways but to no avail.

Please can you be more clear in your explainations? I understand most people don't want to go "here's the code, this will work" etc. but more of a clue as to where to put something, or how it works etc. will be useful.

Thanks.

[Emzi]

I marked this as solved but it's been opened again?

Anyway, I'll mark it as solved again as I got help from a colleague.

[karinne]

That was me ... hehe... sorry 'about that. There's was a bunch of closed and solved threads and some didn't seem to be solved ... like yours.

[Emzi]

Ahh ok No probs. I should've explained why it was solved