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
| <?
$db=mysql_connect("sql.free.fr","xxx","xxx");
mysql_select_db("calendrier, listes",$db);
$date = date("Y/m/d");
$sql = "SELECT date_format(date_reel, '%d-%m-%Y') as 'date_reel_fr', quoi, ou, email, priv, affich, infos, newsletter, radio
FROM calendrier, listes
WHERE priv='n'
AND newsletter='o'
AND radio='n'
AND date_reel= '$date' + INTERVAL 3 DAY";
$liste = mysql_query($sql) ;
$envoi = mysql_query($sql);
while($tableau = mysql_fetch_array($liste))
{
$liste = $tableau['liste'];
$date_spect = $tableau['date_reel_fr'];
$quoi = $tableau['quoi'];
$ou = $tableau['ou'];
$infos = $tableau['infos'];
if($date_spect <> ""){
$headers ='From: "xxx"<newsletter@xxx.com>'."\n";
$headers .='Content-Type: text/html; charset="iso-8859-1"'."\n";
$headers .='Content-Transfer-Encoding: 8bit';
$message ='<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>xxx</title>
<style type="text/css">
<!--
.Style2 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
}
.Style3 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
font-weight: bold;
}
.Style6 {font-size: 13px}
.Style7 {font-size: 14px}
-->
</style>
</head>
<body>
<td width="72%"><div align="center" class="Style2">
<p class="Style6">Le prochain spectacle de xxx aura lieu le </p>
<p class="Style6"><span class="Style7"><strong>'.$date_spect.' ('.$quoi.') à '.$ou.'</strong><br>
<strong>Infos : '.$infos.'</strong></span></p>
<p class="Style6"> Obtenez plus de renseignements en vous rendant sur le <a href="http://xxx.free.fr/"> site de xxxx</a> !</p>
</div></td>
</tr>
</table>
</div>
</body>
</html>'
;
while ($data=mysql_fetch_array($envoi)) {
mail($data['email'], 'xxx- Newsletter', $message, $headers);
}
break;
}
}
echo''.$quoi.' - '.$date_spect.' - '.$ou.' - '.$infos.'-';
mysql_free_result($envoi);
mysql_close();
?> |
Partager