mass email project
Author Message
jomasaco
Respected Member


Posts: 19
Joined: May 2010
Post: #1
mass email project
0
0
Found this code and looks an good start to do an mass email script.
changing the country can be used to send to white/black/webmaster/all whatever






<span class="syntaxdefault"><?php
</span><span class="syntaxkeyword">include(</span><span class="syntaxstring">"dbconnection.php"</span><span class="syntaxkeyword">);
</span><span class="syntaxdefault">***if*</span><span class="syntaxkeyword">(!isset(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'submit'</span><span class="syntaxkeyword">])):
</span><span class="syntaxdefault">?>
</span>
<html>
<head>
<title>Mailing*List</title>
</head>

<body>

<form*method="post"*action="<span class="syntaxdefault"><?=$_SERVER</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'PHP_SELF'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault">?></span>">
<table*align="center"*bgcolor="#D6DEE7"*border="0"*cellpadding="0"*cellspacing="0">
<tr>
<td*align="center">
[b]<h2>MAILING*LIST*ADMIN</h2>[/b]


Send*message*to:
<select*name="to"*size="1"*style="background-color:*#F7F7F7">
<option*selected*value="all">Entire*list
<option*value="notall">By*country
</select>

Country:
<select*name="country"*size="5">
<OPTION*value="Argentina">Argentina
<OPTION*value="Bolivia">Bolivia
<OPTION*value="Brazil">Brazil
<OPTION*value="Chile">Chile
<OPTION*value="Colombia">Colombia
<OPTION*value="Costa*Rica">Costa*Rica
<OPTION*value="Ecuador">Ecuador
<OPTION*value="Guatemala">Guatemala
<OPTION*value="Honduras">Honduras
<OPTION*value="Mexico">Mexico
<OPTION*value="Nicaragua">Nicaragua
<OPTION*value="Panama">Panama
<OPTION*value="Paraguay">Paraguay
<OPTION*value="Peru">Peru
<OPTION*value="Puerto*Rico">Puerto*Rico
<OPTION*value="Rep.*Dominicana">Rep.*Dominicana
<OPTION*value="Uruguay">Uruguay
<OPTION*value="Venezuela">Venezuela
</select>

Title*or*Subject:*<input*name="subject"*type=text*maxlength=100*size=40>
Message:
<textarea*wrap*name="message"*rows=10*cols=45></textarea>
<input*type=submit*name="submit"*value="SUBMIT">
</td>
</tr>
</table>
</form>
</body>
</html>

<span class="syntaxdefault"><?php*else</span><span class="syntaxkeyword">:

</span><span class="syntaxdefault">**$to*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'to'</span><span class="syntaxkeyword">];
</span><span class="syntaxdefault">**$subject*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'subject'</span><span class="syntaxkeyword">];
</span><span class="syntaxdefault">**$message*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'message'</span><span class="syntaxkeyword">];
</span><span class="syntaxdefault">**$country*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'country'</span><span class="syntaxkeyword">];

</span><span class="syntaxdefault">**if*</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"all"</span><span class="syntaxdefault">*</span><span class="syntaxkeyword">==</span><span class="syntaxdefault">*$to</span><span class="syntaxkeyword">)</span><span class="syntaxdefault">*</span><span class="syntaxkeyword">{
</span><span class="syntaxdefault">***$x*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*1</span><span class="syntaxkeyword">;
</span><span class="syntaxdefault">***$hold*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*50</span><span class="syntaxkeyword">;</span><span class="syntaxdefault">*</span><span class="syntaxcomment">//*quantity*of*emails*sent*before*3*sec*delay
</span><span class="syntaxdefault">***$emails*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"SELECT*email*FROM*members"</span><span class="syntaxkeyword">);
</span><span class="syntaxdefault">***while*</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$sendemail*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*mysql_fetch_array</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$emails</span><span class="syntaxkeyword">))</span><span class="syntaxdefault">*</span><span class="syntaxkeyword">{
</span><span class="syntaxdefault">***$email*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*$sendemail</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"email"</span><span class="syntaxkeyword">];
</span><span class="syntaxdefault">***mail</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$email</span><span class="syntaxkeyword">,</span><span class="syntaxdefault">*$subject</span><span class="syntaxkeyword">,
</span><span class="syntaxdefault">***$message</span><span class="syntaxkeyword">,</span><span class="syntaxdefault">*</span><span class="syntaxstring">"From:Your*name*<[email protected]>"</span><span class="syntaxkeyword">);

</span><span class="syntaxdefault">***$x</span><span class="syntaxkeyword">++;
</span><span class="syntaxdefault">****if</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$x*</span><span class="syntaxkeyword">==</span><span class="syntaxdefault">*$hold</span><span class="syntaxkeyword">)</span><span class="syntaxdefault">*</span><span class="syntaxkeyword">{</span><span class="syntaxdefault">*</span><span class="syntaxcomment">//*When*$x*is*equal*to*$hold,*a*3*sec*delay*will*occur*avoiding*php*to*timeout
</span><span class="syntaxdefault">****sleep</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">3</span><span class="syntaxkeyword">);
</span><span class="syntaxdefault">****$x*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*0</span><span class="syntaxkeyword">;
</span><span class="syntaxdefault">****</span><span class="syntaxkeyword">}
</span><span class="syntaxdefault">***</span><span class="syntaxkeyword">}</span><span class="syntaxdefault">*</span><span class="syntaxcomment">//*end*of*while*loop
</span><span class="syntaxdefault">**</span><span class="syntaxkeyword">}</span><span class="syntaxdefault">*else*</span><span class="syntaxkeyword">{
</span><span class="syntaxdefault">***$bycountry*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"SELECT*email*FROM*members*WHERE*country*=*'$country'"</span><span class="syntaxkeyword">);
</span><span class="syntaxdefault">***while*</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$countmail*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*mysql_fetch_array</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$bycountry</span><span class="syntaxkeyword">))</span><span class="syntaxdefault">*</span><span class="syntaxkeyword">{
</span><span class="syntaxdefault">***$email*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*$countmail</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"email"</span><span class="syntaxkeyword">];
</span><span class="syntaxdefault">***$okemail*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*mail</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$email</span><span class="syntaxkeyword">,</span><span class="syntaxdefault">*$subject</span><span class="syntaxkeyword">,
</span><span class="syntaxdefault">***$message</span><span class="syntaxkeyword">,</span><span class="syntaxdefault">*</span><span class="syntaxstring">"From:Your*name*<[email protected]>"</span><span class="syntaxkeyword">);

</span><span class="syntaxdefault">***$x</span><span class="syntaxkeyword">++;
</span><span class="syntaxdefault">****if</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$x*</span><span class="syntaxkeyword">==</span><span class="syntaxdefault">*$hold</span><span class="syntaxkeyword">)</span><span class="syntaxdefault">*</span><span class="syntaxkeyword">{</span><span class="syntaxdefault">*</span><span class="syntaxcomment">//*When*$x*is*equal*to*$hold,*a*3*sec*delay*will*occur*avoiding*php*to*timeout
</span><span class="syntaxdefault">****sleep</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">3</span><span class="syntaxkeyword">);
</span><span class="syntaxdefault">****$x*</span><span class="syntaxkeyword">=</span><span class="syntaxdefault">*0</span><span class="syntaxkeyword">;
</span><span class="syntaxdefault">****</span><span class="syntaxkeyword">}
</span><span class="syntaxdefault">***</span><span class="syntaxkeyword">}</span><span class="syntaxdefault">*</span><span class="syntaxcomment">//*end*of*while*loop
</span><span class="syntaxdefault">**</span><span class="syntaxkeyword">}
</span><span class="syntaxdefault">?>
</span><html>
<head>
</head>
<body>
SUCCESS!
</body>
</html>
<span class="syntaxdefault"><?php*endif</span><span class="syntaxkeyword">;</span><span class="syntaxdefault">*?></span>
08-31-2010 12:48 PM
c0rrupt
Administrator


Posts: 251
Joined: Mar 2010
Post: #2
mass email project
0
0
you need PHP file dbconnection.php for this to work

Be sure to visit WCDDL.org Affiliates
09-06-2010 06:07 PM
jomasaco
Respected Member


Posts: 19
Joined: May 2010
Post: #3
mass email project
0
0
dbconnection.php are the funcs.php
are the settings to conect to the db host,user,db,pass
if converted in module not needed


to select distinct emails from all tables i guess this will work, don't now if can use multiple UNION to separeted tables use DISTINCT no doubled emails.
Quote: if ("all" == $to) {
$x = 1;
$hold = 50; // quantity of emails sent before 3 sec delay
$emails = mysql_query("SELECT email FROM members");

[code=php:hek8zcvj]<span class="syntaxdefault"> if </span><span class="syntaxkeyword">(</span><span class="syntaxstring">"all"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">==</span><span class="syntaxdefault"> $to</span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{
</span><span class="syntaxdefault">   $x </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> 1</span><span class="syntaxkeyword">;
</span><span class="syntaxdefault">   $hold </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> 50</span><span class="syntaxkeyword">;</span><span class="syntaxdefault"> </span><span class="syntaxcomment">// quantity of emails sent before 3 sec delay
</span><span class="syntaxdefault">   $emails </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"SELECT email FROM sites UNION SELECT email FROM whitelist UNION ...bla​cklist....webmasters...);</span>[/code:hek8zcvj]
09-09-2010 09:43 AM


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  PHP: Sending Email (Text/HTML/Attachments) tutorial c0rrupt 0 143 01-30-2011 09:23 PM
Last Post: c0rrupt



User(s) browsing this thread: 1 Guest(s)

This forum uses Lukasz Tkacz MyBB addons.