Sending a newsletter with Mail

travisco87 · September 25, 2014

Hello all! I am trying to send mail using the "Mail.php" function but I cant figure out whats going wrong. The insert function works in the database but not the sending mail function. Please let point me in the right direction, thanks for your help in advance!

<?php
    if(isset($_POST)){
//If the post is not empty, continue
        if(!empty($_POST)) {
            include_once 'includes.php';
            require_once 'Mail.php';
            $from = "Name <[email protected]>";
            $subject = $_POST['subject'];
            $text = $_POST['newsletterBody'];
            $host = "host";
            $port = "port";
            $username = "EMAILUSERNAME";
            $password = "EMAILPASSWORD";
            echo "Subject: " . $subject;
            echo "<br />Body: " . $text;
            echo "<br />Host: " . $host;
            echo "<br />Port: " . $port . "<br />";
            $sql = 'INSERT INTO newsletter_log (date,title,body) VALUES (:time,:subject,:body)';
            $params = array(
                        ':subject' => $subject,
                        ':body' => $text,
                        ':time' => time());
            $poststmt = $DBH->prepare($sql);
            $poststmt->execute($params);
            if($poststmt)
            {
                echo "Saved to the database.";
                
            }
            else {
                echo "Not saved.";
            }
            $sqlSubUsers = 'SELECT * FROM test_newsletter WHERE newsletter_id = 1';
            $newsletterStmt = $DBH->prepare($sqlSubUsers);
            $newsletterStmt->execute();
            $userIds = $newsletterStmt->fetch(PDO::FETCH_ASSOC);
            echo $userIds;
            foreach ($userIds as $row){
                $getUserEmailSql = 'SELECT email_addr FROM newsletter_emails WHERE id =' . $row['people_id'];
                $getUserEmailStmt = $DBH->prepare($getUserEmailSql);
                $getUserEmailStmt->execute();
                $userEmail = "<" . $getUserEmailStmt->fetch(PDO::FETCH_COLUMN,0) . ">";
                $userEmail->closeCursor();
                $html = "<html><body>" . $text . "</html></body>";
                $headers = array ('From' => $from,
                              'To' => $userEmail,
                              'Subject' => $subject);
                $smtp = Mail::factory('smtp',
                                  array ('host' => $host,
                                         'port' => $port,
                                         'username' => $username,
                                         'password' => $password));        
            $mail = $smtp->send($to, $headers, $html);
            echo $userEmail;
            if (PEAR::isError($mail)) {
                echo("<p>" . $mail->getMessage() . "</p>");
            } else {
                echo("<p>Message successfully sent!</p>");
            }
        }
     echo 'Newsletter Sent.';
} else {
        echo '<h3>No newsletter was sent.</h3>';
    }
}
?>

I have removed the emails, host, port, username and password along with in other information I did not think I should send over.

davidannis · September 26, 2014

Does it print an error message?

Does it print "Message successfully sent!"?

Is php error reporting on? (If not, put this at the top of your php file:)

error_reporting(E_ALL);
ini_set("display_errors", 1);

Sign In

Sending a newsletter with Mail

Recommended Posts

travisco87

Link to comment

Share on other sites

davidannis

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information