English
English
<?php
require 'PHPMailer/PHPMailerAutoload.php';
function sendEmailNotification($email, $subject, $message) {
$mail = new PHPMailer(true);
try {
$mail->isSMTP();
$mail->Host = 'smtp.example.com'; // SMTP server address
$mail->SMTPAuth = true;
$mail->Username = 'your_email@example.com'; // SMTP account
$mail->Password = 'your_password'; // SMTP password
$mail->SMTPSecure = 'tls';
$mail->Port = 587;
$mail->setFrom('your_email@example.com', 'Your Name'); // Sender's email and name
$mail->addAddress($email); // Recipient's email
$mail->isHTML(true);
$mail->Subject = $subject;
$mail->Body = $message;
$mail->send();
echo 'Email sent successfully!';
} catch (Exception $e) {
echo 'Email sending failed: ' . $mail->ErrorInfo;
}
}
function handleUserReview($review) {
$email = 'seller_email@example.com'; // Merchant's email
$subject = 'New User Review'; // Email subject
$message = 'You received a new user review: ' . $review; // Email content
sendEmailNotification($email, $subject, $message);
}
// Assuming there’s a trigger that inserts a review into the reviews table
$review = 'This is a great product!';
handleUserReview($review);
?>
In the code example above, we first include the PHPMailer library, and then define a `sendEmailNotification` function to send the email. This function uses SMTP to send the email and requires parameters such as SMTP server address, SMTP account, SMTP password, sender’s email and name, recipient's email, subject, and message.
Next, we define the `handleUserReview` function, which accepts a user review as a parameter, constructs the email subject and body, and calls the `sendEmailNotification` function to send the email.
Finally, we assume that there is a trigger in the database, which, upon inserting a user review, automatically calls the `handleUserReview` function to send the review reminder email to the merchant.
