get_results($querystr3, OBJECT); $subject = 'Professional Indemnity Insurance - Certificate Download'; foreach($listing as $p) { $to = $p->email; $body = "

Dear SRP member,

Your renewed insurance certificate is now available for download.

To access your certificate, please follow these simple steps:

1) Visit our website: https://singaporepsychologicalsociety.org/login/
Log in to your account using your credentials.

2) Navigate to the dashboard page, Locate Professional Indemnity Insurance section through the left side menu.

3) Locate and download your updated certificate.

If you encounter any difficulties, reach out to us at secretariat@singaporepsychologicalsociety.org.

Regards,
Singapore Psychological Society

8 Eu Tong Sen Street #18-81 The Central Singapore 059818 | Email: secretariat@singaporepsychologicalsociety.org

"; $headers = array('Content-Type: text/html; charset=UTF-8'); if($to != '') wp_mail( $to, $subject, $body, $headers ); $datetime_cert_email_sent = date('Y-m-d H:i:s'); $update_q = "UPDATE insurance_payment SET datetime_cert_email_sent = '".$datetime_cert_email_sent."', cert_email_sent = 1 WHERE insurance_year = 2025 AND id = ".$p->id; $wpdb->query($update_q); } print 'SENT';