"; try { $conn = new PDO("mysql:host=localhost;dbname=vsaDBn;charset=utf8", $user, $pass); $conn->setAttribute(PDO::ATTR_EMULATE_PREPARES, FALSE); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql="UPDATE registrn SET transactiondate='$transactiondate',amtP='$amtP', rrr='$rrr' WHERE orderId=". $conn->quote($orderId); // Prepare statement $stmt = $conn->prepare($sql); //$stmt = $conn->exec($sql); // execute the query $stmt->execute(); // echo a message to say the UPDATE succeeded echo $stmt->rowCount() . " records UPDATED successfully". "
";; // " records UPDATED successfully"; //include("successPayer.php"); $conn = null; } catch(PDOException $e) { echo $sql . "
" . $e->getMessage(); } } $response_message = $response['message']; } ?> Payment Notification Register Here






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 rrr='$rrr'"; $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 RRR CODE is:'.$arr['rrr'].' ,you paid '.$arr['amtP'].' Naira only for '.$arr['licTyp'].' licence'; //$message = 'Your TRANSACTION CODE is:'.$arr['candID'].' ,you will pay '.'U+20A6;'.$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(); } ?>

Transaction Successful

Remita Retrieval Reference:

Transaction Pending

Remita Retrieval Reference:

Your Transaction was not Successful

Your Remita Retrieval Reference is

Reason: