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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113
| <?php
include 'message.php';
$id = split("#", $_GET['tableau']);
$i = 1;
while($i <= $_GET['compteur'])
{
$db = mysql_connect($hostname, $user, $password);
// on sélectionne la base
mysql_select_db($base,$db);
$sql = "SELECT nom,email FROM client where identifiant='".$id[$i]."';";
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
// on fait une boucle qui va faire un tour pour chaque enregistrement
if($data = mysql_fetch_assoc($req))
{
$headers ='From: "PROLOG"<e.vicedo@prologexpertise.com>'."\n";
$headers .='Reply-To: e.vicedo@prologexpertise.com'."\n";
$headers .='Content-Type: text/html; charset="iso-8859-1"'."\n";
$headers .='Content-Transfer-Encoding: 8bit'."\n";
if(mail($data['email'],'Mise à jour',$message,$headers))
{
$tabEnvoye[$i][0]=$data['nom'];
}
else
{
$tabNonEnvoye[$i][0]=$data['nom'];
$tabNonEnvoye[$i][1]=$data['email'];
}
}
$i++;
// on ferme la connexion à mysql
mysql_close();
}
?>
<html>
<head>
<meta name="author" content="Fabien Girard">
<title>PROLOG - Audits Conseils/Formations/Logiciels</title>
<link href="../../stylesheet.css" rel="stylesheet" type="text/css" media="all" />
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
</head>
<body>
<h2 style="margin-bottom:20px;margin-top:20px;">Compte rendu des mails :</h2>
<table cellspacing="0" cellpadding="4" style="border:solid 0px;font-size:12px" width="70%" align="center">
<tr colspan="2">
</tr>
<tr>
<td width="50%">
<table width="90%" align="center" cellspacing="2" cellpadding="4" bgcolor="#FFFFFF" style="border:solid 2px #0093D3;font-size:12px">
<tr bgcolor="#BBDDFF">
<td>
Total : <?php sizeof($tabEnvoye); ?>
</td>
</tr>
<tr>
<td align="center" bgcolor="#99CCFF" style="font-weight:bold;">
Envoye
</td>
</tr>
<?php
$x=0;
while($x < sizeof($tabNonEnvoye))
{
echo '<tr bgcolor="#dddddd" onMouseOver="this.bgColor=\'gold\';" onMouseOut="this.bgColor=\'#dddddd\';">';
echo '<td>
"'.$tabEnvoye[$x][0].'"
</td></tr>';
$x++;
}
?>
</table>
</td>
<td width="50%">
<table width="90%" align="center" cellspacing="2" cellpadding="4" bgcolor="#FFFFFF" style="border:solid 2px #0093D3;font-size:12px">
<tr bgcolor="#BBDDFF">
<td>
Total : <?php sizeof($tabNonEnvoye); ?>
</td>
</tr>
<tr>
<td align="center" bgcolor="#99CCFF" style="font-weight:bold;">
Non envoye
</td>
</tr>
<?php
$y=0;
while($y < sizeof($tabNonEnvoye))
{
echo '<tr bgcolor="#dddddd" onMouseOver="this.bgColor=\'gold\';" onMouseOut="this.bgColor=\'#dddddd\';">';
echo '<td>
"'.$tabNonEnvoye[$y][0].'"
</td>';
echo '<td>
"'.$tabNonEnvoye[$y][1].'"
</td></tr>';
$y++;
}
?>
</table>
</td>
</tr>
<tr colspan="2">
</tr>
</table>
</body>
</html> |
Partager