query($get_query);
$pgcred = mysqli_fetch_assoc($result1);
define("RAZORPAY_KEY_ID", $pgcred['fkey']);
define("RAZORPAY_KEY_SECRET", $pgcred['fworkingid']);
require('razorpay/config.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(RAZORPAY_KEY_ID, RAZORPAY_KEY_SECRET);
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 = "
Your payment was successful
Payment ID: {$_POST['razorpay_payment_id']}
"; $paymentid = $_POST['razorpay_payment_id']; // var_dump($paymentid); $api = new Api(RAZORPAY_KEY_ID, RAZORPAY_KEY_SECRET); $payment = $api->payment->fetch("{$paymentid}"); // var_dump($payment->status); // var_dump($payment);die(); $get_data = "select * from logisys3_comexam.dbname where ifnull(fdeleted,'') <> 'T' and funivcode = '{$funivcode}'"; $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']; $univname = $row['FUNIVNAME']; $ffolder = $row['FFOLDER']; } } // var_dump($dbnames); mysqli_close($conn); $dbname = $dbnames[$payment->notes->univcode]; //$pconn = new mysqli(SERVERNAME, USERNAME, PASSWORD,$dbname); $pconn = new mysqli("logisys.cluster-cv9maxyrxjgg.ap-south-1.rds.amazonaws.com", "admin", "Logisys2104", $dbname); $status = "success"; $productinfo = $payment->notes->appno; $txnid = $payment->id; // $orderid = $payment->order_id; $orderid = $payment->order_id; $payment['TXNAMOUNT'] = ((float)$payment->amount/100); $firstname = 'Razorpay'; $html = ""; echo "Thank You. Your order status is success
"; echo "Your Transaction ID for this transaction is ".$txnid.".
"; echo "We have received a payment of Rs. " . $payment['TXNAMOUNT'] ."
"; $html = ""; $html="
Click here to take a PrintOut
";
echo $html;
$html = "";
$update="update studadm set FPAYREMARKS = '{$txnid}',FPAYID = '{$txnid}',
FPAYSTATUS = 'success', FPAYDATE = now(), FPAYTYPE = '{$firstname}'
where fappno ='{$productinfo}'";
$result=$pconn->query($update);
}
else
{
$html = "Your payment failed
{$error}
"; } echo $html; ?>