Gecko [ tradesense.co.ke ]

Name	Size	Permission
cgi-bin	[ DIR ]	drwxr-xr-x
Mpesastkresponse.json	11.01 KB	-rw-r--r--
callback.php	1.35 KB	-rwxr-xr-x
error_log	14.92 KB	-rw-r--r--
transaction_log	876 B	-rw-r--r--

Code Editor : callback.php

<?php
header("Content-Type: application/json");
$stkCallbackResponse = file_get_contents('php://input');
$logFile = "Mpesastkresponse.json";
$log = fopen($logFile, "a");
fwrite($log, $stkCallbackResponse);
fclose($log);
$servername = "https://66fd-41-80-113-64.ngrok-free.app";
$username = "root";
$password = "";
$dbname = "tradeapp";
try {
  $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  // set the PDO error mode to exception
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Create connection

// Check connection

$MerchantRequestID = $data->Body->stkCallback->MerchantRequestID;
$CheckoutRequestID = $data->Body->stkCallback->CheckoutRequestID;
$ResultCode = $data->Body->stkCallback->ResultCode;
$ResultDesc = $data->Body->stkCallback->ResultDesc;
$Amount = $data->Body->stkCallback->CallbackMetadata->Item[0]->Value;
$TransactionId = $data->Body->stkCallback->CallbackMetadata->Item[1]->Value;
$UserPhoneNumber = $data->Body->stkCallback->CallbackMetadata->Item[4]->Value;
//CHECK IF THE TRASACTION WAS SUCCESSFUL 
if ($ResultCode == 0) {
$sql = "UPDATE mpesatransaction SET TransactionId='$TransactionId', UserPhoneNumber='$UserPhoneNumber' WHERE CheckoutRequestID='$CheckoutRequestID'";
$conn->exec($sql);
}
    
} catch(PDOException $e) {
  echo $sql . "<br>" . $e->getMessage();
}
?>

${this.title}

Code Editor : callback.php