Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
checkout	[ DIR ]	drwxr-xr-x
razorpay-php	[ DIR ]	drwxr-xr-x
.editorconfig	392 B	-rwxr-xr-x
.gitignore	20 B	-rwxr-xr-x
LICENSE	1.05 KB	-rwxr-xr-x
README.md	2.06 KB	-rwxr-xr-x
config.php	370 B	-rwxr-xr-x
config.php.sample	313 B	-rwxr-xr-x
index.html	1.15 KB	-rwxr-xr-x
pay.php	3.76 KB	-rwxr-xr-x
verify.php	8.73 KB	-rwxr-xr-x

Code Editor : verify.php

<html>
<head>
    <meta content="text/html;charset=utf-8" http-equiv="Content-Type">
    <meta content="utf-8" http-equiv="encoding">
    <link rel="shortcut icon" type="image/jpg" href="img/favicon.jpg" />
    <?php require_once("../links/js_files.php");?> 
    <script src="../js/candidate_list.js"></script>
    <script type="text/javascript">
        $(function(){
        
            
          $('.index_label_div').corner("5px").css("border","1px solid #6F6868");    
          $('.messageboard-div').corner("5px").css("border","1px solid #6F6868");   
          $('.reg_no_div').corner("bl br").css("border","1px solid #6F6868");   
          $('#main_message_board').corner("bl br").css("border","1px solid #2596CE");   
          $('.submit_div_button').corner("5px");    
          $('.div_app_form_center_blue').corner("tl tr");
          $('.div_app_form_center_black').corner("tl tr");
          $('#print_app_form').corner("5px");
        
        });
     
    </script>   
    
</head>
<body>
<div id='main_frame'>
    <div class='header_main_div'>
        <?php require_once("../links/header.php");?> 
        <div id='main_page_div' style=' text-align: center;'>

<?php

require('config.php');

session_start();

require('razorpay-php/Razorpay.php');
use Razorpay\Api\Api;
use Razorpay\Api\Errors\SignatureVerificationError;

$success = true;

$error = "Payment Failed";

if (empty($_POST['razorpay_payment_id']) === false)
{
    $api = new Api($keyId, $keySecret);

try
    {
        // Please note that the razorpay order ID must
        // come from a trusted source (session here, but
        // could be database or something else)
        $attributes = array(
            'razorpay_order_id' => $_SESSION['razorpay_order_id'],
            'razorpay_payment_id' => $_POST['razorpay_payment_id'],
            'razorpay_signature' => $_POST['razorpay_signature']
        );

$api->utility->verifyPaymentSignature($attributes);
    }
    catch(SignatureVerificationError $e)
    {
        $success = false;
        $error = 'Razorpay Error : ' . $e->getMessage();
    }
}

if ($success === true)
{
    $html = "<p>Your payment was successful</p>
             <p>Payment ID: {$_POST['razorpay_payment_id']}</p>";

// use Razorpay\Api\Api;
             $paymentid = $_POST['razorpay_payment_id'];

$api = new Api('rzp_test_5ST9BqRn0zcxQF', '1y2LpikpOEhKeYozg6ALipxc');

$payment = $api->payment->fetch("{$paymentid}");
           // var_dump($payment['univcode']);

$payment  = json_decode($payment,true);

$servername = "97.74.228.93";
            $username = "logisys3_logu";
            $password = "Logisys@2106";
            $dbname = "logisys3_comexam";
            $conn = new mysqli($servername, $username, $password, $dbname);
            $get_data = "select * from dbname where ifnull(fdeleted,'') <> 'T'";

$result1=$conn->query($get_data);

if (mysqli_num_rows($result1) > 0) 
            {
                // output data of each row
                $dbnames = array();
                while($row = mysqli_fetch_assoc($result1)) 
                {
                    $dbnames[$row['FUNIVCODE']] = $row['FDBNAME'];
                }
            }

mysqli_close($conn);

$servername = "97.74.228.93";
            $username = "logisys3_logu";
            $password = "Logisys@2106";
            /*$servername = "localhost";
            $username = "root";
            $password = "";*/

$dbname = $dbnames[$payment['univcode']];
            $conn = new mysqli($servername, $username, $password, $dbname);

$status = "success";
            $productinfo = $payment['appno'];
            $txnid = $payment["id"];
            $orderid = $payment["order_id"];
           
            $firstname = 'razorpay';
            
            echo "<h1 style='color:green;'>Thank You. Your order status is success</h1>";
            echo "<h2>Your Transaction ID for this transaction is ".$txnid.".</h2>";
            echo "<h3>We have received a payment of Rs. " . $payment['TXNAMOUNT']  ."</h3>";
            $html="
            <div class='raval_submit' style='width:241px;float:none; margin: 0 auto;' >
            <span onclick=\"PrintApplicationFormpaytmNETBANKING('{$productinfo}');\" style='float:left;margin-left:8px;cursor: pointer; line-height: 19px;font-size:14px;font-weight:bold;'>Click here to take a PrintOut</span>
            </div>";
            echo $html;
            $update="update appcandsum set FPAYMENTREMARKS='{$CHECKSUMHASH}',FPAYMENTSTATUS='success',
            FPAYMENTCONFIRM='success',FACKDATE=now(),FACKUSER='{$firstname}'
            where APPNO='{$productinfo}'";
            $result=$conn->query($update); 
            
            $get_app_cand_det="SELECT FDEGREE,FEXAMNO,FCOLLCODE,FREGNO,FSUBCODE,FINSERTED,FPRESENT,FYEAR,FEXAMTYPE
            FROM appcanddet
            WHERE APPNO='{$productinfo}'";  
            $result = $conn->query($get_app_cand_det); 
            
            if (mysqli_num_rows($result) > 0) 
            {
                while($row = mysqli_fetch_assoc($result)) 
                {
                    $collcode = $row['FCOLLCODE'];
                    $degree = $row['FDEGREE'];
                    $regno = $row['FREGNO'];
                }
            }
                 
            $update_cand_sum = "UPDATE appcandsum a,candsum c
            SET 
            c.FEXAMFEEA=if(ifnull(c.FEXAMFEEA,0) <=0,ifnull(a.FEXAMFEEA,0),ifnull(c.FEXAMFEEA,0)),
            c.FEXAMFEEB=if(ifnull(c.FEXAMFEEB,0) <=0,ifnull(a.FEXAMFEEB,0),ifnull(c.FEXAMFEEB,0)),
            c.FEXAMFEEC=if(ifnull(c.FEXAMFEEC,0) <=0,ifnull(a.FEXAMFEEC,0),ifnull(c.FEXAMFEEC,0)),
            c.FEXAMFEED=if(ifnull(c.FEXAMFEED,0) <=0,ifnull(a.FEXAMFEED,0),ifnull(c.FEXAMFEED,0)),
            c.FEXAMFEEE=if(ifnull(c.FEXAMFEEE,0) <=0,ifnull(a.FEXAMFEEE,0),ifnull(c.FEXAMFEEE,0)),
            c.FEXAMFEEF=if(ifnull(c.FEXAMFEEF,0) <=0,ifnull(a.FEXAMFEEF,0),ifnull(c.FEXAMFEEF,0)),
            c.FEXAMFEEG=if(ifnull(c.FEXAMFEEG,0) <=0,ifnull(a.FEXAMFEEG,0),ifnull(c.FEXAMFEEG,0)),
            c.FEXAMFEEH=if(ifnull(c.FEXAMFEEH,0) <=0,ifnull(a.FEXAMFEEH,0),ifnull(c.FEXAMFEEH,0)),
            c.FEXAMFEEI=if(ifnull(c.FEXAMFEEI,0) <=0,ifnull(a.FEXAMFEEI,0),ifnull(c.FEXAMFEEI,0)),
            c.FEXAMFEEJ=if(ifnull(c.FEXAMFEEJ,0) <=0,ifnull(a.FEXAMFEEJ,0),ifnull(c.FEXAMFEEJ,0)),
            c.FTOTALFEE=a.FTOTALFEE,
            c.frecptdate = date(now())
            WHERE a.fregno=c.FREGNO
            AND a.APPNO='{$productinfo}' and a.FCOLLCODE='{$collcode}'";
            
            $result = $conn->query($update_cand_sum); 
            
            $update_cand_appCand = "update canddet c, appcanddet t  
            set c.finserted = t.finserted,
            c.fpresent = t.fpresent
            where c.fdegree = t.fdegree
            and c.fexamno = t.fexamno
            and c.fregno = t.fregno
            and c.fsubcode = t.fsubcode
            and c.fdegree = '{$degree}' and  c.fregno = '{$regno}' and t.APPNO='{$productinfo}' and ifnull(c.fpresent,'') <> 'P'";
            
            $result = $conn->query($update_cand_appCand); 
            
            $insert_canddet ="insert into canddet(fdegree,FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, FINSERTED, FPRESENT, FYEAR, FEXAMTYPE)
            select fdegree, FEXAMNO, FCOLLCODE,FREGNO, FSUBCODE,FINSERTED, FPRESENT, FYEAR,FEXAMTYPE from appcanddet where 
            fregno = '{$regno}' and appno ='{$productinfo}' and CONCAT(fdegree,fexamno,fregno,fsubcode) 
            not in(select CONCAT(fdegree,fexamno,fregno,fsubcode) from canddet where  fregno = '{$regno}')
            ";
            
            $result = $conn->query($insert_canddet); 
            
            
            $update_studfee = "update studfee s, appstudfee a
            set s.famount = a.famount,
            s.flogdate = a.flogdate
            where s.fdegree = a.fdegree
            and s.fexamno = a.fexamno
            and s.fregno = a.fregno
            and s.ffeecode = a.ffeecode
            and  s.fregno = '{$regno}' and a.appno ='{$productinfo}'";
            
            $result = $conn->query($update_studfee);
            
            $insert_studfee = "insert into studfee(fdegree,fexamno,fcollcode,fregno,ffeecode,famount,flogdate)
            select fdegree,fexamno,fcollcode,fregno,ffeecode,famount,flogdate from appstudfee where 
            fregno = '{$regno}' and appno ='{$productinfo}' and CONCAT(fdegree,fexamno,fregno,ffeecode) 
            not in(select CONCAT(fdegree,fexamno,fregno,ffeecode) from studfee where  fdegree = '{$degree}' 
            and fregno = '{$regno}')";
            $result = $conn->query($insert_studfee);

}
else
{
    $html = "<p>Your payment failed</p>
             <p>{$error}</p>";
}

echo $html;
?>
</div>
</br>
</body>
</html>

${this.title}

Code Editor : verify.php