setAttribute(PDO::ATTR_EMULATE_PREPARES, TRUE); $dbh->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION); $sql="SELECT candID,orderId, fnme,snme,e_mail,foneNo,amtP,rrr,transactiondate,payerName,licTyp FROM registrn WHERE orderId='$orderID'"; $results = $dbh->query($sql)->fetchAll(PDO::FETCH_ASSOC); //var_dump($results); //print_r($results); foreach ($results as $arr){ $to = $arr['e_mail']; $subject = 'Payment Notification'; $message = 'Your RRR CODE is:'.$arr['rrr'].' ,you paid '.₦.$arr['amtP'].' only for '.$arr['licTyp'].' licence'; //$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(); } ?>