What are the potential pitfalls of sending emails directly from a PHP script in case of database connection failure?

When sending emails directly from a PHP script, if there is a database connection failure, the email may not be sent successfully and important information could be lost. To avoid this issue, it is recommended to separate the email sending functionality from the database connection logic. This way, even if the database connection fails, the email sending process can still proceed uninterrupted. 

// Separate email sending functionality from database connection logic

// Database connection
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    // Handle database connection failure
    die("Connection failed: " . $conn->connect_error);
}

// Email sending
$to = "recipient@example.com";
$subject = "Test email";
$message = "This is a test email.";

// Send email
if (mail($to, $subject, $message)) {
    echo "Email sent successfully";
} else {
    echo "Email sending failed";
}

// Close database connection
$conn->close();

Keywords

SMTP PHPMailer error handling database connection exception handling

Related Questions