wordpress tip: extract all comment emails for mailing

[fris]

I dont recommend spamming your blog users, but sometimes you may want to send information to your readers, many of you might use a wordpress plugin for a mailing list or an external program which can import a list.

Here is a small snippet of code which will print out all your comment author's emails.

<?php

$db_host = "localhost";
$db_user = "username";
$db_password = "password";
$db_name = "database";

$connect=mysql_connect($db_host,$db_user,$db_password) or die(mysql_error());
$db=mysql_select_db($db_name, $connect) or die(mysql_error());

$result=mysql_query("select comment_author_email from wp_comments");
while($row=@mysql_fetch_assoc($result))
{
        $email=$row[comment_author_email];
        echo $email;
}

?>

[2012]

[Donfoolio]

Nice thank you!

[Ethersync]

Another excellent tip from our resident WordPress guru

[Si]

[Sosa]

good stuff fris

[camgirlshide]

Did you put a message on the site that says leaving a comment signs you up for a mailing list and have some opt out method?

[papill0n]

nice fris

[st0ned]

Another great thread from fris! You are on a roll lately, hit me up sometime lets do some biz.

[BigBen]

Quality posts lately.

Here's another way using built-in WP functions so you don't have to mess with the mysql stuff (tested in 2.7):

<?php
require_once('example.com/wp-load.php');

$email_list = $wpdb->get_results("SELECT DISTINCT comment_author_email FROM $wpdb->comments WHERE comment_author_email != ''");
foreach($email_list as $email) {
        echo $email->comment_author_email . "\n";
}

[fris]

good one ben ;)

[XX_RydeR]

Ah nice tip.

Though i wouldnt go sending them any type of message without first putting up something about
it on the blog, Terms or what not.

[Zuzana Designs]

Nice seeing some bizz on the board.. Thanks Fris ..

[pr0]

Quality posts lately.

Here's another way using built-in WP functions so you don't have to mess with the mysql stuff (tested in 2.7):

<?php
require_once('example.com/wp-load.php');

$email_list = $wpdb->get_results("SELECT DISTINCT comment_author_email FROM $wpdb->comments WHERE comment_author_email != ''");
foreach($email_list as $email) {
        echo $email->comment_author_email . "\n";
}

pwnd