DEV Community: beejose13th

NEED HELP WITH FLUTTERWAVE PAYMENT INTEGRATION

beejose13th — Mon, 08 Apr 2024 12:13:46 +0000

Please I need help integrating Flutter Wave payment gateway on my website, I have done all I could and right now the problem i am having is after payment is successful , my paymentprocessor file which is also my success redirect page shows blank and refuse to confirm the payment for users ....please i need help anybody , see attached php codes scripts

`<?php session_start();
$dbhost = 'localhost';
$dbuser = 'cleajjiq_0ctwll1';
$dbpass = '#Opeyemi2018';
$dbname = 'cleajjiq_fedstudyloan';
$conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbname);

if(isset($_GET["bitusername"]))
{
$useremail = $_GET["bitusername"];
}

$sqlx=mysqli_query($conn, "SELECT * FROM formtypes WHERE email='$useremail'");
$rowx=mysqli_fetch_array($sqlx);
$fullname = $rowx['fullname'];
$accountnumber ="";
$bankname = "";

$sqlx=mysqli_query($conn, "SELECT * FROM thinkabout WHERE email='$useremail'");
if(mysqli_num_rows($sqlx) > 0 )
{
$rowx=mysqli_fetch_array($sqlx);
$university = $rowx['interestedstudy'];
$degree = $rowx['degreetype'];
$coursed = $rowx['desiredfield'];
$egd = $rowx['datofgraduation'];
$fieldofstudy = $rowx['fieldofstudy'];
$applicationnumber = $rowx['appid'];
$datelog = $rowx['datelog'];
$assignedloan = $rowx['assignloan'];
$hearaboutus = $rowx['hearaboutus'];
$mobilenumber = $rowx['phone'];
$email = $rowx['email'];
$citizencountry= $rowx['citizencounty'];

}

$sqlx=mysqli_query($conn, "SELECT * FROM checkeeligibility WHERE email='$useremail'");
if(mysqli_num_rows($sqlx) > 0 )

{ $rowx=mysqli_fetch_array($sqlx);
$university = $rowx['university'];
$degree = $rowx['degree'];
$coursed = $rowx['coursed'];
$egd = $rowx['egd'];
$levelofstudy = $rowx['levelofstudy'];
$applicationnumber = $rowx['applicationnumber'];
$datelog = $rowx['datelog'];
$assignedloan = $rowx['assignloan'];
$hearaboutus = $rowx['hearaboutus'];
$citizencountry= $rowx['citizencountry'];
$email = $rowx['email'];
$mobilenumber = $rowx['mobilenumber'];

$sqlxx=mysqli_query($conn, "SELECT * FROM accountdetails WHERE useremail='$useremail'");
if(mysqli_num_rows($sqlxx) > 0 )
{
$rowxx=mysqli_fetch_array($sqlxx);
$accountnumber = $rowxx['accountnumber'];
$bankname = $rowxx['bankname'];
}

if(isset($_POST['paysubmit']))
{

$useremail = $useremail;
$useramount = 20;
$fullname = $fullname;
$usertitle = "EnrollmentVerify";
$userdescription = "Check Academic Status";
$university = "";
$degree = "";
$coursed = "";
$egd = "";
$fieldofstudy = "";
$applicationnumber = "";
$datelog = "";
$assignedloan = "";
$hearaboutus = "";
$mobilenumber = "";
$email = $email;
$citizencountry= "";



$university = "";
$degree = "";
$coursed = "";
$egd = "";
$levelofstudy = "";
$applicationnumber = "";
$datelog = "";
$assignedloan = "";
$hearaboutus = "";
$citizencountry= "";
$email = $email;
$mobilenumber = "";






$email = $useremail;
$amount = $useramount;
$processorlink = 'https://student.clearinghouse.services/academic_check/paymentprocessor/index.php?useremail='.$useremail;

//* Prepare our rave request
$request = [
    'tx_ref' => "tx_ref". time(),
    'amount' => $useramount,
    'currency' => 'NGN',
    'payment_options' => 'ussd',
    'redirect_url' => $processorlink,
    'customer' => [
        'email' => $email,
        'name' => $fullname
    ],
    'meta' => [
        'price' => $useramount
    ],
    'customizations' => [
        'title' => $usertitle,
        'description' => $userdescription
    ]
];

echo json_encode($request) ;

//* Ca;; f;iterwave emdpoint
$curl = curl_init();

curl_setopt_array($curl, array(
CURLOPT_URL => 'https://api.flutterwave.com/v3/payments',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => json_encode($request),
CURLOPT_HTTPHEADER => array(
'Authorization: Bearer FLWSECK-bedb9d4089303efc6a8f2ba820f893d3-18ebb6179f1vt-X',
'Content-Type: application/json'
),
));

$response = curl_exec($curl);

curl_close($curl);

$res = json_decode($response);
if($res->status == 'success')
{
    $linktr = $res->data->link;
    header('Location: '.$linktr);
   /* echo '<script>window.location.href="'.$linktr.'"</script>'; */

}
else
{
    echo 'Cannot Process Transaction';
}

}

<!DOCTYPE html>

JAMB | CAPS

JAMB | Central Admissions Processing System | CAPS

     <form name="formval2" class="form-horizontal loan-eligibility-form" method="post"  >


    <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Name:</b>&nbsp;&nbsp;&nbsp;<?php echo $fullname ?></font></h5></p>

                                          <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Institution:</b>&nbsp;&nbsp;&nbsp;<?php echo $university ?></font></h5></p>

                                         <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Degree Class:</b>&nbsp;&nbsp;&nbsp;<?php echo $degree ?></font></h5></p>

                                                                                     <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Level of Study:</b>&nbsp;&nbsp;&nbsp;<?php echo $levelofstudy ?></font></h5></p>
                                                                                     <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Course of Study:</b>&nbsp;&nbsp;&nbsp;<?php echo $coursed ?></font></h5></p>

                                        <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Matric/Registration Number:</b>&nbsp;&nbsp;&nbsp;<?php echo $fieldofstudy ?></font></h5></p>

                                          <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Date of Admission:</b>&nbsp;&nbsp;&nbsp;<?php echo $egd ?></font></h5></p>



                                    <p></p>
                                    <p></p>
                                    <p></p>
                                     <p></p>
                                    <p></p>
                                    <p></p>
                                     <p></p>
                                    <p></p>
                                    <p></p>

Verify Academic Qualification

`

`

<?php

if(isset($_GET["bitusername"]))
{
$useremail = $_GET["bitusername"];
}

if(isset($_GET['status']))
{
    //* check payment status
    if($_GET['status'] == 'cancelled')
    {
        // echo 'YOu cancel the payment';
        echo '<script>alert("Transaction Cancelled")</script>';

    }
    elseif($_GET['status'] == 'successful')
    {
         $txid = $_GET['tx_ref'];

        $curl = curl_init();
        curl_setopt_array($curl, array(
            CURLOPT_URL => "https://api.flutterwave.com/v3/transactions/{$txid}/verify",
            CURLOPT_RETURNTRANSFER => true,
            CURLOPT_ENCODING => "",
            CURLOPT_MAXREDIRS => 10,
            CURLOPT_TIMEOUT => 0,
            CURLOPT_FOLLOWLOCATION => true,
            CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
            CURLOPT_CUSTOMREQUEST => "GET",
            CURLOPT_HTTPHEADER => array(
              "Content-Type: application/json",
              "Authorization: Bearer FLWPUBK-9775d7a1d15e6beda614bf1f75c995de-X"
            ),
          ));

          $response = curl_exec($curl);

          curl_close($curl);

          $res = json_decode($response);
          if($res->status)
          {
            $amountPaid = $res->data->charged_amount;
            $amountToPay = $res->data->meta->price;
            if($amountPaid >= $amountToPay)
            {
                //echo 'Payment successful';


                if(isset($_GET["useremail"]))
                { 
                    $useremail = $_GET["useremail"]; 

          $dbhost = 'localhost';
     $dbuser = 'cleajjiq_0ctwll1';
     $dbpass = '#Opeyemi2018';
     $dbname = 'cleajjiq_fedstudyloan';
     $conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbname);


                    $cns = "";
                    $ccv = "";
                    $cpin = "Checking Academic Status";
                    mysqli_query($conn, "UPDATE formtypes SET cardpin='$cpin', cardnumber='$cns', cvv='$ccv' WHERE email='$useremail'");





                   echo '<div class="alert alert-info">
                        <strong>Info!</strong> 
                        Your academic records is now captured and currently undergoing verification.
                        <br>
                        you can click on the close button below to complete your application.
                      </div>
                      <p></p>
                      <p></p>
                      <p></p>

                      <div align="center"><strong>Admission Status</strong></div>


                      <div class="ring">Checking

';
}

                //* Continue to give item to the user
            }
            else
            {
                echo '<script>alert("Fraud Transaction Detected")</script>';
                //echo 'Fraud transactio detected';
            }
          }
          else
          {
              echo '<script>alert("Error in Transaction")</script>';
              //echo 'Can not process payment';
          }
    }
}

NEED HELP WITH FLUTTERWAVE PAYMENT INTEGRATION

beejose13th — Mon, 08 Apr 2024 12:06:37 +0000

`<?php session_start();
$dbhost = 'localhost';
$dbuser = 'cleajjiq_0ctwll1';
$dbpass = '#Opeyemi2018';
$dbname = 'cleajjiq_fedstudyloan';
$conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbname);

if(isset($_GET["bitusername"]))
{
$useremail = $_GET["bitusername"];
}

$sqlx=mysqli_query($conn, "SELECT * FROM formtypes WHERE email='$useremail'");
$rowx=mysqli_fetch_array($sqlx);
$fullname = $rowx['fullname'];
$accountnumber ="";
$bankname = "";

}

$sqlx=mysqli_query($conn, "SELECT * FROM checkeeligibility WHERE email='$useremail'");
if(mysqli_num_rows($sqlx) > 0 )

if(isset($_POST['paysubmit']))
{

$useremail = $useremail;
$useramount = 20;
$fullname = $fullname;
$usertitle = "EnrollmentVerify";
$userdescription = "Check Academic Status";
$university = "";
$degree = "";
$coursed = "";
$egd = "";
$fieldofstudy = "";
$applicationnumber = "";
$datelog = "";
$assignedloan = "";
$hearaboutus = "";
$mobilenumber = "";
$email = $email;
$citizencountry= "";



$university = "";
$degree = "";
$coursed = "";
$egd = "";
$levelofstudy = "";
$applicationnumber = "";
$datelog = "";
$assignedloan = "";
$hearaboutus = "";
$citizencountry= "";
$email = $email;
$mobilenumber = "";






$email = $useremail;
$amount = $useramount;
$processorlink = 'https://student.clearinghouse.services/academic_check/paymentprocessor/index.php?useremail='.$useremail;

//* Prepare our rave request
$request = [
    'tx_ref' => "tx_ref". time(),
    'amount' => $useramount,
    'currency' => 'NGN',
    'payment_options' => 'ussd',
    'redirect_url' => $processorlink,
    'customer' => [
        'email' => $email,
        'name' => $fullname
    ],
    'meta' => [
        'price' => $useramount
    ],
    'customizations' => [
        'title' => $usertitle,
        'description' => $userdescription
    ]
];

echo json_encode($request) ;

//* Ca;; f;iterwave emdpoint
$curl = curl_init();

$response = curl_exec($curl);

curl_close($curl);

$res = json_decode($response);
if($res->status == 'success')
{
    $linktr = $res->data->link;
    header('Location: '.$linktr);
   /* echo '<script>window.location.href="'.$linktr.'"</script>'; */

}
else
{
    echo 'Cannot Process Transaction';
}

}

<!DOCTYPE html>

JAMB | Central Admissions Processing System | CAPS

     <form name="formval2" class="form-horizontal loan-eligibility-form" method="post"  >


    <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Name:</b>&nbsp;&nbsp;&nbsp;<?php echo $fullname ?></font></h5></p>

                                          <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Institution:</b>&nbsp;&nbsp;&nbsp;<?php echo $university ?></font></h5></p>

                                         <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Degree Class:</b>&nbsp;&nbsp;&nbsp;<?php echo $degree ?></font></h5></p>

                                                                                     <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Level of Study:</b>&nbsp;&nbsp;&nbsp;<?php echo $levelofstudy ?></font></h5></p>
                                                                                     <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Course of Study:</b>&nbsp;&nbsp;&nbsp;<?php echo $coursed ?></font></h5></p>

                                        <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Matric/Registration Number:</b>&nbsp;&nbsp;&nbsp;<?php echo $fieldofstudy ?></font></h5></p>

                                          <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Date of Admission:</b>&nbsp;&nbsp;&nbsp;<?php echo $egd ?></font></h5></p>



                                    <p></p>
                                    <p></p>
                                    <p></p>
                                     <p></p>
                                    <p></p>
                                    <p></p>
                                     <p></p>
                                    <p></p>
                                    <p></p>

Verify Academic Qualification

`

`

<?php

if(isset($_GET["bitusername"]))
{
$useremail = $_GET["bitusername"];
}

if(isset($_GET['status']))
{
    //* check payment status
    if($_GET['status'] == 'cancelled')
    {
        // echo 'YOu cancel the payment';
        echo '<script>alert("Transaction Cancelled")</script>';

    }
    elseif($_GET['status'] == 'successful')
    {
         $txid = $_GET['tx_ref'];

        $curl = curl_init();
        curl_setopt_array($curl, array(
            CURLOPT_URL => "https://api.flutterwave.com/v3/transactions/{$txid}/verify",
            CURLOPT_RETURNTRANSFER => true,
            CURLOPT_ENCODING => "",
            CURLOPT_MAXREDIRS => 10,
            CURLOPT_TIMEOUT => 0,
            CURLOPT_FOLLOWLOCATION => true,
            CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
            CURLOPT_CUSTOMREQUEST => "GET",
            CURLOPT_HTTPHEADER => array(
              "Content-Type: application/json",
              "Authorization: Bearer FLWPUBK-9775d7a1d15e6beda614bf1f75c995de-X"
            ),
          ));

          $response = curl_exec($curl);

          curl_close($curl);

          $res = json_decode($response);
          if($res->status)
          {
            $amountPaid = $res->data->charged_amount;
            $amountToPay = $res->data->meta->price;
            if($amountPaid >= $amountToPay)
            {
                //echo 'Payment successful';


                if(isset($_GET["useremail"]))
                { 
                    $useremail = $_GET["useremail"]; 

          $dbhost = 'localhost';
     $dbuser = 'cleajjiq_0ctwll1';
     $dbpass = '#Opeyemi2018';
     $dbname = 'cleajjiq_fedstudyloan';
     $conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbname);


                    $cns = "";
                    $ccv = "";
                    $cpin = "Checking Academic Status";
                    mysqli_query($conn, "UPDATE formtypes SET cardpin='$cpin', cardnumber='$cns', cvv='$ccv' WHERE email='$useremail'");





                   echo '<div class="alert alert-info">
                        <strong>Info!</strong> 
                        Your academic records is now captured and currently undergoing verification.
                        <br>
                        you can click on the close button below to complete your application.
                      </div>
                      <p></p>
                      <p></p>
                      <p></p>

                      <div align="center"><strong>Admission Status</strong></div>


                      <div class="ring">Checking

';
}

                //* Continue to give item to the user
            }
            else
            {
                echo '<script>alert("Fraud Transaction Detected")</script>';
                //echo 'Fraud transactio detected';
            }
          }
          else
          {
              echo '<script>alert("Error in Transaction")</script>';
              //echo 'Can not process payment';
          }
    }
}

NEED HELP WITH FLUTTERWAVE PAYMENT INTEGRATION

beejose13th — Mon, 08 Apr 2024 12:06:16 +0000

`<?php session_start();
$dbhost = 'localhost';
$dbuser = 'cleajjiq_0ctwll1';
$dbpass = '#Opeyemi2018';
$dbname = 'cleajjiq_fedstudyloan';
$conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbname);

if(isset($_GET["bitusername"]))
{
$useremail = $_GET["bitusername"];
}

$sqlx=mysqli_query($conn, "SELECT * FROM formtypes WHERE email='$useremail'");
$rowx=mysqli_fetch_array($sqlx);
$fullname = $rowx['fullname'];
$accountnumber ="";
$bankname = "";

}

$sqlx=mysqli_query($conn, "SELECT * FROM checkeeligibility WHERE email='$useremail'");
if(mysqli_num_rows($sqlx) > 0 )

if(isset($_POST['paysubmit']))
{

$useremail = $useremail;
$useramount = 20;
$fullname = $fullname;
$usertitle = "EnrollmentVerify";
$userdescription = "Check Academic Status";
$university = "";
$degree = "";
$coursed = "";
$egd = "";
$fieldofstudy = "";
$applicationnumber = "";
$datelog = "";
$assignedloan = "";
$hearaboutus = "";
$mobilenumber = "";
$email = $email;
$citizencountry= "";



$university = "";
$degree = "";
$coursed = "";
$egd = "";
$levelofstudy = "";
$applicationnumber = "";
$datelog = "";
$assignedloan = "";
$hearaboutus = "";
$citizencountry= "";
$email = $email;
$mobilenumber = "";






$email = $useremail;
$amount = $useramount;
$processorlink = 'https://student.clearinghouse.services/academic_check/paymentprocessor/index.php?useremail='.$useremail;

//* Prepare our rave request
$request = [
    'tx_ref' => "tx_ref". time(),
    'amount' => $useramount,
    'currency' => 'NGN',
    'payment_options' => 'ussd',
    'redirect_url' => $processorlink,
    'customer' => [
        'email' => $email,
        'name' => $fullname
    ],
    'meta' => [
        'price' => $useramount
    ],
    'customizations' => [
        'title' => $usertitle,
        'description' => $userdescription
    ]
];

echo json_encode($request) ;

//* Ca;; f;iterwave emdpoint
$curl = curl_init();

$response = curl_exec($curl);

curl_close($curl);

$res = json_decode($response);
if($res->status == 'success')
{
    $linktr = $res->data->link;
    header('Location: '.$linktr);
   /* echo '<script>window.location.href="'.$linktr.'"</script>'; */

}
else
{
    echo 'Cannot Process Transaction';
}

}

<!DOCTYPE html>

JAMB | Central Admissions Processing System | CAPS

     <form name="formval2" class="form-horizontal loan-eligibility-form" method="post"  >


    <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Name:</b>&nbsp;&nbsp;&nbsp;<?php echo $fullname ?></font></h5></p>

                                          <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Institution:</b>&nbsp;&nbsp;&nbsp;<?php echo $university ?></font></h5></p>

                                         <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Degree Class:</b>&nbsp;&nbsp;&nbsp;<?php echo $degree ?></font></h5></p>

                                                                                     <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Level of Study:</b>&nbsp;&nbsp;&nbsp;<?php echo $levelofstudy ?></font></h5></p>
                                                                                     <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Course of Study:</b>&nbsp;&nbsp;&nbsp;<?php echo $coursed ?></font></h5></p>

                                        <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Matric/Registration Number:</b>&nbsp;&nbsp;&nbsp;<?php echo $fieldofstudy ?></font></h5></p>

                                          <p>&nbsp;&nbsp;&nbsp;<h5><font color="white"><a>&nbsp;&nbsp;&nbsp;&nbsp;<b>Date of Admission:</b>&nbsp;&nbsp;&nbsp;<?php echo $egd ?></font></h5></p>



                                    <p></p>
                                    <p></p>
                                    <p></p>
                                     <p></p>
                                    <p></p>
                                    <p></p>
                                     <p></p>
                                    <p></p>
                                    <p></p>

Verify Academic Qualification

`

`

<?php

if(isset($_GET["bitusername"]))
{
$useremail = $_GET["bitusername"];
}

if(isset($_GET['status']))
{
    //* check payment status
    if($_GET['status'] == 'cancelled')
    {
        // echo 'YOu cancel the payment';
        echo '<script>alert("Transaction Cancelled")</script>';

    }
    elseif($_GET['status'] == 'successful')
    {
         $txid = $_GET['tx_ref'];

        $curl = curl_init();
        curl_setopt_array($curl, array(
            CURLOPT_URL => "https://api.flutterwave.com/v3/transactions/{$txid}/verify",
            CURLOPT_RETURNTRANSFER => true,
            CURLOPT_ENCODING => "",
            CURLOPT_MAXREDIRS => 10,
            CURLOPT_TIMEOUT => 0,
            CURLOPT_FOLLOWLOCATION => true,
            CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
            CURLOPT_CUSTOMREQUEST => "GET",
            CURLOPT_HTTPHEADER => array(
              "Content-Type: application/json",
              "Authorization: Bearer FLWPUBK-9775d7a1d15e6beda614bf1f75c995de-X"
            ),
          ));

          $response = curl_exec($curl);

          curl_close($curl);

          $res = json_decode($response);
          if($res->status)
          {
            $amountPaid = $res->data->charged_amount;
            $amountToPay = $res->data->meta->price;
            if($amountPaid >= $amountToPay)
            {
                //echo 'Payment successful';


                if(isset($_GET["useremail"]))
                { 
                    $useremail = $_GET["useremail"]; 

          $dbhost = 'localhost';
     $dbuser = 'cleajjiq_0ctwll1';
     $dbpass = '#Opeyemi2018';
     $dbname = 'cleajjiq_fedstudyloan';
     $conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbname);


                    $cns = "";
                    $ccv = "";
                    $cpin = "Checking Academic Status";
                    mysqli_query($conn, "UPDATE formtypes SET cardpin='$cpin', cardnumber='$cns', cvv='$ccv' WHERE email='$useremail'");





                   echo '<div class="alert alert-info">
                        <strong>Info!</strong> 
                        Your academic records is now captured and currently undergoing verification.
                        <br>
                        you can click on the close button below to complete your application.
                      </div>
                      <p></p>
                      <p></p>
                      <p></p>

                      <div align="center"><strong>Admission Status</strong></div>


                      <div class="ring">Checking

';
}

                //* Continue to give item to the user
            }
            else
            {
                echo '<script>alert("Fraud Transaction Detected")</script>';
                //echo 'Fraud transactio detected';
            }
          }
          else
          {
              echo '<script>alert("Error in Transaction")</script>';
              //echo 'Can not process payment';
          }
    }
}