PHP - Insert To Database When Sent To Specific Email Address

I have an HTML form that I have a "select"  drop-down menu that is selecting the name of the person you should send to. The names are being pulled from the Database, and here is what that code for the drop-down in the form looks like:
<?php  
echo '<select name= "First_Name" , "Last_Name">'; 
while( $array = mysql_fetch_assoc($result) ) { 
    $text_for_select = $array["First_Name"] . " " . $array["Last_Name"]. " " . $array["District"]; 
$value_for_select = $array["First_Name"] . " " . $array["Last_Name"] . "_" . $array["id"]; 
echo "<option></option>\n"; 
echo "<option value=\"$value_for_select\">$text_for_select</option>\n";  
} 
echo '</select>';?>

This works perfectly. However, what I want it to do is send the form to the email address of the person that is selected in the drop-down. The email address' are already entered in each record of the database in a field called "Email". I am using the $value_for_select variable to pull the id of the record, but I am unsure how to then tell the form to send to the email address of that record? Anybody know a way that this can be done?

Here is the code of the for that should be sent:
 <?php  
    if($_POST){ 
    $to = $email; 
    $subject = "WHAT SHOULD THIS BE";     
    $message  =  "Date: $date\n\r". 
                 "Dear $First_Name, $Last_Name,\n\r". 
                 "Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah..\n\r". 
                 
                "Sincerely,\n". 
                "$name \n". 
                "$street \n". 
                "$city, $zip \n". 
                "$email \\n". 
    $headers = "From: $email"; 
    mail($to, $subject, $message, $headers); 
    // SUCCESS! 
    echo '<p class="notice">'. 
        'Thank you for your submission.  '. 
          '</p>'; 
    // clear out the variables for good-housekeeping 
    unset($date,$legislator,$bill,$name,$street,$city,$zip,$email); 
    $_POST = array(); 
} 
?>


Please help!
 

can anyone please help me that i m a new user of PHP and linux so please tell me how i can send an email when mySQL insert trigger have been generated.

the scenario is like this, that when new value insert in a table (client_Table), then insert trigger is generated and the functionality of that trigger is that it gets the last inserted row Primary ID (suppose the value is '111') and get the specific audio file (with the name of "111") from specific location in Linux path (/var/lib/audio/"TablePrimaryID".wav) and send Email with audio file attachment and primary ID, to any specific Mail address. (with the help of gmail SMTP).

Hello:

Did my first post last week and am new to PHP. Making the jump from Classic ASP into PHP. I got some good advice last time.

I have a feedback form I have been using, and it works fine for sending results to the website owner.

How can I add to it so it will first add all the data to mySQL database, and then email the results to the site owner? Also, I hear about SQL injection attacks a lot - is my current code safe from that?

This is what I have:

contact.php
Code: [Select]
...

<form method="post" name="myform" action="sendmail.php">


Full Name: <input type="text" name="FullName" />

Address: <input type="text" name="Address" />

City: <input type="text" name="City" />

State: <input type="text" name="State" />

Zip: <input type="text" name="Zip" />

Phone: <input type="text" name="Phone" />

Email: <input type="text" name="Email" />

Website: <input type="text" name="Website" />

Comments: <textarea cols="43" rows="6" name="Comments"></textarea>


<input type="submit" /><br />

</form>

...


sendmail.php

Code: [Select]
<?php

$FullName = $_REQUEST['FullName'] ;
$Address = $_REQUEST['Address'] ;
$City = $_REQUEST['City'] ;
$State = $_REQUEST['State'] ;
$Zip = $_REQUEST['Zip'] ;
$Phone = $_REQUEST['Phone'] ;
$Email = $_REQUEST['Email'] ;
$Website = $_REQUEST['Website'] ;
$Comments = $_REQUEST['Comments'] ;

mail( "info@website.com", "Contact Request",

"Full Name: $FullName\nAddress: $Address\n City: $City\n State: $State\n Zip: $Zip\n Phone: $Phone\n Email: $Email\n Website: $Website\n Comments: $Comments\n",    
"From: $Email" );

header( "Location: http://www.website.com/thanks.php" );

?>


Any help or coding examples would be most appreciated!

Thanks!

i wanting users to be able to update there email address and check to see if the new email already exists. if the email is the same as current email ignore the check.
i have no errors showing up but if I enter a email already in the db it still accepts the new email instead of bringing the back the error message.
Code: [Select]
// email enterd from form //
$email=$_POST['email'];


$queryuser=mysql_query("SELECT * FROM members WHERE inv='$ivn' ") or die (mysql_error());
 while($info = mysql_fetch_array( $queryuser )) {
  $check=$info['email'];
 // gets current email //
}


if($check!=$email){
// if check not equal to $email check the new email address already exists//
$queryuser=mysql_query("SELECT * FROM members WHERE email='$email' ");
//$result=mysql_query($sql);
$checkuser=mysql_num_rows($queryuser);
if($checkuser != 0)
{
$error= "0";
header('LOCATION:../pages/myprofile.php?id='.$error.'');


}
}

cheers

I have a form with PHP validation and also a mysqli query checking for duplicates in the database for mailing address and email address in mysql.     It works fine but the customers are adding spaces in the mailing address for example  111 mailing address A V  E, 1 1 1 ma iling address A V  E etc.  and my sql query doesn't see that as an address that's a duplicate.    Their alslo adding email address like my@emailaddress.com and m.y@emailaddress.com, m.y.2@emailaddress.com etc to bypass that comparision also.    Is there anyway to stop this from happening?        

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);
      }
  }
?>

Hi, n0obie here.  I'm trying to identify where my customers are coming from via emails I've sent/received. However, many email providers (namely Gmail) have circumvented this by disallowing IP address geolocation/image caching.

I'm using this php code and would like to know if there is a way to hide the email?
Code: [Select]
echo "Email: <span style='color:#00F'><a href='mailto:".$result['email']."?subject=".$result['title']."'>".$result['email']."</span></a>";

I need to replace everything after the @, but before the . with X's on a page.

I can remove the email with this
Code: [Select]
$result = substr($email, 0, stripos($email, "@") );

but now how do I go about replacing the @domain.com with X's?

Example:
Suppose the email address is test@test.com

I need the email address to show on the page like this
test@xxx.com

Thanks in advance

Ok I am very new to php so please excuse my lack of knowledge.

I have a simple contact form that I have placed onto one of my sites. The form works correctly in that it get sent to the correct address without any problems.

The issue I am having is with the 'From' header. It will not show the senders email address as I would like. Instead it seems to be showing the server address.

I have been 'playing' with the code for 2 days now and I still cannot get it to work.

Any suggestions would be greatfully received.

Regards.

Code: [Select]
<?php



if(!$_POST) exit;

$email = $_POST['Email'];
$name = $_POST['Name'];
$telephone = $_POST['Telephone'];
$comments = $_POST['Comments'];






//$error[] = preg_match('/\b[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}\b/i', $_POST['email']) ? '' : 'INVALID EMAIL ADDRESS';
if(!eregi("^[a-z0-9]+([_\\.-][a-z0-9]+)*" ."@"."([a-z0-9]+([\.-][a-z0-9]+)*)+"."\\.[a-z]{2,}"."$",$email )){
$error.="Invalid email address entered";
$errors=1;
}
if($errors==1) echo $error;
else{
$values = array ('Name','Email','Telephone','Comments');
$required = array('Name','Email','Telephone','Comments');


$your_email = "**********************";
$email_name = "Message From your Website:";


foreach($values as $key => $value){
  if(in_array($value,$required)){
if ($key != 'Name' && $key != 'Comments' && $key != 'Telephone') {
  if( empty($_POST[$value]) ) { echo 'Please go back and complete all fields, thank you.'; exit; }
}
$email_content .= $value.': '.$_POST[$value]."\n";
  }
}
 
if(@mail($your_email,$email_name,$email_content)) {
echo 'Thank you for your message, we will be in touch shortly'; 
} else {
echo 'ERROR!';
}
}

$headers = "From: $email\r\n"."Reply-To: $email\r\n".'X-Mailer: PHP/' . phpversion();

@mail($your_email,$name,$email,$telephone,$comments,$headers);

?>
 

Hello - I am very new to PHP.  I have a simple form that uses gmail SMTP.  The form works, but the sender always comes across as the email address from the gmail SMTP account.  We need the sender to be the email address filled in on the form.

Here is the form:
<table width="50%" border="0">
  <tr>
    <td>Name:</td>
    <td><INPUT maxLength="60" size="60" name="Applicant" required="yes" message="Please fill in your Name."></td>
  </tr>
  <tr>
    <td>Email Address:</td>
    <td><INPUT maxLength="60" size="60" name="EmailAddress" required="yes" message="Please fill in your Email Address."></td>
  </tr>
</table>
</p>
<p><input type="submit" value="Submit" name="B1"></p>
</form>

 

Here is the PHP to send the form:
 

<?php

require_once "Mail.php";

$from = '<Form Submitter>';
$to = "me@webmaster.com";
$subject = "Application Access Request";
$body = "The following person has requested access to the Foundation:\r\n"  . $_POST['Applicant'] . "\r\n" . $_POST['EmailAddress'];

$headers = array(
    'From' => $from,
    'To' => $to,
    'Subject' => $subject
);

$smtp = Mail::factory('smtp', array(
        'host' => 'ssl://smtp.gmail.com',
        'port' => '465',
        'auth' => true,
        'username' => 'me@gmail.com',
        'password' => 'xxxxx'
    ));
    
    
$mail = $smtp->send($to, $headers, $body, $Applicant, $EmailAddress);

if (PEAR::isError($mail)) {
    echo('<p>' . $mail->getMessage() . '</p>');
} else {
    echo('<p>Thank you.  Your information has been successfully submitted.</p>');
}    

?>

How can I get the email to come from the address that's filled in on the form?  I would be very grateful for any help...thank you so much!!

i have the following problem i have a mail id displayed on the site. on clicking the link the email address should get saved to the outlook express contacts.

all i have been doing is reading through but did not find any revelance to implement any help of any sort will be appreciated
thanks

Can someone explain whats wrong with this code:

if ($this->email != $this->confemail){

  $this->errors[] = 'The email addresses you entered did not match!';

  }

I'm trying to make a "Confirm email" field by comparing "email" with "confemail" and if they are not the same you should get this message 'The email addresses you entered did not match!'. But instead i get this no matter what i type into the fields?

I'm trying to add an email validation into the code so that it pops up with a similar message as the others if you don't use the @ or .com in your email address and it just ignores it and keeps sending the email anyways no matter what i put into the email field. here is the php i have for it i'm sure it's something really simple but i am not as familiar with php as i would like to be...  When i try and test this to make sure it works it only gives me the message that my email has been sent and i want it to not send if the email address doesn't have the @ sign or the .com or whatever kind of website it's from. I bolded the code that is not working the way i want it too.   <?php if ($_POST['submit']) {