1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| $dest = "";
$requete2="select genre,nom,prenom,mail from t_commandes, t_clt where t_clt.k_clt = t_commandes.k_clt and etat='nouvelle' and status='finalisee'";
$exe = mysql_query($requete2);
$i=0;
while($dest=mysql_fetch_array($exe,MYSQL_NUM))
{
echo "<tr>";
foreach($dest as $mail)
{
echo "<td> $mail <br></td>";
}
$destinataires[$i]=$mail;
$i++;
echo "</tr>";
}
echo "</tbody></table>";
foreach ($destinataires as $cle=>$val){
echo 'num : '.$cle.' dest : '.$val.' <br/>';
}
$i=0; // on repasse $i à 0 pour parcourir $destinataires
foreach($destinataires as $cle=>$dest){
if(mail($dest,"FBI Distribution: votre commande No $num_com", $text, $headers)){
echo "Envoi reussi a $dest";
}
else{
echo "Echec envoi a $dest";
}
}
?> |
Partager