je rencontre un problème dans le développement d'un système d'envoi d'emails de masse.
Impossible de récupérer les valeurs de variables dans le corps du mail ($code_html), qui est généré via le champ de formulaire text_new_email_prospect_individual. Hors, j'en ai besoin (notamment de l'id du prospect) pour tracer les liens cliqués dans les mails.
A noter que lorsque j'intègre des variables directement dans ce script de traitement (ici l'exemple avec sendto), ça fonctionne bien.
Merci d'avance
Code : Tout sélectionner
$prospect_individual_email = $_POST['prospect_individual_email'] ;
$title_new_email_prospect_individual = $_POST['title_new_email_prospect_individual'];
$title_new_email_prospect_individual_for_db = nl2br(addslashes($title_new_email_prospect_individual));
$text_new_email_prospect_individual = $_POST['text_new_email_prospect_individual'];
$text_new_email_prospect_individual_for_db = nl2br(addslashes($text_new_email_prospect_individual));
$text_new_email_prospect_individual = utf8_decode(utf8_encode(nl2br(stripcslashes($text_new_email_prospect_individual)))) ;
$from_new_email_prospect_individual = $_POST['from_new_email_prospect_individual'];
$sql_get_that_prospect = 'SELECT * FROM `prospects_mailing` WHERE email = "'.$prospect_individual_email.'"';
$req_get_that_prospect = mysql_query($sql_get_that_prospect) or die('Erreur SQL !<br>'.$sql_get_that_prospect.'<br>'.mysql_error()) ;
while ($data = mysql_fetch_array($req_get_that_prospect))
{
$email_new_email_prospect_individual = $data['email'] ;
$id_prospect_individual = $data['id'] ;
$name_prospect_individual = $data['name'] ;
//Met à jour entrée mailing
$sql_update_mailing = "UPDATE `prospects_mailing` SET number_emails_sent = number_emails_sent + 1, date_last_email_sent = '".$date."', title_last_email_sent = '".$title_new_email_prospect_individual_for_db."', text_last_email_sent = '".$text_new_email_prospect_individual_for_db."' WHERE email = '".$email_new_email_prospect_individual."'" ;
$req_update_mailing = mysql_query($sql_update_mailing) or die('Erreur SQL !<br>'.$sql_update_mailing.'<br>'.mysql_error()) ;
//Envoi de l'email
$sendto = ''.$email_new_email_prospect_individual.'';
$subject = ''.$title_new_email_prospect_individual.'' ;
$from .= "From: \"Myemail\"<$from_new_email_prospect_individual>\n";
$from .= "MIME-version: 1.0\n";
$from .= "Content-type: text/html; charset= UTF-8\n";
$code_html = "<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01//EN' 'http://www.w3.org/TR/html4/strict.dtd'>
<html>
<head>
<meta content='text/html; charset=UTF-8' http-equiv='content-type' />
</head>
<body style='margin-top: 10px; margin-bottom: 8px; font-family: Arial, Verdana, Geneva, Kalimati, sans-serif; overflow-y: scroll;'>
<div style='width: 550px; margin-top: 10px; margin-left: 10px;'>
Contenu mail
$sendto
</div>
</body>
</html>";
mail($sendto,$subject,$code_html,$from);
}