$_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']}
"; // use Razorpay\Api\Api; $paymentid = $_POST['razorpay_payment_id']; $api = new Api($keyId, $keySecret); $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 "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="
Click here to take a PrintOut
";
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);
mysqli_close($conn);
}
else
{
$html = "Your payment failed
{$error}
"; } echo $html; ?>