success.php

<?php

$val_id=urlencode($_POST['val_id']);
$store_id=urlencode("mlee5f74aac36ddbf");
$store_passwd=urlencode("mlee5f74aac36ddbf@ssl");
$requested_url = ("https://sandbox.sslcommerz.com/validator/api/validationserverAPI.php?val_id=".$val_id."&store_id=".$store_id."&store_passwd=".$store_passwd."&v=1&format=json");

$handle = curl_init();
curl_setopt($handle, CURLOPT_URL, $requested_url);
curl_setopt($handle, CURLOPT_RETURNTRANSFER, true);
curl_setopt($handle, CURLOPT_SSL_VERIFYHOST, false); # IF YOU RUN FROM LOCAL PC
curl_setopt($handle, CURLOPT_SSL_VERIFYPEER, false); # IF YOU RUN FROM LOCAL PC

$result = curl_exec($handle);

$code = curl_getinfo($handle, CURLINFO_HTTP_CODE);

if($code == 200 && !( curl_errno($handle)))
{

    # TO CONVERT AS ARRAY
    # $result = json_decode($result, true);
    # $status = $result['status'];

    # TO CONVERT AS OBJECT
    $result = json_decode($result);

    # TRANSACTION INFO
    $status = $result->status;
    $tran_date = $result->tran_date;
    $tran_id = $result->tran_id;
    $val_id = $result->val_id;
    $amount = $result->amount;
    $store_amount = $result->store_amount;
    $bank_tran_id = $result->bank_tran_id;
    $card_type = $result->card_type;

    # EMI INFO
    $emi_instalment = $result->emi_instalment;
    $emi_amount = $result->emi_amount;
    $emi_description = $result->emi_description;
    $emi_issuer = $result->emi_issuer;

    # ISSUER INFO
    $card_no = $result->card_no;
    $card_issuer = $result->card_issuer;
    $card_brand = $result->card_brand;
    $card_issuer_country = $result->card_issuer_country;
    $card_issuer_country_code = $result->card_issuer_country_code;

    # API AUTHENTICATION
    $APIConnect = $result->APIConnect;
    $validated_on = $result->validated_on;
    $gw_version = $result->gw_version;

    //print some value for ensure working or not
    //echo "<h1 >Transaction successful<br>Data for saving to database<br>Status:$status<br>Transaction Date:$tran_date<br>Transaction Id:$tran_id<br>Amount Paid: $amount</h1>";
    //echo '<pre>';
    //print_r($result);
    //echo '</pre>';
    $pres_id = $result->value_a;
    //echo $amount,$pres_id,$tran_date;
    $connection =  new mysqli('localhost','root','','hms');

    $sql ="UPDATE prescription SET updated_at='$tran_date', txd_id = '$tran_id', payment_status='PAID' WHERE id='$pres_id'";

    $connection->query($sql);

    header("location:profile.php");




} else {

    echo "Failed to connect with SSLCOMMERZ";
}