Envio por e-mail
olá a todos.
Preciso enviar e-mail para usuários conforme a cidade, exemplo: se tem 30 itens da cidade de São Paulo esta enviando 30 e-mails. Preciso que envie somente um e-mail com os 30 registros.
Veja o código que uso.
>
Citar
<?php
$sql2 = "SELECT cities.city_name,cities.slug,cities.state, places.city_id as cidade_id,places.place_id,places.place_name,places.description,places.submission_date,places.email,places.jobid,subscriptions.id as idj,subscriptions.email as mail,subscriptions.city_id,subscriptions.token,subscriptions.created,subscriptions.is_confirmed FROM cities, places,subscriptions WHERE cities.city_id=places.city_id and places.city_id=subscriptions.city_id and places.status='approved' and subscriptions.is_confirmed=1 and subscriptions.id=1496 GROUP BY subscriptions.email limit 3 ";
$ex2 = mysql_query($sql2) or die (mysql_error());
//$x = 0;
while ($row= mysql_fetch_array( $ex2 ) )
{
$id=$row['place_id'];
$nome=$row['place_name'];
$slug=toAscii($row['place_name']);
$description= $row['description'];
$cidade= $row['city_name'];
$cityslug= toAscii($row['city_name']);
$city_id= $row['cidade_id'];
$data= $row['submission_date'];
$place_id=$row['place_id'];
//$contar=$row['contar'];
$token=$row['token'];
$email=$row['email'];
$mail=$row['mail'];
$idj=$row['idj'];
$T1=$nome;
$_SESSION['T1']= $T1;
$T15=$slug;
$_SESSION['T15']= $T15;
$T4=$description;
$_SESSION['T4']=$T4;
$T5=$cidade;
$_SESSION['T5']=$T5;
$T16=$cityslug;
$_SESSION['T6']=$T16;
$T20=$city_id;
$_SESSION['T20']=$T20;
/*$T6=$cidade;
$_SESSION['T6']=$T6;*/
$T7=$place_id;
$_SESSION['T7']=$T7;
$T18=$contar;
$_SESSION['T18']=$T18;
$T9=date('d/m/Y',strtotime($data));
$_SESSION['T9']=$T9;
$T11=base64_encode($place_id);
$_SESSION['T11']=$T11;
$alert="alerta";
$T31=base64_encode($alert);
$_SESSION['T31']=$T31;
$T14=base64_encode($email);
$_SESSION['T14']=$T14;
$T32=$email;
$_SESSION['T32']=$T32;
$email_text_select = mysql_fetch_array( mysql_query( "select * from emailtext_emp where et_code='news2'" ) );
$adminemail="noreplay@site.net";
$webname="site";
$to=$mail;
$js_id=$idj;
$message_text="";
$message_text = $email_text_select['et_details'];
$message_text = str_replace( "%nome%", $nome, $message_text );
$message_text = str_replace( "%js_id%", $js_id, $message_text );
$message_text = str_replace( "%token%", $token, $message_text );
$message_text = str_replace( "%T1%", $T1, $message_text );
$message_text = str_replace( "%T4%", $T4, $message_text );
$message_text = str_replace( "%T5%", $T5, $message_text );
$message_text = str_replace( "%T7%", $T7, $message_text );
$message_text = str_replace( "%T6%", $T6, $message_text );
$message_text = str_replace( "%T8%", $T8, $message_text );
$message_text = str_replace( "%T9%", $T9, $message_text );
$message_text = str_replace( "%T10%", $T10, $message_text );
$message_text = str_replace( "%T11%", $T11, $message_text );
$message_text = str_replace( "%T14%", $T14, $message_text );
$message_text = str_replace( "%T15%", $T15, $message_text );
$message_text = str_replace( "%T16%", $T16, $message_text );
$message_text = str_replace( "%T18%", $T18, $message_text );
$message_text = str_replace( "%T20%", $T20, $message_text );
$message_text = str_replace( "%T31%", $T31, $message_text );
$message_text = str_replace( "%T32%", $T32, $message_text );
$message_text = str_replace( "%webname%", $webname, $message_text );
$message = "{$message_text}";
$subject = "Novas vagas em $T5";//$email_text_select['et_subject'];
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
$headers .= "FROM: {$webname} <{$adminemail}>";
$headers .= "Reply-To: {$adminemail}\n";
$headers .= "Return-Path: {$adminemail}\n";
$message = str_replace( "'", "single_quote", $message );
$message = str_replace( "\"", "double_quote", $message );
$x = mail( $to, $subject, $message, $headers );
echo $message."<br>";
echo $mail."<br>";
//$x++;
// echo $nome."<br>";
}
?>
Importante: antes de passar por aqui, tentei tudo que esta a meu alcance, mas não consegui.
ObrigadoDiscussão (4)
Carregando comentários...