Hmm ... I'd like to send am email to 200 persons at a time, and there is a chance that an email will turn up twice or even more times since I allow 1 email for many accounts.Danoontje wrote:make a small while loop in php...this has some downsides tho... make sure u use correct headers. and have decent mailserver to keep up with the loop, if you want a simple code lemme know.
momo61 wrote:Hmm ... I'd like to send am email to 200 persons at a time, and there is a chance that an email will turn up twice or even more times since I allow 1 email for many accounts.Danoontje wrote:make a small while loop in php...this has some downsides tho... make sure u use correct headers. and have decent mailserver to keep up with the loop, if you want a simple code lemme know.
I'd appreciate it if you could share a code for that
Code: Select all
SELECT distinct(email) FROM accounts;no offence to you, but that seems kinda ... i dont know. It requests my db password and name. I don't think that's necessary. All I want to do is to add the emails and send out one message to all.neo25 wrote:You can use this since it's really easy and all you have to do is plug in the variables like DB name, DB user, Table and Column for users and e-mails. You might have to make a few small code changes to customize it to your needs but I'm sure it would be a small amount if any.
http://www.hotscripts.com/listing/simpl ... der-89526/
Haven't looked at the script yet but... how is it going get the data from the table if the database is password protected?..momo61 wrote:It requests my db password and name. I don't think that's necessary.
No, i mean, its not necessary to provide my password for simply sending out emails, and I dont want any script to have access to any table of the database.Copyleft wrote:Haven't looked at the script yet but... how is it going get the data from the table if the database is password protected?..momo61 wrote:It requests my db password and name. I don't think that's necessary.
Code: Select all
while ($query = mysql_fetch_array($resultquery)) { $emailinfo=$myemail; $mailto=$query[$table_email]; mail($mailto, $subject, $messagesend , "From:".$fromadmin."\nReply-To:".$fromadmin."\n"); echo 'Mail sent to '.$mailto.'<br>'; sleep($seconds); }If you dont provide the connection data to the script how are you going to parse the emails?momo61 wrote:No, i mean, its not necessary to provide my password for simply sending out emails, and I dont want any script to have access to any table of the database.Copyleft wrote:Haven't looked at the script yet but... how is it going get the data from the table if the database is password protected?..momo61 wrote:It requests my db password and name. I don't think that's necessary.
start by not using rootyou must first try to explain him how to correctly setup access rights and how to create new user maybeDrHouse wrote:If you dont provide the connection data to the script how are you going to parse the emails?
BTW looks like now you are concerned on security
I know how to correctly setup access rights. I use multiple users for various things and scripts, so there's no problem there. What I could do is download all the accounts table, and then delete all the account info except for the email. I'd then install it on my home-PC and send out the email.Aikimaniac wrote:you must first try to explain him how to correctly setup access rights and how to create new user maybeDrHouse wrote:If you dont provide the connection data to the script how are you going to parse the emails?
BTW looks like now you are concerned on security