get_results($querystr, OBJECT); foreach($to_be_sent as $r) { $to = ''; $to = $r->email; $datetime_email_sent = date('Y-m-d H:i:s',strtotime('+8 hours')); $name = $r->first_name.' '.$r->last_name; $date = date('j F Y',strtotime($r->payment_datetime)); $subject = 'Thank you for purchasing/renewing the Professional Indemnity. '; $body = " Dear ".$name.",

Here are the details of your payment:

Payment Amount: $".number_format($r->amount,2)."
Transaction ID: ".$r->transaction_no."
Payment Date: ".$date."

We have received your payment. You may check in your Dashboard in January for the Professional Indemnity Certificate. It will be uploaded to your account after all applications have been processed.

Should you have any queries, please feel free to write to our Secretariat 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 ); $update_q = "UPDATE insurance_payment SET email_sent = 1,datetime_email_sent= '".$datetime_email_sent."' WHERE id = ".$r->id; $wpdb->query($update_q); }