What is the potential issue with sending an email for each result line in a MySQL database using PHP?

Sending an email for each result line in a MySQL database using PHP can lead to performance issues, especially if there are a large number of results. To solve this, you can batch the results and send a single email with all the information instead of sending individual emails for each result line. 

// Connect to MySQL database
$conn = new mysqli($servername, $username, $password, $dbname);

// Query to get results from database
$sql = "SELECT * FROM table_name";
$result = $conn->query($sql);

// Initialize email message
$email_message = "";

// Loop through results and append to email message
while($row = $result->fetch_assoc()) {
    $email_message .= "Result: " . $row['column_name'] . "\n";
}

// Send email with all results
$to = "recipient@example.com";
$subject = "Results from MySQL database";
mail($to, $subject, $email_message);

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

Keywords

MySQL PHP email loop performance

Related Questions