Simple Newsletter Script

With following snippet you can create your personal newsletter.

$query = 'SELECT id, email FROM users';
$result = mysql_query($query);

while ($row = mysql_fetch_assoc($result)) {

    $email_address = $row['email'];
    $id = $row['id'];

    $subject = 'Newsletter Subject';
    $message = file_get_contents('newsletter.html');
    $message = str_replace('http://www.unsubscribe.com', 'http://unsubscribe.com?id='.$id, $message);

    $headers  = 'MIME-Version: 1.0' . "\r\n";
    $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
    $headers .= 'From: <mail@gmail.com/>' . "\r\n";

    mail($email_address, $subject, $message, $headers);
}