Bonsoir,
quelqu'un peux m'aider,
j'ai fait quelque changement les voilà
Cela m'affiche les deux adresse mail de mon liste mais il ne fait pas la boucle.
et écris là même adresse mail dans la BDD.
Merci de votre aide,
[code]
<?php
include_once '../admin-class.php';
include_once '../config/includes/config.php';
$admin = new itg_admin();
$admin->_authenticate();
foreach ($_REQUEST as $key => $val)
{
$val = preg_replace("/[^_A-Za-z0-9-\.&=]/i",'', $val);
$_REQUEST[$key] = $val;
}
?>
<?php
$reponse = $bdd->query('SELECT * FROM db_groupe_newsletter, db_newsletter WHERE name_groupe_newsletter = "'.$_GET['groupe_send'].'" AND id_newsletter = "'.$_GET['newsletter_send'].'" AND send_email_customer_newsletter = 0');
$reponse1 = $bdd->query('SELECT * FROM donnee');
$reponse2 = $bdd->query('SELECT COUNT(*) as emailcustomer_groupe_newsletter FROM db_groupe_newsletter, db_newsletter WHERE name_groupe_newsletter = "'.$_GET['groupe_send'].'" AND id_newsletter = "'.$_GET['newsletter_send'].'" AND send_email_customer_newsletter = 0');
$donnee = $reponse->fetch();
$donnee1 = $reponse1->fetch();
$result = $reponse2->fetchColumn();
{
?>
<?php
$nbligne = "$result";
$mail = $donnee['emailcustomer_groupe_newsletter'];
$email_add = $donnee['email_HD'];
$sujet = $donnee['sujet_newsletter'];
$titre = $donnee['titre_newsletter'];
$type_email_send = $donnee['html_newsletter'];
$type_email_send_texte = $donnee['texte_newsletter'];
$signature = $donnee1['signature'];
$signature_texte = $donnee1['signature_text'];
$id_groupe_newslette = $donnee['id_groupe_newsletter'];
$id_newslette = $donnee['id_newsletter'];
$send_db_groupe_newsletter = $donnee['send_db_groupe_newsletter'];
$send_email_customer = "$mail";
$send_db_groupe_newsletter = '1';
$negiciateur = $admin->get_username();
$negiciateur1 = $admin->get_nicename();
$reponse3 = $bdd->query('SELECT emailcustomer_groupe_newsletter FROM db_groupe_newsletter, db_newsletter WHERE name_groupe_newsletter = "'.$_GET['groupe_send'].'" AND id_newsletter = "'.$_GET['newsletter_send'].'" AND send_email_customer_newsletter = 0');
foreach ($reponse3->fetchAll(PDO::FETCH_ASSOC|PDO::FETCH_GROUP) as $emailcustomer_groupe_newsletter => $subarray) {
printf('<h3>%s</h3>', $emailcustomer_groupe_newsletter);
echo '<ul>';
foreach ($subarray as $subsubarray) {
$mail = $subarray['emailcustomer_groupe_newsletter'];
printf($mail);
if (!preg_match("#^[a-z0-9._-]+@(hotmail|live|msn).[a-z]{2,4}$#", $mail)) // On filtre les serveurs qui présentent des bogues.
{
$passage_ligne = "\r\n";
}
else
{
$passage_ligne = "\n";
}
$message_txt = "$type_email_send_texte $signature_texte";
$message_html = "$type_email_send $signature";
$boundary = "-----=".md5(rand());
$boundary_alt = "-----=".md5(rand());
$sujet = "$sujet";
$header = "From: \"$titre\"<$mail>".$passage_ligne;
$header.= "Reply-to: \"$titre\" <$email_add>".$passage_ligne;
$header.= "MIME-Version: 1.0".$passage_ligne;
$header.= "Content-Type: multipart/mixed;".$passage_ligne." boundary=\"$boundary\"".$passage_ligne;
$message = $passage_ligne."--".$boundary.$passage_ligne;
$message.= "Content-Type: multipart/alternative;".$passage_ligne." boundary=\"$boundary_alt\"".$passage_ligne;
$message.= $passage_ligne."--".$boundary_alt.$passage_ligne;
$message.= "Content-Type: text/plain; charset=\"ISO-8859-1\"".$passage_ligne;
$message.= "Content-Transfer-Encoding: 8bit".$passage_ligne;
$message.= $passage_ligne.$message_txt.$passage_ligne;
$message.= $passage_ligne."--".$boundary_alt.$passage_ligne;
$message.= "Content-Type: text/html; charset=\"ISO-8859-1\"".$passage_ligne;
$message.= "Content-Transfer-Encoding: 8bit".$passage_ligne;
$message.= $passage_ligne.$message_html.$passage_ligne;
$message.= $passage_ligne."--".$boundary_alt."--".$passage_ligne;
$message.= $passage_ligne."--".$boundary.$passage_ligne;
mail($mail,$sujet,$message,$header);
$sql = "INSERT INTO `appli`.`send_group_newsletter` (`id_send_group_newsletter`, `id_newslette`, `id_groupe_newslette`, `send_db_groupe_newsletter`, `send_email_customer`, `date_groupe_newsletter`, `timedate_groupe_newsletter`, `negiciateur`) VALUES (NULL, '$id_newslette', '$id_groupe_newslette', '$send_db_groupe_newsletter', '$send_email_customer', NOW(), NOW(), '$negiciateur $negiciateur1')";
$sql1 = "UPDATE `appli`.`db_groupe_newsletter` SET `send_email_customer_newsletter` = '1' WHERE `db_groupe_newsletter`.`id_groupe_newsletter` = '$id_groupe_newsletter'";
$bdd->exec($sql);
$bdd->exec($sql1);
}
}
echo '</ul>';
}
?>
<?php
$reponse->closeCursor();
$reponse1->closeCursor();
$reponse2->closeCursor();
$reponse3->closeCursor();
echo '<SCRIPT LANGUAGE="JavaScript">
window.alert("Votre newsgroupe a était envoyé !")
window.location.href="../administration/newsletter_en.php"
</SCRIPT>';
?>
[/code]
