[PHP] Mass Mailing with PHP MySQL
Hi, I'm working on a mailing solution for a client. His site collects email address from a 'Send this site to a friend' page (user enters their email address and up to 10 other addresses - a message is then sent to the 10 addresses from the users own email address). The addresses are then stored in a MySQL database - a column for the users email address, and then a column each for the additional 10 addresses. Now the client would like to have the ability to send an email to all addresses collected at once - to inform the addresses of a sale, etc. I'm guessing for this to be done, I'd have to select all the DISTINCT email addresses from the 11 columns (users email, and the 10 addresses), then use a loop to send the mail out. I had planned on using PHP's mail() function - does anyone know of any limitations imposed by this method? Normally, I'd contact the ISP and ask them directly, however it's been several weeks since they've answered the phones. Does anyone have any other/better options that I should pursue? This will be my first mass mailing typed job so I'm not really sure where to begin or if I'm on the right path at all. Thanks -Tim -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Mass Mailing with PHP MySQL
A while() loop will, at some point, break. this is because the script will timeout on the server before you send to any large lists... when I say large, this could be 100 address', or could be 10,000 -- it all depends on your server/ISP and server load at certain times. A better/simpler solution would be to build a Bcc header field using the while loop, then only send ONE email to 1000's of email address' via the Bcc field, just like you would from Outlook. BUT, your host may impose restrictions on how many emails you can send in one Bcc... my host has a limit of 100. So, I tend to send a few emails of 50-ish people per email to my list, balancing the two above issues. There are also some simple/complex classes on phpclasses.org (esp the one by manuel lemmos) which can overcome both these problems, with various methods. I haven't used them yet, basically because I don't see the need yet, given my small lists. Justin on 20/01/03 3:21 PM, Tim Thorburn ([EMAIL PROTECTED]) wrote: Hi, I'm working on a mailing solution for a client. His site collects email address from a 'Send this site to a friend' page (user enters their email address and up to 10 other addresses - a message is then sent to the 10 addresses from the users own email address). The addresses are then stored in a MySQL database - a column for the users email address, and then a column each for the additional 10 addresses. Now the client would like to have the ability to send an email to all addresses collected at once - to inform the addresses of a sale, etc. I'm guessing for this to be done, I'd have to select all the DISTINCT email addresses from the 11 columns (users email, and the 10 addresses), then use a loop to send the mail out. I had planned on using PHP's mail() function - does anyone know of any limitations imposed by this method? Normally, I'd contact the ISP and ask them directly, however it's been several weeks since they've answered the phones. Does anyone have any other/better options that I should pursue? This will be my first mass mailing typed job so I'm not really sure where to begin or if I'm on the right path at all. Thanks -Tim -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Fwd: Re: [PHP] Mass Mailing with PHP MySQL
- Forwarded message from [EMAIL PROTECTED] - Date: Sun, 19 Jan 2003 22:07:34 -0700 From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Subject: Re: [PHP] Mass Mailing with PHP MySQL To: Justin French [EMAIL PROTECTED] Is Peter McNulty out there anywhere? Don't have a lot of experience with mailing scripts, but I use the one found at codingclick.com Anyone else? RW Quoting Justin French [EMAIL PROTECTED]: ### A while() loop will, at some point, break. this is because the script ### will ### timeout on the server before you send to any large lists... when I say ### large, this could be 100 address', or could be 10,000 -- it all depends ### on ### your server/ISP and server load at certain times. ### ### A better/simpler solution would be to build a Bcc header field using the ### while loop, then only send ONE email to 1000's of email address' via the ### Bcc ### field, just like you would from Outlook. ### ### BUT, your host may impose restrictions on how many emails you can send in ### one Bcc... my host has a limit of 100. ### ### So, I tend to send a few emails of 50-ish people per email to my list, ### balancing the two above issues. ### ### ### There are also some simple/complex classes on phpclasses.org (esp the one ### by ### manuel lemmos) which can overcome both these problems, with various ### methods. ### ### I haven't used them yet, basically because I don't see the need yet, ### given ### my small lists. ### ### ### Justin ### ### ### ### ### ### ### ### ### ### on 20/01/03 3:21 PM, Tim Thorburn ([EMAIL PROTECTED]) wrote: ### ### Hi, ### ### I'm working on a mailing solution for a client. His site collects ### email ### address from a 'Send this site to a friend' page (user enters their ### email ### address and up to 10 other addresses - a message is then sent to the 10 ### addresses from the users own email address). The addresses are then ### stored ### in a MySQL database - a column for the users email address, and then a ### column each for the additional 10 addresses. ### ### Now the client would like to have the ability to send an email to all ### addresses collected at once - to inform the addresses of a sale, etc. ### I'm ### guessing for this to be done, I'd have to select all the DISTINCT email ### addresses from the 11 columns (users email, and the 10 addresses), then ### use ### a loop to send the mail out. ### ### I had planned on using PHP's mail() function - does anyone know of any ### limitations imposed by this method? Normally, I'd contact the ISP and ### ask ### them directly, however it's been several weeks since they've answered ### the ### phones. ### ### Does anyone have any other/better options that I should pursue? This ### will ### be my first mass mailing typed job so I'm not really sure where to begin ### or ### if I'm on the right path at all. ### ### Thanks ### -Tim ### ### ### ### ### -- ### PHP General Mailing List (http://www.php.net/) ### To unsubscribe, visit: http://www.php.net/unsub.php ### ### - End forwarded message - -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: Re: [PHP] Mass Mailing with PHP MySQL
I had an idea myself to do this. But I've held off because I want to do something rather robust but still flexible. I was going to use a database table.. with the fields.. to.. from.. subject.. body.. etc I was then going to have a cron task that ran every so often grabbing the records 1000-2000 at a time and sending them... if the script timed out the queue would still be there next time it ran. Would this be a good solution for a heavy amount of emails? The benefit I guess is I can use any language I like to read the database and send the emails but still queue it up with php or any other language. I could even add a date time field to send emails at a certain time as well. I think it would also free the user up faster as the records could be added to the database with Insert delay. The series of inserts would be done and the user can forget about it. A simple admin page with a Count query could monitor the queues progress. Am I on the right track? any ideas additions? Cheers Brendon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 20, 2003 3:09 PM To: [EMAIL PROTECTED] Subject: Fwd: Re: [PHP] Mass Mailing with PHP MySQL - Forwarded message from [EMAIL PROTECTED] - Date: Sun, 19 Jan 2003 22:07:34 -0700 From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Subject: Re: [PHP] Mass Mailing with PHP MySQL To: Justin French [EMAIL PROTECTED] Is Peter McNulty out there anywhere? Don't have a lot of experience with mailing scripts, but I use the one found at codingclick.com Anyone else? RW Quoting Justin French [EMAIL PROTECTED]: ### A while() loop will, at some point, break. this is because the script ### will ### timeout on the server before you send to any large lists... when I say ### large, this could be 100 address', or could be 10,000 -- it all depends ### on ### your server/ISP and server load at certain times. ### ### A better/simpler solution would be to build a Bcc header field using the ### while loop, then only send ONE email to 1000's of email address' via the ### Bcc ### field, just like you would from Outlook. ### ### BUT, your host may impose restrictions on how many emails you can send in ### one Bcc... my host has a limit of 100. ### ### So, I tend to send a few emails of 50-ish people per email to my list, ### balancing the two above issues. ### ### ### There are also some simple/complex classes on phpclasses.org (esp the one ### by ### manuel lemmos) which can overcome both these problems, with various ### methods. ### ### I haven't used them yet, basically because I don't see the need yet, ### given ### my small lists. ### ### ### Justin ### ### ### ### ### ### ### ### ### ### on 20/01/03 3:21 PM, Tim Thorburn ([EMAIL PROTECTED]) wrote: ### ### Hi, ### ### I'm working on a mailing solution for a client. His site collects ### email ### address from a 'Send this site to a friend' page (user enters their ### email ### address and up to 10 other addresses - a message is then sent to the 10 ### addresses from the users own email address). The addresses are then ### stored ### in a MySQL database - a column for the users email address, and then a ### column each for the additional 10 addresses. ### ### Now the client would like to have the ability to send an email to all ### addresses collected at once - to inform the addresses of a sale, etc. ### I'm ### guessing for this to be done, I'd have to select all the DISTINCT email ### addresses from the 11 columns (users email, and the 10 addresses), then ### use ### a loop to send the mail out. ### ### I had planned on using PHP's mail() function - does anyone know of any ### limitations imposed by this method? Normally, I'd contact the ISP and ### ask ### them directly, however it's been several weeks since they've answered ### the ### phones. ### ### Does anyone have any other/better options that I should pursue? This ### will ### be my first mass mailing typed job so I'm not really sure where to begin ### or ### if I'm on the right path at all. ### ### Thanks ### -Tim ### ### ### ### ### -- ### PHP General Mailing List (http://www.php.net/) ### To unsubscribe, visit: http://www.php.net/unsub.php ### ### - End forwarded message - -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Mass-mailing method
some times more than 100 bcc's are treated spam and dropped by the server, try it with
a limit in the query.
Best Wishes Happy New Year
Paul Roberts
[EMAIL PROTECTED]
- Original Message -
From: Cesar Aracena [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 6:19 AM
Subject: RE: [PHP] Mass-mailing method
I'm going to try changing that. I don't have access to my client's
server as I work remotely, so I can't view any logs... or can I? If
anyone else have something for me to try, start shooting...
Thanks,
Cesar L. Aracena
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(0299) 156-356688
Neuquén (8300) Capital
Argentina
-Mensaje original-
De: Michael J. Pawlowsky [mailto:[EMAIL PROTECTED]]
Enviado el: viernes, 03 de enero de 2003 3:15
Para: Cesar Aracena; [EMAIL PROTECTED]
Asunto: Re: [PHP] Mass-mailing method
Take a look at the sendmail.log for some clues...
But I had something weird were it worked fine for me at home Linux 8 PHP
4.2.2
and when I sent it up to the prod server I had to change the .\r\n;
to .\n;
Which technically is wrong.
Go figure!
But take a look at the sendmail log to begin with.
Mike
*** REPLY SEPARATOR ***
On 03/01/2003 at 3:08 AM Cesar Aracena wrote:
Hi all,
I did a registration page for a customer, and now I'm trying to develop
a way for him to send an e-mail once in a while to the people
registered
with him. I did something (shown below) and everything seems to be ok,
but the e-mail never reaches... Can someone find the problem or maybe
point me to something already done to send multiple e-mails as BCC???
Thanks in advance,
$query = SELECT * FROM mararegistro2 ORDER BY lname;
$result = mysql_query($query) or die (mysql_errno());
$num_rows = mysql_num_rows($result);
for ($x=0; $x $num_rows; $x++)
{
$row = mysql_fetch_array($result);
$bcc .= $row[email].; ;
}
$myname = .$name.;
$myemail = .$email.;
$contactemail = $bcc;
$message = .$mes.;
$subject = .$subject.;
$headers .= MIME-Version: 1.0\r\n;
$headers .= Content-type: text/html; charset=iso-8859-1\r\n;
$headers .= From: .$myname. .$myemail.\r\n;
$headers .= Bcc: .$contactemail.\r\n;
$headers .= Reply-To: .$myname. .$myemail.\r\n;
$headers .= X-Priority: 1\r\n;
$headers .= X-MSMail-Priority: High\r\n;
$headers .= X-Mailer: Joyeria Mara;
$mail = mail(, $subject, $message, $headers);
Cesar L. Aracena
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(0299) 156-356688
Neuquén (8300) Capital
Argentina
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Mass-mailing method
Hi all,
I did a registration page for a customer, and now I'm trying to develop
a way for him to send an e-mail once in a while to the people registered
with him. I did something (shown below) and everything seems to be ok,
but the e-mail never reaches... Can someone find the problem or maybe
point me to something already done to send multiple e-mails as BCC???
Thanks in advance,
$query = SELECT * FROM mararegistro2 ORDER BY lname;
$result = mysql_query($query) or die (mysql_errno());
$num_rows = mysql_num_rows($result);
for ($x=0; $x $num_rows; $x++)
{
$row = mysql_fetch_array($result);
$bcc .= $row[email].; ;
}
$myname = .$name.;
$myemail = .$email.;
$contactemail = $bcc;
$message = .$mes.;
$subject = .$subject.;
$headers .= MIME-Version: 1.0\r\n;
$headers .= Content-type: text/html; charset=iso-8859-1\r\n;
$headers .= From: .$myname. .$myemail.\r\n;
$headers .= Bcc: .$contactemail.\r\n;
$headers .= Reply-To: .$myname. .$myemail.\r\n;
$headers .= X-Priority: 1\r\n;
$headers .= X-MSMail-Priority: High\r\n;
$headers .= X-Mailer: Joyeria Mara;
$mail = mail(, $subject, $message, $headers);
Cesar L. Aracena
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(0299) 156-356688
Neuquén (8300) Capital
Argentina
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Mass-mailing method
Take a look at the sendmail.log for some clues...
But I had something weird were it worked fine for me at home Linux 8 PHP 4.2.2
and when I sent it up to the prod server I had to change the .\r\n; to .\n;
Which technically is wrong.
Go figure!
But take a look at the sendmail log to begin with.
Mike
*** REPLY SEPARATOR ***
On 03/01/2003 at 3:08 AM Cesar Aracena wrote:
Hi all,
I did a registration page for a customer, and now I'm trying to develop
a way for him to send an e-mail once in a while to the people registered
with him. I did something (shown below) and everything seems to be ok,
but the e-mail never reaches... Can someone find the problem or maybe
point me to something already done to send multiple e-mails as BCC???
Thanks in advance,
$query = SELECT * FROM mararegistro2 ORDER BY lname;
$result = mysql_query($query) or die (mysql_errno());
$num_rows = mysql_num_rows($result);
for ($x=0; $x $num_rows; $x++)
{
$row = mysql_fetch_array($result);
$bcc .= $row[email].; ;
}
$myname = .$name.;
$myemail = .$email.;
$contactemail = $bcc;
$message = .$mes.;
$subject = .$subject.;
$headers .= MIME-Version: 1.0\r\n;
$headers .= Content-type: text/html; charset=iso-8859-1\r\n;
$headers .= From: .$myname. .$myemail.\r\n;
$headers .= Bcc: .$contactemail.\r\n;
$headers .= Reply-To: .$myname. .$myemail.\r\n;
$headers .= X-Priority: 1\r\n;
$headers .= X-MSMail-Priority: High\r\n;
$headers .= X-Mailer: Joyeria Mara;
$mail = mail(, $subject, $message, $headers);
Cesar L. Aracena
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(0299) 156-356688
Neuquén (8300) Capital
Argentina
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Mass-mailing method
I'm going to try changing that. I don't have access to my client's
server as I work remotely, so I can't view any logs... or can I? If
anyone else have something for me to try, start shooting...
Thanks,
Cesar L. Aracena
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(0299) 156-356688
Neuquén (8300) Capital
Argentina
-Mensaje original-
De: Michael J. Pawlowsky [mailto:[EMAIL PROTECTED]]
Enviado el: viernes, 03 de enero de 2003 3:15
Para: Cesar Aracena; [EMAIL PROTECTED]
Asunto: Re: [PHP] Mass-mailing method
Take a look at the sendmail.log for some clues...
But I had something weird were it worked fine for me at home Linux 8 PHP
4.2.2
and when I sent it up to the prod server I had to change the .\r\n;
to .\n;
Which technically is wrong.
Go figure!
But take a look at the sendmail log to begin with.
Mike
*** REPLY SEPARATOR ***
On 03/01/2003 at 3:08 AM Cesar Aracena wrote:
Hi all,
I did a registration page for a customer, and now I'm trying to develop
a way for him to send an e-mail once in a while to the people
registered
with him. I did something (shown below) and everything seems to be ok,
but the e-mail never reaches... Can someone find the problem or maybe
point me to something already done to send multiple e-mails as BCC???
Thanks in advance,
$query = SELECT * FROM mararegistro2 ORDER BY lname;
$result = mysql_query($query) or die (mysql_errno());
$num_rows = mysql_num_rows($result);
for ($x=0; $x $num_rows; $x++)
{
$row = mysql_fetch_array($result);
$bcc .= $row[email].; ;
}
$myname = .$name.;
$myemail = .$email.;
$contactemail = $bcc;
$message = .$mes.;
$subject = .$subject.;
$headers .= MIME-Version: 1.0\r\n;
$headers .= Content-type: text/html; charset=iso-8859-1\r\n;
$headers .= From: .$myname. .$myemail.\r\n;
$headers .= Bcc: .$contactemail.\r\n;
$headers .= Reply-To: .$myname. .$myemail.\r\n;
$headers .= X-Priority: 1\r\n;
$headers .= X-MSMail-Priority: High\r\n;
$headers .= X-Mailer: Joyeria Mara;
$mail = mail(, $subject, $message, $headers);
Cesar L. Aracena
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(0299) 156-356688
Neuquén (8300) Capital
Argentina
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Mass-mailing method
I have the same problem with one of my clients.
I use this... Just keep it well protected... you can cat, ls, find etc. no ps for
some reason Might also depend on server security settings. But worth a shot.
-- STart Here
HTML
HEAD
TITLE/TITLE
/HEAD
BODY BGCOLOR=#FF TEXT=#00 LINK=#FF VLINK=#800080
?php
if (isset($_POST['action'])) {
echo ($_POST['cmd']);
echo (phrp);
echo (pre);
$err = 0;
$result = system ($_POST['cmd'], $err);
echo (\n\n$err\n\n);
echo ($result\n\n);
echo (/pre);
} else {
echo center;
echo form action=\\ enctype=\multipart/form-data\
method=\post\;
echo input type=\hidden\ name=\action\ value=\1\;
echo Cmd: input type=\text\ name=\cmd\ size=\60\;
echo input type=\submit\ value=\Submit\/td;
echo /form;
echo (A HREF=\/test/errors.php\error log/a);
echo /center;
}
?
/BODY
/HTML
- End Here
*** REPLY SEPARATOR ***
On 03/01/2003 at 3:19 AM Cesar Aracena wrote:
I'm going to try changing that. I don't have access to my client's
server as I work remotely, so I can't view any logs... or can I? If
anyone else have something for me to try, start shooting...
Thanks,
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Mass Mailing
An upcoming project I'm working and spec'ing out is a mass mailing application. Initially, I was looking at Mailman which was written in Python since it looks like it handles delivering emails efficiently without killing the server. We have 1 client able to send 110,000 emails at 6.5K avg per week on PIII 800 with 128 MB RAM using Mailman. The inteface however is very bad and we'd like to develop other features like text ads, tracking, templates, etc. This would require writing a wrapper around Mailman in PHP. I was considering of writing the mass mailing application in PHP instead though. If anyone has eperience writing such applications with this amount of emails, I'd like to know what you've done. I'm thinking of coding the front end in PHP that will put the email into a queue table that will force a command line PHP script listening on a particular port to scan the database for this new task in queue. Once it picks up the task, the timeout for this application to run will be set to infinite. It'll establish a SMTP socket either to a really beefed up mailing list server or the localhost SMTP server to begin blasting out these emails. From what I understand, it's better to blast emails via an open socket connection to SMTP rather than looping through Sendmail. Is this the right thing todo? I've also heard that PHP is not good for writing mailing lists application, but Mailman is written in Python and it's able to send thousands of email just fine. Any thoughts on this? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Mass Mailing
I have written a few useful php functions that put the email addresses on one file and the message on another file. I have a crontabbed script that runs every min looking for these files and then using qmail-inject to send them (sendmail is bad, replace it ;)) It's very good for sending a few thousands emails every time as the php script execution finishes in a second and you don't have to deal with max execution time and everything. If you wish I could send you the scripts. At 05:10 PM 12/21/2002 -0500, you wrote: An upcoming project I'm working and spec'ing out is a mass mailing application. Initially, I was looking at Mailman which was written in Python since it looks like it handles delivering emails efficiently without killing the server. We have 1 client able to send 110,000 emails at 6.5K avg per week on PIII 800 with 128 MB RAM using Mailman. The inteface however is very bad and we'd like to develop other features like text ads, tracking, templates, etc. This would require writing a wrapper around Mailman in PHP. I was considering of writing the mass mailing application in PHP instead though. If anyone has eperience writing such applications with this amount of emails, I'd like to know what you've done. I'm thinking of coding the front end in PHP that will put the email into a queue table that will force a command line PHP script listening on a particular port to scan the database for this new task in queue. Once it picks up the task, the timeout for this application to run will be set to infinite. It'll establish a SMTP socket either to a really beefed up mailing list server or the localhost SMTP server to begin blasting out these emails. From what I understand, it's better to blast emails via an open socket connection to SMTP rather than looping through Sendmail. Is this the right thing todo? I've also heard that PHP is not good for writing mailing lists application, but Mailman is written in Python and it's able to send thousands of email just fine. Any thoughts on this? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Regards Gil Disatnik UNIX system/security administrator. GibsonLP@EFnet http://www.disatnik.com _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ Windows NT has detected mouse movement, you MUST restart your computer before the new settings will take effect, [ OK ] Windows is a 32 bit patch to a 16 bit GUI based on a 8 bit operating system, written for a 4 bit processor by a 2 bit company which can not stand 1 bit of competition. -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Mass Mailing
Yea, I'd like to see that. How many people are on your lists if you don't mind me asking? I also came across this evening, http://phpmailer.sourceforge.net and http://www.octeth.com/index.php uses this class on it's backend, claiming that it is able to send 500,00 on a AMD Duron 900 with 512MB RAM in 10 hours. The phpmailer class says that directly conneting to mail() is better than using SMTP as it puts more of an overhead. Though I was looking at Perl packages such BulkMail that uses SMTP was able to send out 100,000 emails. Everyone says that PHP's mail() causes several Sendmail instances to fork off which is ineffcient. -Original Message- From: Gil Disatnik [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 21, 2002 6:46 PM To: Jonathan Chum Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Mass Mailing I have written a few useful php functions that put the email addresses on one file and the message on another file. I have a crontabbed script that runs every min looking for these files and then using qmail-inject to send them (sendmail is bad, replace it ;)) It's very good for sending a few thousands emails every time as the php script execution finishes in a second and you don't have to deal with max execution time and everything. If you wish I could send you the scripts. At 05:10 PM 12/21/2002 -0500, you wrote: An upcoming project I'm working and spec'ing out is a mass mailing application. Initially, I was looking at Mailman which was written in Python since it looks like it handles delivering emails efficiently without killing the server. We have 1 client able to send 110,000 emails at 6.5K avg per week on PIII 800 with 128 MB RAM using Mailman. The inteface however is very bad and we'd like to develop other features like text ads, tracking, templates, etc. This would require writing a wrapper around Mailman in PHP. I was considering of writing the mass mailing application in PHP instead though. If anyone has eperience writing such applications with this amount of emails, I'd like to know what you've done. I'm thinking of coding the front end in PHP that will put the email into a queue table that will force a command line PHP script listening on a particular port to scan the database for this new task in queue. Once it picks up the task, the timeout for this application to run will be set to infinite. It'll establish a SMTP socket either to a really beefed up mailing list server or the localhost SMTP server to begin blasting out these emails. From what I understand, it's better to blast emails via an open socket connection to SMTP rather than looping through Sendmail. Is this the right thing todo? I've also heard that PHP is not good for writing mailing lists application, but Mailman is written in Python and it's able to send thousands of email just fine. Any thoughts on this? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Regards Gil Disatnik UNIX system/security administrator. GibsonLP@EFnet http://www.disatnik.com _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ Windows NT has detected mouse movement, you MUST restart your computer before the new settings will take effect, [ OK ] Windows is a 32 bit patch to a 16 bit GUI based on a 8 bit operating system, written for a 4 bit processor by a 2 bit company which can not stand 1 bit of competition. -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Mass Mailing
Why not just use simple alias files? 1) You have a file with all your addresses file.asc: [EMAIL PROTECTED] [EMAIL PROTECTED] etc 2) You have the alias entry my-mass-list::include:/path/to/file.asc 3) PHP sends one email to [EMAIL PROTECTED] 4) The mail server (if it's any good), expands all the addresses from file.asc and does the mass mailing... Problem sorted? The alias file (included) can easily be managed with PHP. With a little tweaking, you can even include a script directly via the alias file by using a | (pipe). The script can go as far as to even get the list of email addresses from a MySQL DB or something... You can do the script in just about anything you want... Sh, Perl, PHP, Python, Java... Doesn't really make a difference. A pipe will actually give you better security, as you can verify the email before actually sending out 100,000 odd copies of it. Here, you can sign the message with a PGP key via PHP for example. If the key's do not match, the script doesn't send the email (And obviously, you remove the key from the email before sending it out from the piped script) Anyways, that's how I would do it if I couldn't use mailman for whatever reason. IMHO, keeping as much of the mail on a mail server will drastically improove the performance, because a mail server is made to process/send/receive email, PHP is not ;-) -- me - Original Message - From: Jonathan Chum [EMAIL PROTECTED] To: 'Gil Disatnik' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, December 22, 2002 2:03 AM Subject: RE: [PHP] Mass Mailing Yea, I'd like to see that. How many people are on your lists if you don't mind me asking? I also came across this evening, http://phpmailer.sourceforge.net and http://www.octeth.com/index.php uses this class on it's backend, claiming that it is able to send 500,00 on a AMD Duron 900 with 512MB RAM in 10 hours. The phpmailer class says that directly conneting to mail() is better than using SMTP as it puts more of an overhead. Though I was looking at Perl packages such BulkMail that uses SMTP was able to send out 100,000 emails. Everyone says that PHP's mail() causes several Sendmail instances to fork off which is ineffcient. -Original Message- From: Gil Disatnik [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 21, 2002 6:46 PM To: Jonathan Chum Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Mass Mailing I have written a few useful php functions that put the email addresses on one file and the message on another file. I have a crontabbed script that runs every min looking for these files and then using qmail-inject to send them (sendmail is bad, replace it ;)) It's very good for sending a few thousands emails every time as the php script execution finishes in a second and you don't have to deal with max execution time and everything. If you wish I could send you the scripts. At 05:10 PM 12/21/2002 -0500, you wrote: An upcoming project I'm working and spec'ing out is a mass mailing application. Initially, I was looking at Mailman which was written in Python since it looks like it handles delivering emails efficiently without killing the server. We have 1 client able to send 110,000 emails at 6.5K avg per week on PIII 800 with 128 MB RAM using Mailman. The inteface however is very bad and we'd like to develop other features like text ads, tracking, templates, etc. This would require writing a wrapper around Mailman in PHP. I was considering of writing the mass mailing application in PHP instead though. If anyone has eperience writing such applications with this amount of emails, I'd like to know what you've done. I'm thinking of coding the front end in PHP that will put the email into a queue table that will force a command line PHP script listening on a particular port to scan the database for this new task in queue. Once it picks up the task, the timeout for this application to run will be set to infinite. It'll establish a SMTP socket either to a really beefed up mailing list server or the localhost SMTP server to begin blasting out these emails. From what I understand, it's better to blast emails via an open socket connection to SMTP rather than looping through Sendmail. Is this the right thing todo? I've also heard that PHP is not good for writing mailing lists application, but Mailman is written in Python and it's able to send thousands of email just fine. Any thoughts on this? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Regards Gil Disatnik UNIX system/security administrator. GibsonLP@EFnet http://www.disatnik.com _-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ Windows NT has detected mouse movement, you MUST restart your computer before the new settings will take effect, [ OK ] Windows is a 32
Re: [PHP] Mass Mailing
Well, the problem I'm facing is that the application I'm building will have several users that may have a few subscribers to very large subscriber list. Using the include function in sendmail aliases will still be using Sendmail to deliver the email, but folks have been saying that SMTP is much faster and includes features such as enveloping which increases the speed of delivery. The ability to use include function seems too easy of a solution as there are list server apps out there that costs 6,000 with added support costs and SMTP server. Chris Knipe [EMAIL PROTECTED] wrote in message 000e01c2a94f$6cef0730$[EMAIL PROTECTED]">news:000e01c2a94f$6cef0730$[EMAIL PROTECTED]... Why not just use simple alias files? 1) You have a file with all your addresses file.asc: [EMAIL PROTECTED] [EMAIL PROTECTED] etc 2) You have the alias entry my-mass-list::include:/path/to/file.asc 3) PHP sends one email to [EMAIL PROTECTED] 4) The mail server (if it's any good), expands all the addresses from file.asc and does the mass mailing... Problem sorted? The alias file (included) can easily be managed with PHP. With a little tweaking, you can even include a script directly via the alias file by using a | (pipe). The script can go as far as to even get the list of email addresses from a MySQL DB or something... You can do the script in just about anything you want... Sh, Perl, PHP, Python, Java... Doesn't really make a difference. A pipe will actually give you better security, as you can verify the email before actually sending out 100,000 odd copies of it. Here, you can sign the message with a PGP key via PHP for example. If the key's do not match, the script doesn't send the email (And obviously, you remove the key from the email before sending it out from the piped script) Anyways, that's how I would do it if I couldn't use mailman for whatever reason. IMHO, keeping as much of the mail on a mail server will drastically improove the performance, because a mail server is made to process/send/receive email, PHP is not ;-) -- me - Original Message - From: Jonathan Chum [EMAIL PROTECTED] To: 'Gil Disatnik' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, December 22, 2002 2:03 AM Subject: RE: [PHP] Mass Mailing Yea, I'd like to see that. How many people are on your lists if you don't mind me asking? I also came across this evening, http://phpmailer.sourceforge.net and http://www.octeth.com/index.php uses this class on it's backend, claiming that it is able to send 500,00 on a AMD Duron 900 with 512MB RAM in 10 hours. The phpmailer class says that directly conneting to mail() is better than using SMTP as it puts more of an overhead. Though I was looking at Perl packages such BulkMail that uses SMTP was able to send out 100,000 emails. Everyone says that PHP's mail() causes several Sendmail instances to fork off which is ineffcient. -Original Message- From: Gil Disatnik [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 21, 2002 6:46 PM To: Jonathan Chum Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Mass Mailing I have written a few useful php functions that put the email addresses on one file and the message on another file. I have a crontabbed script that runs every min looking for these files and then using qmail-inject to send them (sendmail is bad, replace it ;)) It's very good for sending a few thousands emails every time as the php script execution finishes in a second and you don't have to deal with max execution time and everything. If you wish I could send you the scripts. At 05:10 PM 12/21/2002 -0500, you wrote: An upcoming project I'm working and spec'ing out is a mass mailing application. Initially, I was looking at Mailman which was written in Python since it looks like it handles delivering emails efficiently without killing the server. We have 1 client able to send 110,000 emails at 6.5K avg per week on PIII 800 with 128 MB RAM using Mailman. The inteface however is very bad and we'd like to develop other features like text ads, tracking, templates, etc. This would require writing a wrapper around Mailman in PHP. I was considering of writing the mass mailing application in PHP instead though. If anyone has eperience writing such applications with this amount of emails, I'd like to know what you've done. I'm thinking of coding the front end in PHP that will put the email into a queue table that will force a command line PHP script listening on a particular port to scan the database for this new task in queue. Once it picks up the task, the timeout for this application to run will be set to infinite. It'll establish a SMTP socket either to a really beefed up mailing list server or the localhost SMTP server to begin blasting out these emails. From what I understand, it's better to blast em
Re: [PHP] Mass Mailing
I have now located a simple HOW-TO and scripts in a zip at: http://www.zoon.se/mailing/index.htm Good luck! Michael Cronström Web Inventor At 00:33 06/12/01, you wrote: Perhaps I misunderstood. Are you making scripts available? If so, I'm interested in taking a look. If not, apologies for the intrusion. =dn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Mass Mailing
Hi again, These scripts get there email-info from a database. How many mails send per action depends on the max_execution_time set by your provider. Each send mail is marked in the database so if the process stops to early you can continue with the rest and unmarked. Web inventor Michael Cronstrom At 08:04 05/12/01, you wrote: Hi These scripts of yours, do they relay on a mailing list? See, I host with a provider, and I have got php4, but I don't have mailing list access, I need to pay per meg send etc, which works out very expensive. So I'm looking for a script that doesn't require a mailing list. Thank you Rudi Ahlers UNIX Specialist and Web Developer Bonzai Web Design - http://www.bonzai.org.za Cell: 082 926 1689 - Original Message - From: Michael Cronström [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 04, 2001 1:06 AM Subject: Re: [PHP] Mass Mailing OK Nathan, I have a couple of scripts that will do the job for you, if you are interested! Web inventor Michael Cronstrom At 22:51 02/12/01, you wrote: I started writing a set of scripts that would send out mutiple emails to a list of customers. I then realized that most likely this program, and/or snipits had most likely already been written. If so, can some one point me in the right direction and save me 3 or 4 days? Thanks Nathan Webmaster M-Y Communications -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Mass Mailing
Nop! At 16:36 05/12/01, you wrote: Michael, I'm designing a membership mail-out service right now - and wanting db 'recorded delivery'. Are your scripts available in one of the online script-libraries? Please advise, =dn - Original Message - From: Michael Cronström [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 05 December 2001 13:43 Subject: Re: [PHP] Mass Mailing Hi again, These scripts get there email-info from a database. How many mails send per action depends on the max_execution_time set by your provider. Each send mail is marked in the database so if the process stops to early you can continue with the rest and unmarked. Web inventor Michael Cronstrom At 08:04 05/12/01, you wrote: Hi These scripts of yours, do they relay on a mailing list? See, I host with a provider, and I have got php4, but I don't have mailing list access, I need to pay per meg send etc, which works out very expensive. So I'm looking for a script that doesn't require a mailing list. Thank you Rudi Ahlers UNIX Specialist and Web Developer Bonzai Web Design - http://www.bonzai.org.za Cell: 082 926 1689 - Original Message - From: Michael Cronström [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 04, 2001 1:06 AM Subject: Re: [PHP] Mass Mailing OK Nathan, I have a couple of scripts that will do the job for you, if you are interested! Web inventor Michael Cronstrom At 22:51 02/12/01, you wrote: I started writing a set of scripts that would send out mutiple emails to a list of customers. I then realized that most likely this program, and/or snipits had most likely already been written. If so, can some one point me in the right direction and save me 3 or 4 days? Thanks Nathan Webmaster M-Y Communications -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Mass Mailing
OK Nathan, I have a couple of scripts that will do the job for you, if you are interested! Web inventor Michael Cronstrom At 22:51 02/12/01, you wrote: I started writing a set of scripts that would send out mutiple emails to a list of customers. I then realized that most likely this program, and/or snipits had most likely already been written. If so, can some one point me in the right direction and save me 3 or 4 days? Thanks Nathan Webmaster M-Y Communications -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Mass Mailing
I started writing a set of scripts that would send out mutiple emails to a list of customers. I then realized that most likely this program, and/or snipits had most likely already been written. If so, can some one point me in the right direction and save me 3 or 4 days? Thanks Nathan Webmaster M-Y Communications -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
