setAttribute(PDO::ATTR_EMULATE_PREPARES, FALSE); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql="INSERT INTO $tbl_name(fnme, snme, e_mail, regdate, foneNo, sttus, candID, licTyp,amtE, amtP, sex)VALUES('$fnme', '$snme', '$e_mail', '$regdate', '$foneNo', '$sttus', '$candID', '$licTyp','$amtE', '$amtP', '$sex')"; // 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() . " record(s) UPDATED successfully"; echo "
"; $k =" "; //echo "Thank you for Registering"; echo ""; echo ""; echo ""; echo "Transaction ID"; echo ""; echo ""; echo ""; echo ""; echo "Register Here"; echo ""; echo ""; echo ""; echo "
"; echo "
"; echo ""; echo "
"; echo "
"; echo "
"; echo' '; echo'
'; echo "
"; echo "
"; echo "
"; echo ""; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

    TRANSACTION ID:$candID

Payment Purpose
LICENCE TYPE:
Payer Name:
Payer Email: *
Payer Phone:
Amount: *
"; echo "Transaction Date:"; echo"
Payment Type:"; echo ""; echo "
     

If you already have a Remita Retrieval Reference (RRR), enter it to know your status:

"; echo "
"; echo "
"; echo ""; echo "
"; echo ""; echo "
"; echo "
"; echo "
"; echo "
"; //echo ""; echo "
"; echo "
"; echo "
"; echo "		 
"; //Payment Confirmation Page echo ""; echo ""; $conn = null; } catch(PDOException $e) { echo $sql . "
" . $e->getMessage(); } //header("Location:pdu.js"); include("tester.php"); ?>