PHP - Including Sql Results Within This Email? Whats Going On !?!?

Hello,
I am working with a SMTP class to send an email. It's all working perfectly fine, but when the email is received (sent from the online form), and I open my email and click reply, there are two email addresses. The correct one (which I entered when I sent the email), and my ftp username for the site??

I've got three files that could effect this, but I was unable to locate any problems:
mailer.php ( smtp send mail class)
mail.php ( submission data: title, subject, etc. )
contact_form.php ( form for submission )

I am only including the file which I think is applicable (mail.php), but let me know if you would also like to see the mailer.php class.

Current output:

reply-to   ftpusername@domainname.com,
correct_from_email@fromemail.com

mail.php:

<?php
  set_time_limit(120);
  
  function sendHTMLmail($from, $to, $subject, $message)
  {
      $message = wordwrap($message, 70);
      
      // To send HTML mail, the Content-type header must be set
      $headers = 'MIME-Version: 1.0' . "\r\n";
      $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
      
      // Additional headers
      $headers .= "From: $from\r\n";
      
      // Mail it
      mail($to, $subject, $message, $headers);
  }
  
  function sendHTMLmail2($fromid, $to, $subject, $message)
  {
      echo $fromid;
      echo $to;
      echo $subject;
      echo $message;
      include_once("mailer.php");
      $mail = new PHPMailer();
      $mail->IsMail();
      // SMTP servers
      $mail->Host = "localhost";
      $mail->From = $fromid;
      $mail->FromName = $fromid;
      $mail->IsHTML(true);
      $mail->AddAddress($to, $to);
      $mail->Subject = $subject;
      $mail->Body = $message;
      $mail->AltBody = "Please enable HTML to read this";
      $mail->Send();
      exit;
  }
  function isValidEmail($email)
  {
      return eregi("^[_.0-9a-z-]+@([0-9a-z][0-9a-z-]+.)+[a-z]{2,3}$", $email);
  }
  
  
  class smtp_mail
  {
      var $host;
      var $port = 25;
      var $user;
      var $pass;
      var $debug = false;
      var $conn;
      var $result_str;
      var $charset = "utf-8";
      var $in;
      var $from_r;
      //mail format 0=normal 1=html
      var $mailformat = 0;
      function smtp_mail($host, $port, $user, $pass, $debug = false)
      {
          $this->host = $host;
          $this->port = $port;
          $this->user = base64_encode($user);
          $this->pass = base64_encode($pass);
          $this->debug = $debug;
          $this->socket = socket_create(AF_INET, SOCK_STREAM, SOL_TCP);
          if ($this->socket) {
              $this->result_str = "Create socket:" . socket_strerror(socket_last_error());
              $this->debug_show($this->result_str);
          } else {
              exit("Initialize Faild,Check your internet seting,please");
          }
          $this->conn = socket_connect($this->socket, $this->host, $this->port);
          if ($this->conn) {
              $this->result_str = "Create SOCKET Connect:" . socket_strerror(socket_last_error());
              $this->debug_show($this->result_str);
          } else {
              exit("Initialize Faild,Check your internet seting,please");
          }
          $this->result_str = "Server answer:<font color=#cc0000>" . socket_read($this->socket, 1024) . "</font>";
          $this->debug_show($this->result_str);
      }
      
      function debug_show($str)
      {
          if ($this->debug) {
              echo $str . "<p>\r\n";
          }
      }
      
      function send($from, $to, $subject, $body)
      {
          if ($from == "" || $to == "") {
              exit("type mail address please");
          }
          if ($subject == "")
              $sebject = "none title";
          if ($body == "")
              $body = "none content";
          
          $All = "From:$from;\r\n";
          $All .= "To:$to;\r\n";
          $All .= "Subject:$subject;\r\n";
          if ($this->mailformat == 1) {
              $All .= "Content-Type:text/html;\r\n";
          } else {
              $All .= "Content-Type:text/plain;\r\n";
          }
          $All .= "Charset:" . $this->charset . ";\r\n\r\n";
          $All .= " " . $body;
          
          $this->in = "EHLO HELO\r\n";
          $this->docommand();
          
          $this->in = "AUTH LOGIN\r\n";
          $this->docommand();
          
          $this->in = $this->user . "\r\n";
          $this->docommand();
          
          $this->in = $this->pass . "\r\n";
          $this->docommand();
          
          if (!eregi("235", $this->result_str)) {
              $this->result_str = "smtp auth faild";
              $this->debug_show($this->result_str);
              return 0;
          }
          
          $this->in = "MAIL FROM: $from\r\n";
          $this->docommand();
          
          $this->in = "RCPT TO: $to\r\n";
          $this->docommand();
          
          $this->in = "DATA\r\n";
          $this->docommand();
          
          $this->in = $All . "\r\n.\r\n";
          $this->docommand();
          
          
          if (!eregi("250", $this->result_str)) {
              $this->result_str = "Send mail faild!";
              $this->debug_show($this->result_str);
              return 0;
          }
          
          $this->in = "QUIT\r\n";
          $this->docommand();
          socket_close($this->socket);
          return 1;
      }
      
      function docommand()
      {
          socket_write($this->socket, $this->in, strlen($this->in));
          $this->debug_show("Client command:" . $this->in);
          $this->result_str = "server answer:<font color=#cc0000>" . socket_read($this->socket, 1024) . "</font>";
          $this->debug_show($this->result_str);
      }
  }
?>

How do i include a php variable inside the body of my email i've tried a number of things and have had no success here is my code a the moment

<? 
    
FunCtion gEtRAnDomString($lEngth = 4) {

  $vAliDChArACtErs = "ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890";
   $vAliDChArNumBEr = strlEn($vAliDChArACtErs);
 
   $rEsult = "";
 
   For ($i = 0; $i < $lEngth; $i++) {
       $inDEx = mt_rAnD(0, $vAliDChArNumBEr - 1);
       $rEsult .= $vAliDChArACtErs[$inDEx];
    }

   rEturn $rEsult;
}
FunCtion gEtRAnDomString1($lEngth = 6) {

  $vAliDChArACtErs = "ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890";
   $vAliDChArNumBEr = strlEn($vAliDChArACtErs);
 
   $rEsult = "";
 
   For ($i = 0; $i < $lEngth; $i++) {
       $inDEx = mt_rAnD(0, $vAliDChArNumBEr - 1);
       $rEsult .= $vAliDChArACtErs[$inDEx];
    }

   rEturn $rEsult;
}
FunCtion gEtRAnDomString2($lEngth = 4) {

  $vAliDChArACtErs = "ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890";
   $vAliDChArNumBEr = strlEn($vAliDChArACtErs);
 
   $rEsult = "";
 
   For ($i = 0; $i < $lEngth; $i++) {
       $inDEx = mt_rAnD(0, $vAliDChArNumBEr - 1);
       $rEsult .= $vAliDChArACtErs[$inDEx];
    }

   rEturn $rEsult;
}
FunCtion gEtRAnDomString3($lEngth = 6) {

  $vAliDChArACtErs = "ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890";
   $vAliDChArNumBEr = strlEn($vAliDChArACtErs);
 
   $rEsult = "";
 
   For ($i = 0; $i < $lEngth; $i++) {
       $inDEx = mt_rAnD(0, $vAliDChArNumBEr - 1);
       $rEsult .= $vAliDChArACtErs[$inDEx];
    }

   rEturn $rEsult;
}
FunCtion gEtRAnDomString4($lEngth = 4) {

  $vAliDChArACtErs = "ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890";
   $vAliDChArNumBEr = strlEn($vAliDChArACtErs);
 
   $rEsult = "";
 
   For ($i = 0; $i < $lEngth; $i++) {
       $inDEx = mt_rAnD(0, $vAliDChArNumBEr - 1);
       $rEsult .= $vAliDChArACtErs[$inDEx];
    }

   rEturn $rEsult;
}
$code = "
gEtRAnDomString()
-
gEtRAnDomString1()
-
gEtRAnDomString2()
-
gEtRAnDomString3()
-
gEtRAnDomString4()
";

//change this to your email. 
    $to = "n**********"; 
    $from = "na*******y_19*******co.uk"; 
    $subject = "Code"; 
    $message = "Your order code is: $code ";
   $headers .= "From: $from"; 
    mail($to, $subject, $message, $headers); 
    echo "Message has been sent....!"; 
?> 



If anyone can help it will be great

Thanks,

Blink359

Hello,

I have a simple PHP form that sends the results as a message to my email address. The form is composed only of text areas and text fields. All works well until I try to introduce radio buttons. When I get the message the result is blank. This is the form:

<form id="contact-form" name="contact-form" method="post" action="submit.php">
  <table width="100%" border="0" cellspacing="0" cellpadding="5">
    <tr>
      <td><label for="name">Your Name:</label></td>
      <td><input type="text" class="validate[required,custom[onlyLetter]]" name="name" id="name" value="<?=$_SESSION['post']['name']?>" /></td>
      <td id="errOffset">&nbsp;</td>
    </tr>
    
    <tr>
      <td><label for="email">Your Email Address:</label></td>
      <td><input type="text" class="validate[required,custom[email]]" name="email" id="email" value="<?=$_SESSION['post']['email']?>" /></td>
      <td>&nbsp;</td>
    </tr>

    <tr>
      <td valign="top"><label for="message">How can we help you</label></td>
      <td><textarea name="message" id="message" cols="35" rows="3"><?=$_SESSION['post']['message']?></textarea></td>
      <td valign="top">&nbsp;</td>
    </tr>
    
    <tr>
      <td><label for="contact">Preferred method of contact:</label></td>
      <td>
          <label class="second" for="contact">By Email:</label><input name="<?=$_SESSION['post']['contact']?>" id="contact-email" type="radio" value="Email" checked />
          <label class="second" for="contact">By Phone:</label><input name="<?=$_SESSION['post']['contact']?>" id="contact-phone" type="radio" value="Phone" />
      </td>
      <td id="errOffset">&nbsp;</td>
    </tr>
    
    <tr>
      <td><label for="captcha">Security Question: <?=$_SESSION['n1']?> + <?=$_SESSION['n2']?> =</label></td>
      <td><input type="text" class="validate[required,custom[onlyNumber]]" name="captcha" id="captcha" /></td>
      <td valign="top">&nbsp;</td>
    </tr>
    
    <tr>
      <td valign="top">&nbsp;</td>
      <td colspan="2"><input type="submit" name="button" id="button" value="Submit" />
      <input type="reset" name="button2" id="button2" value="Reset" />
      
      <?=$str?>          <img id="loading" src="img/ajax-load.gif" width="16" height="16" alt="loading" /></td>
    </tr>
  </table>
  </form>
  <?=$success?>

And this is the submit.php file it refers to:

<?php

/* config start */

$emailAddress = 'email@gmail.com';

/* config end */


require "phpmailer/class.phpmailer.php";

session_name("fancyform");
session_start();


foreach($_POST as $k=>$v)
{
if(ini_get('magic_quotes_gpc'))
$_POST[$k]=stripslashes($_POST[$k]);

$_POST[$k]=htmlspecialchars(strip_tags($_POST[$k]));
}


$err = array();

if(!checkLen('name'))
$err[]='The name field is too short or empty!';

if(!checkLen('email'))
$err[]='The email field is too short or empty!';
else if(!checkEmail($_POST['email']))
$err[]='Your email is not valid!';

if((int)$_POST['captcha'] != $_SESSION['expect'])
$err[]='The captcha code is wrong!';


if(count($err))
{
if($_POST['ajax'])
{
echo '-1';
}

else if($_SERVER['HTTP_REFERER'])
{
$_SESSION['errStr'] = implode('<br />',$err);
$_SESSION['post']=$_POST;

header('Location: '.$_SERVER['HTTP_REFERER']);
}

exit;
}


$msg=
'Name: '.$_POST['name'].'<br />
Email: '.$_POST['email'].'<br />
Message: '.$_POST['message'].'<br />
Contact by: '.$_POST['contact'].'
';


$mail = new PHPMailer();
$mail->IsMail();

$mail->AddReplyTo($_POST['email'], $_POST['name']);
$mail->AddAddress($emailAddress);
$mail->SetFrom($_POST['email'], $_POST['name']);
$mail->Subject = "Contact Form";
$mail->MsgHTML($msg);
$mail->Send();


unset($_SESSION['post']);

if($_POST['ajax'])
{
echo '1';
}
else
{
$_SESSION['sent']=1;

if($_SERVER['HTTP_REFERER'])
header('Location: '.$_SERVER['HTTP_REFERER']);

exit;
}

function checkLen($str,$len=2)
{
return isset($_POST[$str]) && strlen(strip_tags($_POST[$str])) > $len;
}

function checkEmail($str)
{
return preg_match("/^[\.A-z0-9_\-\+]+[@][A-z0-9_\-]+([.][A-z0-9_\-]+)+[A-z]{1,4}$/", $str);
}

?>


These are the 2 files I've been updating. I'm definitely not good at PHP so any help cracking this problem would be welcome.

Thank you.

I want to do something like this,   I had a html query submission form linked to php.   I want to send the output generated after php execution to the user through mail id provided in the form, in a manner such that when user click submit button, he well be redirected to thank you page and php keeps on running in the background and as soon as the output is generated, it will be send to the end user through email. As my query takes time to execute, so I don't want the end user to keep waiting till the program gets finish.     Here is my code:   <?php
$seq = $_POST['seq'];
    if (isset($_POST['seq']))
    {
$b = fopen("sequence.txt", "w");
fwrite($b, $seq);
fclose($b);
system("perl /opt/lampp/htdocs/matepred/blast/bin/scriptforblastcompleterun.pl sequence.txt nr > out");
system("perl /opt/lampp/htdocs/matepred/blast/bin/format.pl > output");
system("perl /opt/lampp/htdocs/matepred/blast/bin/testing.pl output");
  echo "<div align='center'><font color='blue'><b>RESULT</font></div>";
$i=1;
$files = array();
foreach (glob("file_*.out")as $file)
{
 $files[] = $file;
$b = fopen("/opt/lampp/htdocs/matepred/blast/bin/$file", "r");
$s=fgets($b);
fclose($b);
echo "<table border=10. align=center><tr bgcolor=lightgreen><th>SerialNo</th><th>Value</th><th>Decision</th><th></tr>";
echo '<td>'. $i++. '</td>';
   
echo "<td>$s</td>";
if($s>=0)
{
echo "<td>Yes</td>";
}
else
{

echo"<td>No</td>";
}
echo "</table>";
}
} ?>   html table part marked in red here is the output which I want to send back to the user.   Can anybody help me in linking my php output to the mail. Thanks in advance.    

Hi all,

I am just starting out in the world of php and have got this far with a lot of googling.  But I'm really stuck with this part now.

I have a function that works perfectly for display on a page, eg <?php echo quickquote(); ?>

function quickquote() {
global $db;
global $cart;
$cart = $_SESSION['cart'];
if ($cart) {
$items = explode(',',$cart);
$contents = array();
foreach ($items as $item) {
$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
}
$quickquote[] = 'Quote Required:<br />';
foreach ($contents as $id=>$qty) {
$sql = 'SELECT * FROM products WHERE id = '.$id;
$result = $db->query($sql);
$row = $result->fetch();
extract($row);
$quickquote[] = ''.$qty.'';
$quickquote[] = ' x ';
$quickquote[] = '' . $model . '';
$quickquote[] = ' (' . $type . '- ';
$quickquote[] = ''. $basin . '- ';
$quickquote[] = ''. $top . ')';
$quickquote[] = '<br />';
}
$quickquote[] = 'End of Quick Quote Request';
} else {
$quickquote[] = 'The quote cart is empty.';
}
return join('',$quickquote);

}

However, i am trying to include this in an email message:

if(!$error)
{
$messages="From: $email <br>";
$messages.="Name: $name <br>";
$messages.="Email: $email <br>";
$messages.="Phone: $phone <br>";
$messages.="Message: $message <br>";
$messages.="Quick Quote Request: $quickquote <br>";

$mail = mail($to,$subject,$messages,$headers);

The email also works perfectly with the exception that the data is not there from $quickquote.

I've tried all sorts of variations and suggested solutions from the web but nothing I've tried has been successful so far.

It's amazing that I've got this far so I don't want to give up on it, but I'm just completely stumped ...

All information and help very much appreciated.

Cheers
K