Hvordan henter jeg alle emails fra db og sætter ind i Mail()
Hej jeg kan ikke lige finde ud af hvordan jeg sætter min hjemmeside til at sende til alle email adresser i users hvor nyhedsbrev = "ja":( kan i hjælpe mig*?
her er min kode
<?
session_start();
include("application.php");
if($_POST['do'] == "sta"){ //-- ```````````````````````````````news
$posted_by = $_POST['posted_by'];
// subject
$subject = $_POST['headline'];
// to
$to = ""; <!-- alle emails her -->
// Cups DB
$nquery = "SELECT * FROM cups ORDER BY `id` DESC LIMIT 1";
$nresult = mysql_query($nquery) or die("Argh der er noget galt");
while ($nrow = mysql_fetch_object($nresult)){
$_POST['cups_name'] = $nrow->name;
$_POST['cups_content'] = $nrow->prizes;
}
// nyheder
$nquery = "SELECT * FROM newz ORDER BY `id` DESC LIMIT 1";
$nresult = mysql_query($nquery) or die("Argh der er noget galt");
while ($nrow = mysql_fetch_object($nresult)){
$_POST['newz_name'] = $nrow->haedline;
$_POST['newz_content'] = $nrow->content;
}
// dfdf
$SQL = "SELECT * FROM shop";
$loadin = mysql_query($SQL) or die("There is an Error in the database");
while ($Get = mysql_fetch_object($loadin)){
$_POST['shop_content'] = $Get->indhold;
}
// sdfsd
$SQL = "SELECT * FROM side WHERE id = '5'";
$loadin = mysql_query($SQL) or die("There is an Error in the database");
while ($Get = mysql_fetch_object($loadin)){
$_POST['spons_content'] = $Get->indhold;
}
// message
$message = '
<html>
<head>
<title>'.$_POST['headline'].'</title>
</head>
<body bgcolor="#CCCCCC">
<center>
<table cellpadding="0" cellspacing="4" border="0" width="800px">
<tr>
<td colspan="2" height="238">
<img src="" width="800" height="238" />
</td>
</tr>
<tr>
<td align="left" style="font-family:Times New Roman, Times, serif;color:#333333;font-size:24px">
<strong>Nyhedsbrev</strong><font size="3"> fra x</font>
</td>
<td align="right">
'.date("j. F Y").'
</td>
</tr>
<tr>
<td align="left" colspan="2">
'.$_POST['firstline'].'
</td>
</tr>
<tr>
<td align="left" colspan="2">
'.$_POST['text'].'
</td>
</tr>
<tr>
<td align="left" colspan="2">
<hr><strong style="font-size:18px">Næste cup</strong><hr>'.$_POST['cups_name'].'<br />'.$_POST['cups_content'].'
</td>
</tr>
<tr>
<td align="left" colspan="2">
<hr><strong style="font-size:18px">Nyheder</strong><hr>'.$_POST['newz_name'].'<br>'.$_POST['newz_content'].' <a href="">Se andre nyheder</a>
</td>
</tr>
<tr>
<td align="left" colspan="2">
<hr><strong style="font-size:18px">Reklame</strong><hr>'.$_POST['spons_content'].'
</td>
</tr>
<tr>
<td align="left" colspan="2">
<hr><strong style="font-size:18px">Fra shoppen</strong><hr>'.$_POST['shop_content'].'
</td>
</tr>
<tr>
<td align="center" colspan="2" style=" font-size:8px;">
Vis du ikke vil abonere på nyhedsbrevet kan du logge ind på din konto og framælde dig. <a target="_blank" href="/">Klik her</a>
</td>
</tr>
</table>
</center>
</body>
</html>
';
// To send HTML mail, the Content-type header must be set
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
// Additional headers
$headers .= 'From: ' . "\r\n";
//$c = 0;
//$sql = mysql_query("select * from users");
//while($row = mysql_fetch_assoc($sql)) {
mail($to, $subject, $message, $headers);
//$c++;
//}
Java::Alert("Sendt til brugere...");
Java::GoToURL("admin.php?page=contact.service");
}elseif($_POST['do'] == ""){ //-- ```````````````````````````````0
Java::Alert("Der gik noget galt!");
}
Db::Conn(close);
?>
