Vyoma
Jan 3 2006, 04:58 AM
| | Task: To send an email to a list of email addresses stored in a database
Premise: Page is written in PHP, with the database as MySQL. The email addresses need to be taken from a column of a table in the database which is queried with some "WHERE" clause. The email sent to these addresses is static.
Objective: To send a newsletter to the members who have subscribed for the same on a website.
Well, there. I have put it as objectively and as clearly as possible. I have searched for the keywords "mail" and "PHP" on this section of the forum, and from what I have seen, it is possible to mail to an address. But is it possible to send it to a list of them? I mean, if I could get the addresses seperated by ';'. Or is there some other way? What I am trying to achieve is to send newsletters. For now, I would be satisfied with a static content. Later I would like to venture into the possibility of dynamic content. But may be for that, we need to handle each address one by one. |
Comment/Reply (w/o sign-up)
Houdini
Jan 3 2006, 05:21 AM
Here are some links to some free scripts you night find of interest. On of these does not use a database but a textfile. http://phpmailer.sourceforge.net/http://www.davelozinski.com/scripts/mail_l...p?1136265340578This is the one that uses a textfile instead of a database to possibly achieve what you want. http://www.biegelscripts.com/index.php?a=6&t=2&l=0
Comment/Reply (w/o sign-up)
Vyoma
Jan 3 2006, 08:51 AM
Well, Houdini. The first link itself hit the jackpot - or so I think. I still will not be implementing it practically, I just wanted to get my design docs proper before going ahead for the implementation. So, I wanted to see, atleast in theory, if it were possible. I am a bit bad with the searches and could not get anything proper. The second one is a mailing list one, which I quite extensive, and packaged. It would not be of much use to me. The third one was way overwhelming for me!  As I said, thanks!
Comment/Reply (w/o sign-up)
Hercco
Jan 5 2006, 02:33 PM
QUOTE(Vyoma @ Jan 3 2006, 06:58 AM) But is it possible to send it to a list of them? I mean, if I could get the addresses seperated by ';'. Or is there some other way? What I am trying to achieve is to send newsletters. For now, I would be satisfied with a static content. Later I would like to venture into the possibility of dynamic content. But may be for that, we need to handle each address one by one. You just need to iterate, ie. loop through the list of addresses and call mail() for each. And by this way making the email dynamic such as saying "Hey, [name]!" on the begining is really easy too. Just use a messafe templae of which you will process in the loop, replaceing the keywords such as [user] with the appropriate content from the database. Naturally there are many ways to do it, so use what you feel most comfortable with. Just adding text to beginng and end of the message is easiest route. And since you're working with mail() don't forget to study documentation on how you should build the message headers. It's lot more "professional" to send automatically generated mail with proper headers. If I remember correctly, PHP documentation (or comments) has realyl nice info on headers, including examples.
Comment/Reply (w/o sign-up)
Vyoma
Jan 6 2006, 04:17 AM
Come to think of it, Hercco, I think I should go by your method. It is the most straight forward method, that right out missed my mind. Ha! This is fine example of how one gets lost in the complexity and fails to see all simple solutions. Thanks Hercco.
Comment/Reply (w/o sign-up)
Alexandre Cisneiros
Jan 29 2006, 01:12 AM
Hi! I found this Newsletter System, based on TXT files, not MySQL. It is VERRY simple. Here is the instructions: ----------------------------------------------
|### Newsletter System 1.0 L.E. ###|
----------------------------------------------
Leandro Maniezo
lemaniezo@ig.com.br
TRANSLATION FROM PORTUGUESE-BR TO ENGLISH:
Alexandre Cisneiros Filho
misteryoshi@gmail.com
Introduction
----------
- Put line-by-line the adresses on the file emails_bd.txt.
- Set the permitions of the txt files to be writebly.
- After sendin, all the adresses who recived the message are stored at log.txt.
- If some people dont recive the message, deleta all adresses on the file emails_bd that are in log.txt and send again.
Instaling
----------
- Put all the files in a folder on the site and set the permitions to the TXT files.
Obs.: NO Javascript allowed.
If you want to send images, you need to host them.
Just download the attached file!
Comment/Reply (w/o sign-up)
TavoxPeru
Aug 24 2006, 10:17 PM
QUOTE(Alexandre Cisneiros @ Jan 28 2006, 08:12 PM) 
Hi! I found this Newsletter System, based on TXT files, not MySQL. It is VERRY simple. Here is the instructions:
----------------------------------------------
|### Newsletter System 1.0 L.E. ###|
----------------------------------------------
Leandro Maniezo
lemaniezo@ig.com.br
TRANSLATION FROM PORTUGUESE-BR TO ENGLISH:
Alexandre Cisneiros Filho
misteryoshi@gmail.com
Introduction
----------
- Put line-by-line the adresses on the file emails_bd.txt.
- Set the permitions of the txt files to be writebly.
- After sendin, all the adresses who recived the message are stored at log.txt.
- If some people dont recive the message, deleta all adresses on the file emails_bd that are in log.txt and send again.
Instaling
----------
- Put all the files in a folder on the site and set the permitions to the TXT files.
Obs.: NO Javascript allowed.
If you want to send images, you need to host them.
Just download the attached file!
Thanks dude, a lot of time i waste searching something like this, is very simple, and also it demostrates me what i was doing bad in my script. best regards,
Comment/Reply (w/o sign-up)
NoMore
Nov 11 2006, 08:51 AM
i havnt readed what you all wrote but my way is to put the mails in an array and send it in a while of a simple mail function, that way ppl cant see who wlse the mail sent to - you can create a log file to see how much it send and match it with mails so you can see how it works NoMore
Comment/Reply (w/o sign-up)
TavoxPeru
Nov 12 2006, 08:56 AM
QUOTE(NoMore @ Nov 11 2006, 03:51 AM)
i havnt readed what you all wrote but my way is to put the mails in an array and send it in a while of a simple mail function, that way ppl cant see who wlse the mail sent to
- you can create a log file to see how much it send and match it with mails so you can see how it works
NoMore
Well, i use a database to store my mailing list and its about 3000 records right now, and to send it i do the same thing as you, but i noticed that this doesnt work because no mail is send and also i test it with a little list of 10 records, so i gonna try the use of an array instead maybe this way it works. Best regards,
Comment/Reply (w/o sign-up)
Aka_Bar
Nov 12 2006, 05:38 PM
some question to Administrators it is about Mailer i have PhpMailer and i dont know why, every time when im uploading it to hosting and using it for my needs, hosting prividers tellingmi to delete script and also ur account wll be deleted!!! can anyone answer me? why they doing so? im not spamer im just using it for like send News to members or for more ellection!
Comment/Reply (w/o sign-up)
NoMore
Nov 15 2006, 05:10 AM
no limitaion for mailing list becose its a script! server cant control scripts and database that "mailman" runs his own server, so he get to set the limitaion, and he put the limitaion to OFF, so he send LOTS of mails witout geting kicked out or blooked on the server but u can be smarter than the server easly, learn to use imap, and sent mail with smtp server, than the really apache server mailing limitaion cant take control over your mailin  i really like to use imap myself , may be my next thing to learn NoMore
Comment/Reply (w/o sign-up)
TavoxPeru
Nov 15 2006, 03:33 AM
QUOTE(NoMore @ Nov 12 2006, 03:03 PM) well, this is why TavoxPeru script dont work (i think) and answer to Aka_Bar Hosting servers and mostly free hosting servers limit massive mailing in PHP or even disable mailing in PHP all this doe to spamers, server, and agine, mostly free servers cant chack every singel user, if he is spaming or not! and if thay will do so, thay will have to read your mail and this is simply WRONG!! i am sure you dont want server admins to read your mail and i dont think this is even posible anyone here can be a mail spamer without anyone know it, and hackers sometimes use mailing system witch is unsecured and send mail spam with that script that created for privet use/none spam use those are the main resons why servers limits the mail function or massive mailing! and, now, why mostly free hostings? well, free hostings have register pages or forums, thay are not talking to the user, and the user can use the hosting in anyway he like and when he like but on paid host, the user PAY for the hosting and dont want it to close, so he will not send spam when he know that server owners can find out and kick him from the server and that was 60 sec about Hosting Servers and Mail Function NoMore Well, I understand and agree with the reasons you expose for hostings to do that to control spamming, but why this situation doesnt happens with the mailman that runs mailing lists??? is there a limit of how many emails one mailing list can have???? Best regards,
Comment/Reply (w/o sign-up)
Similar Topics
Keywords : sending, mail, mailing, list, possibility, sending, newsletter
- Using Php With A Mail Server
(2)
PHP: Need Help Sending Mail Using SMTP
(5) While the mail() function of php is all bout simplicity, it lacks the otherwise necessary
flexibility. How do I send an E-Mail using php through SMTP?....
Php Send Mail Through Smtp
(10) Can anyone here tell me how to send mail through SMTP server with php /mellow.gif"
style="vertical-align:middle" emoid=":mellow:" border="0" alt="mellow.gif" /> I have search in many
source code on web and cant find anything /sad.gif" style="vertical-align:middle" emoid=":("
border="0" alt="sad.gif" />....
E-mail List Error
(4) I just coded this e-mail list, it works well for entering data into database, but if user leaves
the field blank or adds an already exist e-mail it gives him the error message and stops loading the
rest of the page. CODE // Connects to your Database mysql_connect("localhost", "my_username",
"mypassword") or die(mysql_error()); mysql_select_db("Database name") or die(mysql_error()); //This
code runs if the form has been submitted if (isset($_POST )) { //This makes sure they did not leave
any fields blank if (!$_POST ) {die(' No e-mail added '); } ....
Using The Php Mail() Function For Images Or Attachments
Can't find a decent tutorial! (6) I read the one mail() tutorial that was posted in the tutorial section and to my horror found that
he had quoted almost verbatim from the PHP Manual off php.net, and made a comment about it, and also
found that if you were new to PHP or the Manual that it was informative but not indepth enough for
my tastes. This is not a tutorial although with the code that will be posted it might look like
one, that is not its intent or purpose. I have searched and found many so called tutorials about
MIME mail and boundries and all that but basically it either told me to use PHPMai....
Simple E-mail Validation
check for correct address and syntax (2) Hey , this tutorial will tell you a very simple way to check if email addresses entered are with the
correct syntax. Hope this will help you eliminate jokers. So this script will... (check the
characters, and check if there is a " someone somewhere.extension ". Ok, so firstly we create a
function with all the invalid stuff in it:- CODE function CheckMail($email) { if (eregi("^ ( ?
)*@ ( ? )*\. {2,4}$", $email)) { return true; } else { return false; } } Now, to check an
email you just run the variable with the email in it through the function as follow....
Do You Want A Mail Form In Your Site
(2)
Notice from m^e:
Repeat post. Credits reduced by 5 days. Learn to USE
THE SEARCH BUTTON before you make such posts.
did you want to have in your web site mail form
that allow the user to send mails to anther mail from his mail e.g. the compose in yahoo CODE
from to cc bcc subject
function param($Name) { global
$HTTP_POST_VARS; if(isset($HTTP_POST_VARS )) return($H....
Form Mail Php - Use Php To Send Form Through Email
(8) Just sends all form data to a specified email. Does anyone know a free script that does this?....
Mail() Not Working
(4) I'm trying to use the mail() function in a script. But it doesnt work. It keeps returning false.
It's a premade script The code is: CODE function SendPassword($userName) { global
$db,$db_tables;//config.php // set password for username to a random value // return the new
password or false on failure $new_password = mt_rand(); $qry = "UPDATE $db_tables SET
password=password('$new_password') WHERE user_name='$userName'";
$db->db_query($qry); // send notification email $from = "From: $from_email\r\n";
$msg = "....
How To Set Up Form Mail
(4) I am programming on a web site's contact form page, How can I mail the filled in information of
the client to particular E-mail address? I tried form action="mailto:blah@blah", but it is running
all right on my machine rather that other computer in our LAN. The error message I got is a
connection failure error occurred. I noticed there are some form mail info on line, but I have no
idea to figure out how is that works. Anybody have some experience on that? Thanks!....
Looking for sending, mail, mailing, list, possibility, sending, newsletter
|
See Also,
*SIMILAR VIDEOS*
Searching Video's for sending, mail, mailing, list, possibility, sending, newsletter
|
advertisement
|
|
