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
| <?php
//...
$requete = "SELECT * FROM newsletter";
$page = isset($_GET['page']) ? $_GET['page'] : '';
$ret = mysql_query($requete);
$limit = 1;
if($debut == ""){$debut=0;}
$debut = $page * $limit;
$nb_total = mysql_num_rows($ret);
$sql1 = $requete ." limit ". $debut .",". $limit;
$limite = mysql_query($sql1);
$limit_str = "LIMIT ". $debut .",". $limit;
$sql2 = "SELECT * ".
"FROM newsletter ".
" ". $limit_str;
$result = mysql_query($sql2);
if($debut+$limit<$nb_total)
{
$suivant = $page + 1;
echo "<form method=\"POST\" action=\"?o=ml&act=envoi&page=". $suivant ."\">";
}
?>
<b>Votre message en HTML ou en texte brut :</b>
<?php
$messag = $_POST['messag'];
?>
<textarea rows="20" name="messag" cols="50"><?php echo $messag; ?></textarea><br>
<br>
<input type="submit" name="submitlettre" value="Envoyer la NewsLetter">
</form>
<?php
if ($_POST['submitlettre'] == TRUE)
{
$messag = $_POST['messag'];
while (false != ($c = mysql_fetch_array($result)))
{
// ICI MON CODE DE LA NEWLETTERS
mail($c['email'], $objet, $message, $headers);
}
echo "NewsLetter envoyée !";
}
?> |
Partager