PHP - Sending To Different Email Addresses From A Database

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!
 

Hi Everyone!  Thanks in advance for taking the time to review my post.  I am pretty new to PHP so please excuse my ignorance.

I am working a project for myself.  I want to be able to send out newsletters to my customers and sponsors.    I have written the code and here it is:

<?php
$subject = $_POST['subject'];
$message = $_POST['message'];
$email = "bubba@bubba.com";
$headers = "From: $email";
$email_list = file("elist.txt");
$total_emails = count($email_list);
for ($counter=0; $counter<$total_emails; $counter++) {
   $email_list[$counter] = trim($email_list[$counter]);
   }
$to = implode(",",$email_list);


if ( mail($to,$subject,$message,$headers) ) {
   echo "The email has been sent!";
   } else {
   echo "The email has failed!";
   }
?>

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

In my elist.txt file - I have two fields.   Name and email.

Bubba|bubba@bubba.com
Oohay|oohay@yahoo.com

If i leave the names out of this file, the email script works great!

I want to leave the names in there and reference them in my email that I am sending out to be more personal. 

Can this be done and can you help?

Thanks!
Mike

I want to send confirmation email to 2 different email boxes.
this is the code sending to one box:

{
$this->load->library('email');
//$config['mailtype'] = 'html';
//$this->email->initialize($config);

$this->email->from('no-reply@mymail.com 'Site team');
$this->email->to($em);

$this->email->subject('Welcome');
$msg = 'You have registered';

$this->email->message($msg);

$this->email->send();
}
thanks
and what should be the code sending same email to one more email box (example: mymail@gmail. com)

Im having a little trouble with the script below.  I get my three sql values returned fine, without a problem.
The problem is that Im not sending any emails with it.

Wether this is a problem with my syntax, headers, code ??? i dont know.
Please go easy on my scripts, im a learning newbie.

<html><body>
<?php
mysql_connect("***","***","***"); 
mysql_select_db("***") or die("Unable to select database"); 

$code = $_GET['postcode'];
$message = $_GET['message'];
$shortcode = substr($code,0,2);
$subject = "subject here";
$result = mysql_query("SELECT email FROM treesurgeons WHERE postcode like '%" . $shortcode . "%' ORDER BY companyName LIMIT 3")
or die(mysql_error());  
echo "<h2>Business Names:</h2>";                     
while($row = mysql_fetch_assoc($result)) 
{$message .= "\r\n". $row['email'] ;}
{$value = $row['email'].',';}
rtrim($row, ',');
$i = 0;
{$i++; switch($i)
{case 0:$value1 = $row['email']; break;
 case 1:$value2 =$row['email']; break;
 case 2:$value3 =$row['email']; break; }}
$to = "$value1, $value2, $value3";
echo nl2br ($message); 
$headers = 'From: me@me.com' . "\r\n" .
    'Reply-To: me@me.com' . "\r\n" .
    'X-Mailer: PHP/' . phpversion();
mail( "$to", "$subject","$message", "$headers");
echo "<br>" . "Thank you for using our mail form.";
?></body></html>

Hi there,

I have a newsletter sign up form which just puts the data (id and email) into a mysql table.

To stop people hacking the site, is there a way to make sure the only thing being submitted in the input is an email address?

Here's my current form and submit php:

Code: [Select]
<?php

$mailer = $_GET['mailer'];

if ($mailer == 'added') {

$email=$_POST['email'];

if($email == '') {
echo '<div class="daily_not_submitted"><span style="padding-right:6px;"><img src="https://store.huhmagazine.co.uk/images/cross.jpg"></span>Please fill in all the fields.</div>';
}else {

$sql="INSERT INTO `dailymailer` (`email`) VALUES ('$email');";
$result=mysql_query($sql) or die(mysql_error());

if($result){
echo "<div class='daily_submitted'><span style='padding-right:6px;'><img src='http://www.huhmagazine.co.uk/images/uploaded/checkboxtick.jpg'></span>Thank you.</div>";
}
else {
echo "Error\n";
}
}
}
?>

<div id="sidebarnewsletter">
<form name="mailinglist" method="post" action="?mailer=added">
<input type="text" name="email" class="sidebarnewsletter" placeholder="Enter Your Email Address" />
<input type="submit" class="sidebarnewsletter_button" value="Sign Up">
</form>
<div class="clear"></div>
</div>

goodguybadguy.net

they can tell when you enter an email address that hasnt been registered yet. how the hell are they doing this? does gmail or  yahoo have some sort of database they allow access to for this?

I'm trying to make a script that will search the source code of a given url and strip every email address that pops up.

I already have a script that will crawl around, jumping from webpage to webpage... i just need to figure out how to strip the contents... any suggestions?

From our website we are connecting to GMAIL to send our emails through SMTP. For some reason it is not sending the emails to the CC or BCC email address event though GMAIL shows it was included in the email. Am I missing something in the below code?

Code: [Select]
$currentTime = time();

$emailTo = "redbrad0@domain.com";
$emailCC = "brad@domain.com";
$emailBCC = "events@domain.com";
$emailSubject = "TEST Email at (" . $currentTime . ")";
$emailBody = "This is the body of the email";

$headers = array();
if (!empty($emailTo))
$headers['TO'] = $emailTo;
if (!empty($emailCC))
$headers['CC'] = $emailCC;
if (!empty($emailBCC))
$headers['BCC'] = $emailBCC;
if (!empty($emailSubject))
$headers['Subject'] = $emailSubject;
$headers['From'] = "events@domain.com";

$mime = new Mail_mime("\n");
$mime->setTXTBody($emailBody);
$body = $mime->get();
$headers = $mime->headers($headers);

$mail = Mail::factory('smtp',
   array ('host' => 'ssl://smtp.gmail.com',
     'auth' => true,
     'port' => 465,
     'username' => 'events@domain.com',
     'password' => 'thepasswordhere'));

try {
  $result = $mail->send($emailTo, $headers, $emailBody);
} catch (TixException $ex) {     
  echo "<font color=red>Error:" . $ex->getCode() . "</font><br>";
}

echo "Emailed at (" . $currentTime . ")<br>";
die;

Code: [Select]
<?php
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$dropdown = $_POST['dropdown'];
$formcontent=" From: $firstname \n Surname: $lastname \n Email: $email \n Dropdown: $dropdown";
$recipient = "martin@sittingspiritually.co.uk, siobhan@sittingspiritually.co.uk";
$subject = "Newsletter Sign Up";
$mailheader = "From: $email \r\n";
mail($recipient, $subject, $formcontent, $mailheader) or die("Error!");
if ( mail($recipient, $subject, $formcontent, $mailheader) ){
header('Location: http://www.sittingspiritually.co.uk/thankyou.php');
} else {
die ("error");
}
?>

I have recently created a small snippet of php code for posting mail and it's sweet apart from 1 thing.

I have two email addresses in the recipient section. It only sends to the last name in the list.

Is this because i have written recipient? Should it be recipients?

I need this mail to be delivered to both of the email addresses.

I'm sure it's simple for someone with expert knowledge.

Thanks in advance for any help.

Hi there everyone!

I'm trying my best to Google my way through this issue, but have run into an issue I can't out-Google. I'm trying to write a script that is receiving an email, breaking it apart into it's various components and then storing into a database. I would like to sto

from name
from email
to name
to email
subject
headers
body

Here's what I've cobbled together from various tutorials and demo's:

$fd = fopen("php://stdin", "r");
$email_content = "";
while (!feof($fd)) {
    $email_content .= fread($fd, 1024);
}
fclose($fd);

//split the string into array of strings, each of the string represents a single line, received
$lines = explode("\n", $email_content);
 
// initialize variable which will assigned later on
$from = "";
$subject = "";
$headers = "";
$message = "";
$is_header= true;
 
//loop through each line
for ($i=0; $i < count($lines); $i++) {
    if ($is_header) {
        // hear information. instead of main message body, all other information are here.
        $headers .= $lines[$i]."\n";
 
        // Split out the To portion
        if (preg_match("/^To: (.*)/", $lines[$i], $matches)) {
            $to = $matches[1];
        }
        $toregexp = '/To:\s*(([^\<]*?) <)?<?(.+?)>?\s*\n/i';
        if(preg_match($toregexp, $email_content, $to_dissection)) {
            $toname = $to_dissection[2];
            $toemail = $to_dissection[3];
        }
        // Split out the subject portion
        if (preg_match("/^Subject: (.*)/", $lines[$i], $matches)) {
            $subject = $matches[1];
        }
        //Split out the sender information portion
        if (preg_match("/^From: (.*)/", $lines[$i], $matches)) {
            $from = $matches[1];
        }
        $fromregexp = '/From:\s*(([^\<]*?) <)?<?(.+?)>?\s*\n/i';
        if(preg_match($fromregexp, $email_content, $from_dissection)) {
            $fromname = $from_dissection[2];
            $fromemail = $from_dissection[3];
        }
    } else {
        // content/main message body information
        $message .= $lines[$i]."\n";
    }
    if (trim($lines[$i])=="") {
        // empty line, header section has ended
        $is_header = false;
    }
}

My issues are many. I've got from and to names that don't reflect the true data,
the from address will be the original sender and not the most recent sender if
it's forwarded and finally, the body is showing up empty. Clearly, I'm not handling this properly. With all the trouble-ticket like systems out there, there has to be a fairly bulletproof method of handling this, doesn't there?  I'm thinking I've gone about this totally the wrong way.

Any help would be greatly appreciated!

 

Hello, any help would be greatly appreciated. I have two dropdowns with 2 options in each. Customer picks one option from each dropdown and the form gets emailed to addresses from the two selections. The code below gives and error.

My form:
<form method="POST" action="quote.php" onsubmit="return checkform(this)">
<input type="hidden" name="agent" value="recipient_1,recipient_2">
<input type="hidden" name="office" value="recipient_3,recipient_4">
<select name="agent" id="agent">
<option value="recipient_1">Agent1 </option>
<option value="recipient_2">Agent2 </option>
</select>
<select name="office" id="office">
<option value="recipient_3">Location1  </option>
<option value="recipient_4">Location2 </option>
</select>
<input type="submit" name="submit" value="Submit">
</form>

quote.php is below:
$recipients = array(

'recipient_1' => 'email_1@yahoo.com',
'recipient_2' => 'email_2@yahoo.com',
'recipient_3' => 'email_3@yahoo.com',
'recipient_4' => 'email_4@yahoo.com',
);
$exploded_recipients = explode(",",$_REQUEST['agent']);
foreach($exploded_recipients as $value)
{
$my_email = $recipients[$value];
$success = mail($my_email, $Subject, $Body, "From: <$EmailFrom>");
}


Thanks in advance

Everything about the email is sending except the message text does anyone know what the issue could be?

here is the block of code that sends the email
Thanks in advance
Code: [Select]
$image = "http://www.visualrealityink.com/dev/clients/arzan/snell_form/images/email.png";
echo "got to process form";
$target_path = "upload/";                   
$path = $target_path = $target_path . basename( $_FILES['file']['name']);                 
$boundary = '-----=' . md5( uniqid ( rand() ) );

$message .= "Content-Type: application/msword; name=\"my attachment\"\n";
$message .= "Content-Transfer-Encoding: base64\n";
$message .= "Content-Disposition: attachment; filename=\"$path\"\n\n";


echo $path;
$fp = fopen($path, 'r');
do //we loop until there is no data left
{
$data = fread($fp, 8192);
if (strlen($data) == 0) break;
$content .= $data;
  } while (true);
$content_encode = chunk_split(base64_encode($content));
$message .= $content_encode . "\n";
$message .= "--" . $boundary . "\n";
$message .= $image . "<br />" . $_POST['name'] . "submitted a resume on our website. Please review the applications and contact the candidate if their resume is a fit for any open opportunities with the company. <br><br> Thank you. <br><br> SEI Team";
$headers  = "From: \"Me\"<me@example.com>\n";
$headers .= "MIME-Version: 1.0\n";
$headers .= "Content-Type: multipart/mixed; boundary=\"$boundary\"";
mail('george@visualrealityink.com', 'Email with attachment from PHP', $headers, $message);

Hi the user fill details and then the email his sent to me the only problem is that the emails keeps going to my spam, can someone help me out please I looked already php website and email format looks the same.
This is the link to my form.
http://www.people.eurico.co.uk/

here my form script
Code: [Select]
<?php

// Set email variables
$email_to = 'xxxxx@xxxxxxx.co.uk';
$email_subject = 'Call back form';

// Set required fields
$required_fields = array('fullname','email','telephone','comment');

// set error messages
$error_messages = array(
'fullname' => 'Please enter a Name to proceed.',
'email' => 'Please enter a valid Email.',
'telephone' => 'Please telephone.',
'comment' => 'Please enter your Message to continue.' 
);

// Set form status
$form_complete = FALSE;

// configure validation array
$validation = array();

// check form submittal
if(!empty($_POST)) {
// Sanitise POST array
foreach($_POST as $key => $value) $_POST[$key] = remove_email_injection(trim($value));

// Loop into required fields and make sure they match our needs
foreach($required_fields as $field) {
// the field has been submitted?
if(!array_key_exists($field, $_POST)) array_push($validation, $field);

// check there is information in the field?
if($_POST[$field] == '') array_push($validation, $field);

// validate the email address supplied
if($field == 'email') if(!validate_email_address($_POST[$field])) array_push($validation, $field);
}

// basic validation result
if(count($validation) == 0) {
// Prepare our content string
$email_content = 'peoplesmartlearning.co.uk: ' . "\n\n";

// simple email content
foreach($_POST as $key => $value) {
if($key != 'submit') $email_content .= $key . ': ' . $value . "\n";
}

// if validation passed ok then send the email
mail($email_to, $email_subject, $email_content);

// Update form switch
$form_complete = TRUE;
}
}

function validate_email_address($email = FALSE) {
return (preg_match('/^[^@\s]+@([-a-z0-9]+\.)+[a-z]{2,}$/i', $email))? TRUE : FALSE;
}

function remove_email_injection($field = FALSE) {
   return (str_ireplace(array("\r", "\n", "%0a", "%0d", "Content-Type:", "bcc:","to:","cc:"), '', $field));
}

?>
The HTML
Code: [Select]
<div class="call_us_form">
        <p class="title">WE'LL CALL YOU BACK</p>
<?php if($form_complete === FALSE): ?>
<form class="contact_form" id="fm-form" method="post" action="index.php" >
                <fieldset>
                    <div class="fm-req">
                        <label for="fm-firstname">Name</label>
 <input type="text" id="fullname" class="detail" name="fullname" value="<?php echo isset($_POST['fullname'])? $_POST['fullname'] : ''; ?>" />
<?php if(in_array('fullname', $validation)): ?><script type="text/javascript">alert("Please enter a Name"); history.back();</script><?php endif; ?>
                    </div>
               
                    <div class="fm-req">
                    <label for="fm-firstname">Email</label>
                 <input type="text" id="email" class="detail" name="email" value="
<?php echo isset($_POST['email'])? $_POST['email'] : ''; ?>" />
<?php if(in_array('email', $validation)): ?><script type="text/javascript">alert("Please enter a valid Email Address"); history.back();</script><?php endif; ?>
                    </div>
                   
<div class="fm-req">
                    <label for="fm-firstname">Number</label>
 <input type="text" id="telephone" class="detail" name="telephone" value="<?php echo isset($_POST['telephone'])? $_POST['telephone'] : ''; ?>" />
  <?php if(in_array('telephone', $validation)): ?><script type="text/javascript">alert("Please enter telephone number"); history.back();</script><?php endif; ?>
                    </div>

                    <div class="fm-req">
                        <label for="fm-lastname">Message</label>
<textarea cols="40" rows="5" id="comment" name="comment" class="mess"><?php echo isset($_POST['comment'])? $_POST['comment'] : ''; ?></textarea>
<?php if(in_array('comment', $validation)): ?><script type="text/javascript">alert("Please enter your message"); history.back();</script><?php endif; ?>
                    </div>
                <input class="submit_button" type="submit" value="Call us" />
                </fieldset>
            </form>
<?php else: ?>
<p>Thank you for your Message!</p>
<p>We will get back to you as soon as we can</p>

<script type="text/javascript">
setTimeout ('ourRedirect()', 5000)
function ourRedirect () {
location.href='index.php'
}
</script>
<?php endif; ?>

I need a map which locates all the stores addresses(Less than 10). Those address must be retreived from the database. But the database don't contain any lat or long field. Therefore geocoding an address into their corresponding lat and long coordinates must be done and appropriate markers must be placed. The code which I have at the moment is as follows:-

<?php
require_once '../model/stores.php';
$obj=new Stores();
$result=$obj->getStores();
$new_array = array();

while($row=mysql_fetch_assoc($result)){
$new_array[] = $row['stores_address']; 
}
$add_js = json_encode( $new_array );
?>

<html>
<head>
<style>
#map_canvas {
width: 500px;
height: 500px;
}
</style>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js"></script>
<script src="http://maps.google.com/maps/api/js?sensor=false" type="text/javascript"></script>

<script>
$(document).ready(function () {
var map;
var elevator;
var myOptions = {
zoom: 1,
center: new google.maps.LatLng(0, 0),
mapTypeId: 'terrain'
};
map = new google.maps.Map($('#map_canvas')[0], myOptions);

//var addresses = ['Norway', 'Africa', 'Asia','North America','South America'];
var addresses = <?php echo $add_js ?>;;

for (var x = 0; x < addresses.length; x++) {
$.getJSON('http://maps.googleapis.com/maps/api/geocode/json? address=' +addresses[x]+'&sensor=false', null, function (data) {
var p = data.results[0].geometry.location
var latlng = new google.maps.LatLng(p.lat, p.lng);
new google.maps.Marker({
position: latlng,
map: map
});
});
}

});
</script>
</head>
<body>
<div id="map_canvas"></div>
</body>
</html>

I have looked on various forums and other web resources but no use as none of them worked out for me...Hope any genius would help me to solve the problem.
Edited by Naseem, 15 August 2014 - 12:25 AM.

Code: [Select]
$sql="SELECT * FROM $tbl_name3 WHERE review_show='n'";
$result=mysql_query($sql);
$num_results=mysql_num_rows($result);
if($num_results > 1){
$message="You have ".$num_results." reviews unapproved.";
mail('example@example.com','GHP Reviews', $message, 'From: example@example.com');
}

$sql2="SELECT * FROM $tbl_name4 WHERE rma_issued='n'";
$result2=mysql_query($sql2);
$num_results2=mysql_num_rows($result2);
if($num_results2 > 1){
$message="You have ".$num_results2." RMA Numbers Requested.";
mail('example@example.com','GHP RMA Number Requests', $message, 'From: example@example.com');
}

The reviews email is being sent, however, the RMA email is not.

EDIT: Nevermind, $num_results and $num_results2 should have been > 0 not > 1.