SetFont('Arial');
$mpdf->WriteHTML($html);
if ($stream)
{
$mpdf->Output($filename . '.pdf', 'D');
}
else
{
$mpdf->Output('./attendance_cert/' . $filename . '.pdf', 'F');
return './attendance_cert/' . $filename . '.pdf';
}
}
// Path to your CSV file
$filename = 'cert.txt'; // Make sure this file exists
$d = array();
// Open the file for reading
if (($handle = fopen($filename, "r")) !== false) {
// Read each line of the file
while (($data = fgetcsv($handle, 0, "\t")) !== false) {
// Print the data (as an array)
$d[] = $data;
}
fclose($handle);
} else {
echo "Failed to open file: $filename";
}
foreach($d as $count=>$da)
{
$name = '';
$email = '';
$name = $da[0];
$email = $da[1];
if($count == 364)
{
$output = '';
$template = '';
$template = file_get_contents('cert.html');
// Array of variables to replace
$variables = [
'[NAME]' => $name,
];
// Replace placeholders with actual values
$output = str_replace(array_keys($variables), array_values($variables), $template);
$filename = 'Certificate-of-Attendance-'.($count+1);
$filename2 = $filename.'.pdf';
pdf_create($output, $filename);
$to = $email;
$body = "";
$body = "
Dear ".$name.",
Thanks once again for attending our inaugural SPS Symposium. Please find your Certificate of Attendance attached. Hope to see you at the next symposium!
Warm 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');
$pdf_file_path = './attendance_cert/'.$filename.'.pdf'; // Adjust this path accordingly
$attachments = array($pdf_file_path,'cert.pdf'); // Array of attachment paths
if($to != '')
{
wp_mail( $to, $subject, $body, $headers,$attachments );
}
sleep(1);
}
}
print 'DONE';
?>