|
|
(#1)
|
|
|||
|
mass email project -
08-31-2010, 05:48 PM
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 Code:
<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">
<h2>MAILING*LIST*ADMIN</h2>
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>
|
|
(#2)
|
|
(#3)
|
|
|||
|
Re: mass email project -
09-09-2010, 02:43 PM
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:
</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*UNIO N*SELECT*email*FROM*whitelist*UNION*...blacklist.. ..webmasters...);</span>[/code:hek8zcvj] |
| Bookmarks |
|
| Tags |
| email, mass, project |
| Thread Tools | |
| Display Modes | |
|
|