dongmoxin7111 2016-05-11 14:56
浏览 49
已采纳

为什么PHP Mailer并不总是发送电子邮件?

We have a site with a form that when submitted, does the following (via the code below);

  1. Sends a test email to myself BEFORE INSERTING INTO MYSQL just so i know php mailer is working, which it always does in all my tests

  2. Then inserts all the data from the form into MYSQL (This always works too)

  3. Send another email via PHP Mailer with all the info they submitted. I want it in plain text (this works only about 80% of the time).

What's happening is, sometimes people submit and it does everything, but sometimes it only does steps 1 and 2. So sometimes, something seems to be breaking somewhere. I feel like it could be issues with certain punctuation, but not sure. Like in the $copy fields, people can enter whatever they want. Not sure if there are certain punctuations that could break the 2nd email process.

NOTE: Every time someone submits, it does take them to the request-success.php page. But it doesn't always send the email from Step 3.

If anyone sees areas of improvement, or things that are just wrong, please share. This is driving me insane.

 <?php
    session_start();
    include_once("config.php");
    include_once("includes/functions.php");
    require 'phpmailer/PHPMailerAutoload.php';
    //database configuration & connection (hiding for privacy purposes, but the database connections work fine so not relevant

    if ($_POST['submit']) {

        $type=$_POST['type'];

        $category= substr($type, 0, strpos($type, ' -'));
        $category= strtolower($category);
        $category= ucfirst($category);
        $need = substr($type, strpos($type, "-") + 1);    

        $subject="REQUEST for " . $type;
        $fullname= $_SESSION['google_data']['name'];
        $fromemail=$_SESSION['google_data']['email'];

        $brands=$_POST['brand'];

        $size=$_POST['size'];
        if ($size == "") {
            $size="n/a";
        }
        $bleed=$_POST['bleed'];
        if ($bleed =="no") {
            $bleedsize="n/a";
        } else {
            $bleedsize=$_POST['bleedsize'];
        }
        $filetype=$_POST['filetype'];
        if ($filetype=="") {
            $filetype="n/a";
        }
        $footerurl=$_POST['footer-url'];
        if ($footerurl=="") {
            $footerurl="n/a";
        }
        $footerphone=$_POST['footer-phone'];
        if ($footerphone=="") {
            $footerphone="n/a";
        }
        $copy=mysqli_real_escape_string($con,$_POST['copy']);
        $copyforemail=$_POST['copy'];

        $approved=$_POST['approved'];
        $seo=$_POST['seo'];
        $proofread=$_POST['proofread'];
        $info=mysqli_real_escape_string($con,$_POST['info']);
        $infoforemail=$_POST['info'];

        $priority=$_POST['priority'];
        $requestdate= date('Y-m-d');
        $duedate = date('Y-m-d', strtotime(str_replace('-', '/', $_POST['duedate'])));
        if ($duedate =="1969-12-31") {
        $duedate="0000-00-00";  
        }
        $timinginfo=mysqli_real_escape_string($con,$_POST['timinginfo']);
        $timinginfoforemail=$_POST['timinginfo'];

        $communication=mysqli_real_escape_string($con,$_POST['communication']);
        $communicationforemail=$_POST['communication'];

    //TEST EMAIL BEFORE INSERTING
    $mail = new PHPMailer;
    //$mail->SMTPDebug = 3;                               // Enable verbose debug output
    /*
    $mail->isSMTP();                                      // Set mailer to use SMTP
    $mail->Host = 'smtp.gmail.com';  // Specify main and backup SMTP servers
    $mail->SMTPAuth = true;                               // Enable SMTP authentication
    $mail->Username = '';                // SMTP username
    $mail->Password = '';                           // SMTP password
    $mail->SMTPSecure = 'tls';                            // Enable TLS encryption, `ssl` also accepted
    $mail->Port = 587;                                    // TCP port to connect to
    */
    $mail->setFrom($fromemail, $fullname);
    $mail->addAddress('myemail@myemail.com', 'my name');     // Add recipients
    $mail->addReplyTo('myemail@myemail.com', 'my name');
    /*$mail->addCC('cc@example.com');
    $mail->addBCC('bcc@example.com');


    $mail->addAttachment('/var/tmp/file.tar.gz');         // Add attachments
    $mail->addAttachment('/tmp/image.jpg', 'new.jpg');    // Optional name*/
    $mail->isHTML(true);                                  // Set email format to HTML

    $mail->Subject = "Request coming for Creative Team";
    $mail->Body    = "Request coming";
    $mail->AltBody = "Request coming";

    if(!$mail->send()) {
        echo 'Message could not be sent.';
        echo 'Mailer Error: ' . $mail->ErrorInfo;
    } else {
       //continue to insert
    }

    $sql = "INSERT INTO requests (firstname, lastname, email, picture, category, type, brand, size, bleed, bleedsize, filetype, footerurl, footerphone, copy, approved, proofread, seo, info, priority, requestdate, duedate, timinginfo, communication ) VALUES ('" . $_SESSION['google_data']['given_name'] . "', '" . $_SESSION['google_data']['family_name'] . "','" . $_SESSION['google_data']['email'] . "', '" . $_SESSION['google_data']['picture'] . "', '$category', '$need', '$brands', '$size', '$bleed', '$bleedsize', '$filetype', '$footerurl', '$footerphone', '$copy', '$approved', '$proofread', '$seo', '$info', '$priority', '$requestdate', '$duedate', '$timinginfo', '$communication')"; 

        $insertinfo = mysqli_query($con, $sql);
        if (!$insertinfo) {
        die("Database query failed: " . mysqli_error($con));
        } else {    
        //Success, continue to email...
        }


    $plaintextversion= "
    $type

    BRAND: $brands


    SPECS

    SIZE:  $size

    BLEED:  $bleed

    BLEED SIZE:  $bleedsize

    FILE TYPE:  $filetype

    FOOTER URL:  $footerurl

    FOOTER PHONE:  $footerphone

    COPY:  $copyforemail

    COPY APPROVED?  $approved

    PROOFREAD?  $proofread

    ADDITIONAL INFO:  $infoforemail


    TIMING

    PRIORITY:  $priority

    REQUEST DATE:  $requestdate

    DESIRED DUE DATE:  $duedate

    TIMING INFO: $timinginfoforemail


    COMMUNICATION

    ADDITIONAL PEOPLE TO INCLUDE:  $communicationforemail";


    } else {
        header("Location:index.php");
    }

    $mail = new PHPMailer;
    //$mail->SMTPDebug = 3;                               // Enable verbose debug output
    /*
    $mail->isSMTP();                                      // Set mailer to use SMTP
    $mail->Host = 'smtp.gmail.com';  // Specify main and backup SMTP servers
    $mail->SMTPAuth = true;                               // Enable SMTP authentication
    $mail->Username = '';                // SMTP username
    $mail->Password = '';                           // SMTP password
    $mail->SMTPSecure = 'tls';                            // Enable TLS encryption, `ssl` also accepted
    $mail->Port = 587;                                    // TCP port to connect to
    */
    $mail->setFrom($fromemail, $fullname);
    $mail->addAddress('someone@someone.com', 'someone');     // Add recipients
    $mail->addReplyTo('myemail@myemail.com', 'my name');
    /*$mail->addCC('cc@example.com');
    $mail->addBCC('bcc@example.com');


    $mail->addAttachment('/var/tmp/file.tar.gz');         // Add attachments
    $mail->addAttachment('/tmp/image.jpg', 'new.jpg');    // Optional name*/
    $mail->isHTML(false);                                  // Set email format to plain text since that is what Salesforce needs

    $mail->Subject = $subject;
    $mail->Body    = $plaintextversion;
    $mail->AltBody = $plaintextversion;

    if(!$mail->send()) {
        echo 'Message could not be sent.';
        echo 'Mailer Error: ' . $mail->ErrorInfo;
    } else {
        header("Location:request-success.php");
    }
    ?>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <html>
    <head>
    <meta charset="utf-8">
    <meta name="robots" content="noindex, nofollow">
    <title>Untitled Document</title>
    </head>

    <body>
    </body>
    </html>
  • 写回答

1条回答 默认 最新

  • douhan8009 2016-05-12 07:48
    关注

    If you want plain-text only, call isHTML(false) and set only Body - don't put anything in AltBody.

    There's no need to start from scratch every time - you can re-use the same PHPMailer instance and just change properties before sending for the second time.

    You're using the submitters address as the From address - that's forgery, and will result in bounces from SPF failures, so put your address in From and theirs in reply-to.

    As Jon says, validate, sanitize and escape anything going into SQL - it's quite likely that your failures are from submissions that contain a ', which will break your SQL.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 MATLAB动图问题
  • ¥15 有段代码不知道怎么理解,const isToken = (config.headers || {}).isToken === false
  • ¥100 采用栈和深度优先算法对我的代码进行修改显示路径
  • ¥15 pointnet2包安装
  • ¥20 射频功率问题,解答者有酬谢!
  • ¥80 构建降雨和积水的预测模型
  • ¥15 #Qt Transform setTransform()在鼠标拖动移动视角是一致在原地不动,无法变换视角(细微观察似乎视图有在原地抖动),无法变换视角(细微观察似乎视图有在原地抖动)
  • ¥50 如何利用无人机拍摄的数码照片测量鸟卵的长短径
  • ¥100 github贡献者给与奖励
  • ¥15 使用DS18B20+ESP8266获取温度数据返回-127.00