Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
Paytm	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
easy_zip	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
jquery-ui-1.9	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
links	[ DIR ]	drwxr-xr-x
razorpay	[ DIR ]	drwxr-xr-x
src	[ DIR ]	drwxr-xr-x
tarka_pdf	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
app.php	417 B	-rwxr-xr-x
cconfig.php	1.39 KB	-rwxr-xr-x
index_student_portal.php	4.9 KB	-rwxr-xr-x
payment_gate_way_responce.php	3.35 KB	-rwxr-xr-x
payment_gateway.php	7.83 KB	-rwxr-xr-x
pgResponse.php	7.89 KB	-rwxr-xr-x
result.php	5.43 KB	-rwxr-xr-x
subjectDetails.php	1.15 KB	-rwxr-xr-x
update_challan.html	1.25 KB	-rwxr-xr-x
verify.php	7.83 KB	-rwxr-xr-x

Code Editor : verify.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <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>

<?php

require('razorpay/config.php');
include("sendsmsapi.php");

session_start();

require('razorpay/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);
        //var_dump($api);
    }
    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_live_2gp0OHXko2psqf', '3gpdKlvGZMScC73py7qaIlUZ');
            $api = new Api('rzp_live_2gp0OHXko2psqf', '3gpdKlvGZMScC73py7qaIlUZ');

$payment = $api->payment->fetch("{$paymentid}");
      
            $servername = "97.74.228.93";
            $username = "logisys3_logu";
            $password = "Logisys@2106";
           /* $servername = "localhost";
            $username = "root";
            $password = "";*/
            $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->notes->univcode];
            $conn = new mysqli($servername, $username, $password, $dbname);

$status = "success";
            $productinfo = $payment->notes->appno;
            $txnid = $payment->id;
            $orderid = $payment->notes->order_id;
            $orderid = $payment->notes->order_id;
            $payment['TXNAMOUNT'] = ((float)$payment->amount/100);
           
            $firstname = 'razorpay';
            $html = "";

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=\"PrintRevaluationApplicationForm('{$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;
            $html = "";
          
            $update="update res_stud set FPAYMENTREMARKS='{$txnid}',FPAYMENTSTATUS='{$status}',
                    FPAYMENTCONFIRM='{$status}', fackdate = current_date(), funivrecdate = current_date(), 
                    fackuser = '{$firstname}', FCHALLANNO = '{$orderid}'
                    where APPNO='{$productinfo}'";

$result=$conn->query($update);

$get_app_cand_det="SELECT a.FDEGREE,a.FEXAMNO,a.FCOLLCODE,c.funivcode,
            a.FREGNO,CONCAT('Message from ',c.funivname,' : ', 
            ' Dear ',s.fname,' (Reg. no. : ',s.fregno,' , Stud. id. : ',IFNULL(s.fstudid,''),'),', 
            ' Rs.',FLOOR(a.FTOTAL),'/- is received at university. Your application no. is ',a.appno,
            '. keep this information for future reference.',' Sent Time: ',TIME(NOW())) as message
            FROM res_stud a inner join student s on 
            a.fregno = s.fregno inner join control c
            WHERE a.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'];
                    $text = $row['message'];
                    $funivcode = $row['funivcode'];
                }
            }
            
        
            $servername = "97.74.228.93";
            $username = "logisys3_logu";
            $password = "Logisys@2106";

/* $servername = "localhost";
            $username = "root";
            $password = "";*/

$dbname = "logisys3_comexam";
            $conn = new mysqli($servername, $username, $password, $dbname);
            
            $get_data = "select fmobileno from masuser where fregno = '{$regno}' 
            and funivcode = '{$payment->notes->univcode}'";

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

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

$username = 'logisyhttp';
            $password = 'Logis986';
            $from = 'UNISOL';
            $category = '';
           // $smsresp = sendsmaapi($username,$password,$from,$to,$text,$category);

$strInsertQuery = "insert into smslog(funivcode, fregno,fmobileno, freasoncode, fguid, fenttype, fstatus,fackdate, facktime,fremarks) values('{$funivcode}','{$regno}','{$to}','PG','{$smsresp}','PG','{$smsresp}',now(),now(),'razorpay')";
           
            $result1=$conn->query($strInsertQuery);
            mysqli_close($conn);
}
else
{
    $html = "<p>Your payment failed</p>
             <p>{$error}</p>";
}

echo $html;
?>
</div>
     
    <?php require_once("links/footer.php");?>

</div>
</div>
</br>
</body>
</html>

${this.title}

Code Editor : verify.php