PDA

View Full Version : want to create a sql database driven newsletter



pkcidstudio
07-17-2006, 10:26 PM
so long title I know, sorry about that.
I want to go ahead and create a database newsletter, which shouldn't be to hard. any thoughts though as to a particular script that it am going to want to use so I don't have to leave my browser open when sending my newsletter out to thousands. perhaps if it only had to be open for a few minutes or even seconds after I hit send that would be great.
thoughts or tutorials on any part of this idea.

jr_yeo
07-17-2006, 10:36 PM
thought this (http://www.php-mysql-tutorial.com/connect-to-mysql-using-php.php) might help :D

pkcidstudio
07-19-2006, 06:10 PM
anyone have thoughts on if i want to allow my desiner to take his html and css and paste into a field, and than have that field be what is read and sent out? i can simply take the field in a php setting and of something like this.


// newsletter
if (isset($_POST['nl'])) {
$message .= "\nwhatGoesHere\n";
$message .= $_POST['nl'];
$message .= "\n";

}

and then chase it up with something like this


$headers = "From: {$_POST['myCompany']}\n";
$headers .= "Reply-to: {$_POST['mycompany@consumer.com']}\n";

mail("somesort of sql database", "subject", $message);

anythoughts? am i on the right page? just wondering on how i put that html into place of the newsletter and allow php to read it to send it out?
thankx guys.

Wucwir
08-02-2006, 10:26 AM
Good news