PHP环境下SMTP邮件发送功能异常问题求助

Hey there, let's break down the problems in your code and get that SMTP email sending working properly. First, let's go through the key issues I spot in your partial code, then walk through a fixed, secure version with proper PHPMailer setup.

Key Issues in Your Current Code #

• Incomplete Syntax: Your code cuts off at if($result=... — this will throw a PHP syntax error immediately, so that's the first thing to fix.
• Critical SQL Injection Risk: You're directly inserting $_POST['email'] into your SQL queries without sanitization. This is a huge security hole that attackers can exploit to take over your database.
• Missing PHPMailer Sending Logic: You included the PHPMailer class, but there's zero code to initialize PHPMailer, configure your SMTP settings, or actually send an email. That's why your SMTP functionality isn't working at all!

Fixed & Secure Example Code #

Here's a revised version that addresses all these issues, includes proper SMTP configuration, and adds error handling to help debug:

<?php
include 'library.php';
// Make sure you're including all necessary PHPMailer files (for older versions)
include "classes/class.phpmailer.php";
include "classes/class.smtp.php"; // Required for SMTP functionality

if(isset($_POST['submit'])) {
    $email = $_POST['email'];

    // Fix SQL Injection: Use prepared statements
    $sql = "SELECT email FROM login WHERE email = ?";
    $stmt = mysqli_prepare($con, $sql);
    mysqli_stmt_bind_param($stmt, "s", $email);
    mysqli_stmt_execute($stmt);
    mysqli_stmt_store_result($stmt);
    $fetch = mysqli_stmt_num_rows($stmt);

    if($fetch > 0) {
        echo "<p id='red'>Email already exist. Please register with different email id.</p>";
    } else {
        // Insert new email using prepared statement too
        $query = "INSERT INTO student_login(email) VALUES(?)";
        $insertStmt = mysqli_prepare($con, $query);
        mysqli_stmt_bind_param($insertStmt, "s", $email);
        $result = mysqli_stmt_execute($insertStmt);

        if($result) {
            // Now configure and send email with PHPMailer
            $mail = new PHPMailer(true); // Passing true enables exceptions

            try {
                // SMTP Configuration
                $mail->isSMTP();
                $mail->Host = 'smtp.yourprovider.com'; // e.g., smtp.gmail.com, smtp.office365.com
                $mail->SMTPAuth = true;
                $mail->Username = 'your-email@example.com'; // Your SMTP username
                $mail->Password = 'your-email-password'; // Your SMTP password (use app password for Gmail)
                $mail->SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS; // Use 'tls' (port 587) or 'ssl' (port 465)
                $mail->Port = 587; // Match your encryption type

                // Recipients
                $mail->setFrom('your-email@example.com', 'Your App Name');
                $mail->addAddress($email); // Send to the newly registered email

                // Email Content
                $mail->isHTML(true);
                $mail->Subject = 'Welcome to Our Service';
                $mail->Body    = '<h1>Thanks for Registering!</h1><p>Your email has been successfully added to our system.</p>';
                $mail->AltBody = 'Thanks for Registering! Your email has been successfully added to our system.';

                $mail->send();
                echo "<p id='green'>Registration successful! A welcome email has been sent to your inbox.</p>";
            } catch (Exception $e) {
                echo "<p id='red'>Email could not be sent. Mailer Error: {$mail->ErrorInfo}</p>";
            }
        } else {
            echo "<p id='red'>Failed to register your email. Please try again.</p>";
        }
    }
}
?>

Additional Troubleshooting Steps #

If you still run into issues after using the fixed code, try these:

• Verify PHPMailer Files: Ensure class.smtp.php is in the correct directory (it's required for SMTP support). For newer PHPMailer versions, use Composer to install it instead of manual includes — this avoids missing files.
• Check SMTP Credentials: Double-check your SMTP host, port, username, and password. For Gmail, you'll need to use an App Password if 2FA is enabled, and allow less secure apps (or use OAuth2 for better security).
• Enable Debug Mode: Add $mail->SMTPDebug = 2; right after initializing PHPMailer. This will print detailed SMTP transaction logs, which are invaluable for figuring out why the email isn't sending (e.g., connection errors, authentication failures).
• Server Firewall/Port Restrictions: Some web hosts block outgoing connections on ports 25, 587, or 465. Check with your host to confirm these ports are open, or use the alternative port they provide.
• Test SMTP Connection: Use a tool like Telnet or an online SMTP tester to verify you can connect to your SMTP server from your web server.

内容的提问来源于stack exchange，提问作者omkara