Snippets

Home / Snippets / Mass Email from MySQL DB

Mass Email from MySQL DB

Snippet Menu

snippet |

revisions |

comments | Related Snippets

related |

Add to Favorites | Email

download | Print

print | Blog It

blog it

Wed. Feb. 28th, 2007 3:41 PM

1 of 1

mjlintz

PHP

1 comments

Mass email list of email addresses from a mysql db table.

<html>

<head>

<title></title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>

<?php

include './inc/config.inc.php';

?>

<?

if (isset($_POST['submit']))

{

        $subject = $_POST['subject'];

        $message = $_POST['message'];

        $query="SELECT email FROM users_test";  //Change users_test to users

        $result=mysql_query($query);

        $num=mysql_num_rows($result);

        $i=0;

        while ($i < $num) 

        {

                $email=mysql_result($result,$i,"email");

                mail($email, $subject, $message, "From: Someone<someone@somewhere.com>\nX-Mailer: PHP/" . phpversion());

                echo "Email sent to: " . $email . "<br />";

                $i++;

        }

}

?>

<br />

<form name="email" action="<?=$_SERVER['email.php']?>" method="post">

Subject

<br />

<input name="subject" type="text" size="50" id="subject"><br /><br />

Message

<br />

<textarea name="message" cols="50" rows="10" id="message"></textarea>

<br /><br />

<input type="submit" name="submit" value="Email!">

</body>

</html>