All Posts by Email, Once a Week

Media Temple logo

CSS-Tricks is brought to you in part by Media Temple, the web hosting that we both use and recommend.


  • # December 9, 2009 at 9:58 am


    I’m going to make a newsletter on a website. I’ve tried to fint a script, but it’s not very good. Do anyone have a link to a good script – which is free -, a tutorial or like?


    # December 9, 2009 at 11:59 am

    Have you tried:

    # December 9, 2009 at 12:07 pm

    I’m assuming by newsletter you want to send an email to a group of people.

    I’ve never built something like this before, but I would do something like this.

    Create a table in your database called "newsletter" with 3 fields

    CREATE TABLE `demo`.`newsletter` (
    `name` VARCHAR( 125 ) NOT NULL ,
    `email` TEXT NOT NULL

    On your php file get all the rows from the table, and in the while loop send a message to each user. In addition, if an email fails, add it to an array so you can echo each recipients name and email address.

    < ?php $con = mysql_connect('localhost', 'root', '') or die(mysql_error()); mysql_select_db('demo', $con); $sql = "SELECT * FROM `newsletter`"; $res = mysql_query($sql) or die(mysql_error()); $sent_emails = array(); $failed_emails = array(); $subject = 'Hello %name%, Baylor sent you an email'; $message = << Thank you for subscribing to my website.

    while( $row = mysql_fetch_assoc($res) ) {
    $new_subject = str_replace(“%name%”, $row[‘name’], $subject);
    $new_message = str_replace(“%name%”, $row[‘name’], $message);

    if( mail($row[’email’], $new_subject, $new_message) ) {
    $sent_emails[] = “

    Email Sent To: ” . $row[‘name’] . ” – ” . $row[’email’] . “

    $failed_emails[] = “

    Email Not Sent To: ” . $row[‘name’] . ” – ” . $row[’email’] . “


    foreach( $failed_emails as $message ) :
    echo $message;


    (I haven’t tested this, but it should work)

    # December 9, 2009 at 2:50 pm

    I mean something, where you on my website, can subscribe for a newsletter. Then all who subscribe get’s collected in a list. When i want to send out a e-mail to everyone who has subscribed, i can log into a part of my website with a login, and make a message to them all.

    Do you know a script like that, which is easy to set up?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

There's a whole bunch of content on CSS-Tricks.

Search for Stuff   •   Browse the Archives

Get the Newsletter ... or get the RSS feed