<?php
ini_set('default_charset', 'utf-8');
$user = "root";
$pass = "";
$dbname = "vsadbn"; // Database name
$tbl_name="registrn"; // Table name 
// get data sent from form 
//$sbj = $_POST['sbj'];

/*$host="198.71.225.59"; // Host name 
$user="roots"; // Mysql username 
$pass="rOhr%107"; // Mysql password 
$dbname="vsaDBn"; // Database name  
//$tbl_name="vsaqtns"; // Table name
$tbl_name="registrn"; // Table name */

//---- Declarations
$fnme="";
$snme="";
$e_mail="";
$regDate="";
$foneNo="";
$sbj1="";
$sbj2="";
$sbj3="";
$sbj4="";
$sttus="";
$candID="";
$licTyp = "";
$amtEx = "";
$amtP = "";
$sex = "";
$sbj1q = "";
$sbj2a = "";
$sbj3z = "";
$sbj4x = "";
//if (ctype_alpha($_POST['paragT'])) {
//$paragT = $_POST['paragT'];
//----
/*if(isset($_POST['image'])){
    $img2 = $_POST['image'];
 }*/
// get data that sent from form 

$fnme=$_POST['fnme'];
$snme=$_POST['snme'];
$e_mail=$_POST['e_mail'];
$regdate=$_POST['regDate'];
$foneNo=$_POST['foneNo'];
/*$sbj1=$_POST['sbj1q'];
$sbj2=$_POST['sbj2a'];
$sbj3=$_POST['sbj3z'];
$sbj4=$_POST['sbj4x'];*/
/*sbj1
sbj2'];
sbj3'];
sbj4'];*/
$sttus=$_POST['sttus'];
$candID=$_POST['candID'];
$licTyp=$_POST['licTyp'];
$amtE=floatval($_POST['amtEx']);
$amtP=floatval($_POST['amtP']);
$sex = $_POST['sex'];

if(isset($_POST['regDate'])){
    $regDate=$_POST['regDate'];
 }


try {
    //$conn = new PDO("mysql:host=198.71.225.59;dbname=vsaDB;charset=utf8", $user, $pass);
	//$conn = 'mysql:host=localhost;dbname=vsaqtns;charset=utf8;';
	$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="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 "<br/>";
	 $k ="&nbsp;";
     //echo "Thank you for Registering";
     echo "<!DOCTYPE Html";
	 echo "<Html>";
	 echo "<head>";
	 echo "<title>Transaction ID</title>";
	 echo "<link rel='stylesheet' href='Payment Confirmation Page/sample_get_status_to_remita_rrr/css/bootstrap.min.css'>";
     echo "<link rel='stylesheet' href='Payment Confirmation Page/sample_get_status_to_remita_rrr/css/bootstrap-dark.min.css'>";
	 echo "</head>";
	 echo "<body>";
	 echo "<form action='sample_post_to_remita/processpayment.php' method='post' name='RemitaPaymentForm'>";
     echo "<table width='400' align='center'>";
         echo "<tbody>";
		 echo "<thead><tr><td colspan='2'><font color='green'><h3><span align='center'><b>&nbsp;&nbsp;&nbsp;&nbsp;TRANSACTION ID:$candID</b></span></h3></font></td></tr></thead>";
		  
		  echo "<tr>";
		  echo "<td>Payment Purpose</td>";
		  echo "<td><input type='text' id='paypurpose' name='paypurpose' value='JAMB CBT Software'></td>";
		  echo "</tr>";
		  echo"<tr>";
		  echo "<td> LICENCE TYPE:</td>";
		  echo "<td><input id='lictyp' name='lictyp' required='true' value=$licTyp type='text'></td>";
		  echo "</tr>";
		    echo "<tr>";
				echo "<td width='200'>Payer Name:</td>";
				echo "<td><input name='payerName' value=$fnme".$k."$snme type='text'></td>";
			echo "</tr>";
			echo "<tr>";
				echo "<td width='200'>Payer Email: <font color='red'>*</font></td>";
				echo "<td><input name='payerEmail' required='true' value=$e_mail type='email'></td>";
			echo "</tr>";
			echo "<tr>";
				echo "<td width='200'>Payer Phone:</td>";
				echo "<td><input name='payerPhone' value=$foneNo type='text'></td>";
			echo "</tr>";
		    echo "<tr>";
				echo "<td width='200'>Amount: <font color='red'>*</font></td>";
				echo "<td><input name='amt' required='true' value=$amtE type='text'></td>";
			echo "</tr>";
			echo "<tr>";
			echo "<td>";
			echo "Transaction Date:";
			echo"</td>";
			echo "<td><input type='text' name='tdate' required='true' value=$regDate ></td>";
			echo "</tr>";
			echo "<tr>";
				echo "<td width='200'>Payment Type:</td>";
				echo "<td>";
					echo "<select class='required-entry' title='Credit Card Type' name='paymenttype' id='paymenttype' autocomplete='off'>";
					   echo "<option>-- Select Payment Type --</option>";
						echo "<option value='VERVE'> Verve Card</option>";
						echo "<option value='VISA'> Visa</option>";
						echo "<option value='MASTERCARD'> MasterCard</option>";
						echo "<option value='POCKETMONI'> PocketMoni</option>";
						echo "<option value='POS'> POS</option>";
						echo "<option value='ATM'> ATM</option>";
						echo "<option value='BANK_BRANCH'>BANK BRANCH</option>";
						echo "<option value='BANK_INTERNET'>BANK INTERNET</option>";
						echo "<option value='REMITA_PAY'> Remita Account Transfer</option>";
					echo "</select>";
				 echo "</td>";
			echo "</tr>";
			echo "<tr>";
				echo "<td width='200'></td>";
				echo "<td> <input type ='submit' name='' value='Pay'></td><td></td>";
			echo "</tr>";
			echo "<tr>";
			echo "</tr>";
      
 echo "</form>";
 echo "<tr>";
 echo "<td colspan='2'><h4><font color='red'>If you already have a Remita Retrieval Reference (RRR), enter it to know your status:</font></h4></td>";
 echo "</tr>";                          
 echo "<tr>";
 echo "<td>";
 echo "<form name='form1' id='form1' action='Payment Confirmation Page/sample_get_status_to_remita_rrr/sample-receipt-page.php' action='sample-receipt-page.php' method='post' class='form-horizontal'>";
				echo "<div class='form-group'>";
					echo "<label class='col-sm-4 control-label'>RRR</label>";
					echo "<div class='col-sm-8' style='left: 0px; top: 0px; width: 179px'>";
						echo "<input type='text' class='form-control' placeholder='Enter Your RRR' name='RRR' style='width: 99%'><button class='btn btn-sm btn-primary' id='statusButton' type='button'>Check RRR Status</button>";
					echo "</div>";
                echo "</div>";
					
				 echo "<div class='form-group'>";
					echo "<div class='col-sm-8 col-sm-offset-4' style='left: 0px; top: 0px; width: 269px'>";
						//echo "<button class='btn btn-sm btn-primary' id='statusButton' type='button'>Check RRR Status</button>";
					echo "</div>";
				echo "</div>";
			echo "</form>";

 echo "</td>";
 echo "</tr>";
 echo "</tbody>";
 echo "</table>";
//Payment Confirmation Page

	 echo "</body>";
	 echo "</Html>";
     $conn = null;
    }
catch(PDOException $e)

    {
    echo $sql . "<br>" . $e->getMessage();
    }
//header("Location:pdu.js");
include("tester.php");
?>
