setAttribute(PDO::ATTR_EMULATE_PREPARES, TRUE);
$dbh->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$sql="SELECT candID, fnme,snme,e_mail,foneNo,amtE,sbj1,sbj2,sbj3,sbj4,licTyp FROM registrn WHERE candID='$candID'";
$results = $dbh->query($sql)->fetchAll(PDO::FETCH_ASSOC);
//var_dump($results);
//print_r($results);
foreach ($results as $arr){
/*print $arr['fnme'];
print "
";
print $arr['candID'];
print "
";
print $arr['fnme'];
print "
";
print $arr['snme'];
print "
";
print $arr['foneNo'];
print "
";
print $arr['amtE'];*/
$to = $arr['e_mail'];
$subject = 'Thank you for Registering';
$message = 'Your TRANSACTION CODE is:'.$arr['candID'].' ,you will pay '.'₦'.$arr['amtE'].' only for '.$arr['licTyp'].' licence';
//$message = 'Your TRANSACTION CODE is:'.$arr['candID'].' ,you will pay '.'₦'.$arr['amtE'].' only';
$headers = 'From: info@varsitysure.com' . "\r\n" .
'Reply-To: info@varsitysure.com' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
mail($to, $subject, $message, $headers);//echo json_encode($results);
}
}catch(PDOException $e){
print "Error!: " . $e->getMessage() . "
";
die();
}
?>