<?php include('../../../config/main_function.php'); $secure = "cAh3DrJACzw4RbU"; $connection = connectDB($secure); $json_str = file_get_contents('php://input'); fwrite($respFile, $json_str . "\n\n"); $json_obj = json_decode($json_str); $gb_ref = $json_obj->referenceNo; $gb_response = $json_obj->gbpReferenceNo; $dateTime = date("Y-m-d H:i:s"); $date = date("Y-m-d"); $time = date("H:i:s"); $sql = "UPDATE `tbl_member_payment` SET `payment_type` = '1' , `gb_response` = '$gb_response' , `approve_datetime` = '$dateTime',transfer_date = '$date', transfer_time = '$time' WHERE `gb_ref_no` = '$gb_ref'"; $result = mysqli_query($connection, $sql);