wordpress tip: extract all comment emails for mailing - GoFuckYourself.com

fris · 01-10-2009, 09:57 AM

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.

Code:

<?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 · 01-10-2009, 10:01 AM

Donfoolio · 01-10-2009, 10:04 AM

Nice thank you!

Ethersync · 01-10-2009, 10:06 AM

Another excellent tip from our resident WordPress guru

Si · 01-10-2009, 11:17 AM

Sosa · 01-10-2009, 11:28 AM

good stuff fris

camgirlshide · 01-10-2009, 12:24 PM

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 · 01-10-2009, 03:15 PM

nice fris

st0ned · 01-10-2009, 04:16 PM

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

BigBen · 01-10-2009, 06:26 PM

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):

Code:

<?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 · 01-11-2009, 05:57 AM

good one ben ;)

XX_RydeR · 01-11-2009, 06:17 AM

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 · 01-11-2009, 10:00 AM

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

pr0 · 01-11-2009, 10:03 AM

Quote:

Originally Posted by 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):

Code:

<?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

01-10-2009, 09:57 AM	#1
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,426	wordpress tip: extract all comment emails for mailing 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. Code: <?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; } ?> __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

01-10-2009, 10:01 AM	#2
2012 So Fucking What Industry Role: Join Date: Jul 2006 Posts: 17,189	__________________ best host: Webair \| best sponsor: Kink \| best coder: 688218966 \| Go Fuck Yourself

01-10-2009, 10:04 AM	#3
Donfoolio Confirmed User Join Date: Mar 2006 Location: Mars Posts: 963	Nice thank you! __________________ Promote SipSap escort search ICQ: 227853047

01-10-2009, 12:24 PM	#7
camgirlshide Confirmed User Join Date: Jan 2005 Posts: 1,558	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? __________________ Useful adult webmaster links - Alphabetical list of solo models with webcam Stats on my best converting affiliate programs - camgirlshide webmaster blog complete list of affiliate programs I use.

01-10-2009, 04:16 PM	#9
st0ned Confirmed User Industry Role: Join Date: Mar 2007 Location: Arizona Posts: 8,437	Another great thread from fris! You are on a roll lately, hit me up sometime lets do some biz. __________________ Conversion Sharks - 1,000+ adult dating offers, traffic management, and consistently high payouts. We will guarantee and beat your current EPC to win your dating traffic! Skype: ConversionSharks \|\| Email: info /@/ conversionsharks.com

01-10-2009, 10:06 AM	#4
Ethersync Confirmed User Join Date: Mar 2008 Location: London, Saint-Tropez, Bermuda, Moscow Posts: 5,289	Another excellent tip from our resident WordPress guru

01-10-2009, 11:17 AM	#5
Si Such Fun! Industry Role: Join Date: Feb 2008 Posts: 13,900

01-10-2009, 11:28 AM	#6
Sosa In Tushy Land Join Date: Oct 2002 Location: Nebraska Posts: 40,149	good stuff fris

01-10-2009, 03:15 PM	#8
papill0n Unregistered Abuser Industry Role: Join Date: Oct 2007 Posts: 15,547	nice fris

01-11-2009, 05:57 AM	#11
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,426	good one ben ;) __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

01-11-2009, 06:17 AM	#12
XX_RydeR Confirmed User Industry Role: Join Date: Jun 2004 Location: Australia. Posts: 2,151	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. __________________ You Dun Goofed!

01-11-2009, 10:00 AM	#13
Zuzana Designs All Your Design Needs Industry Role: Join Date: Feb 2005 Location: [email protected] Posts: 20,872	Nice seeing some bizz on the board.. Thanks Fris .. __________________ Website Design - Consulting - Development sarah [at] zuzanadesigns.com - See Our Work