Mpesa

<?php
header("Content-Type:application/json");


$host="localhost";
$username="root";
$password="ray13a26b";
$dbname="lnm";

//create a Connection
$conn=mysqli_connect($host,$username,$password,$dbname);

//check the connection

if(!$conn)
{
    die("connection does not established successfully :".mysqli_connect_error());
}

$dataPOST = trim(file_get_contents('php://input'));
$obj = json_decode($dataPOST,true);
if(empty($obj)){return ['message'=>'empty body'];}
$mydata=$obj['Body']['stkCallback']['CallbackMetadata']['Item'];
$merchant_id=$obj['Body']['stkCallback']['MerchantRequestID'];
$request_id=$obj['Body']['stkCallback']['CheckoutRequestID'];
$ResultCode=$obj['Body']['stkCallback']['ResultCode'];
if ($ResultCode != 0) {
    // $this->send_sms($request_id);
    return ['message'=>'something went wrong'];
}else{
    foreach ($mydata as $key => $value) {
        if($value['Name']=="Amount"){
            $amount=$value['Value'];
        }else if($value['Name']=="MpesaReceiptNumber"){
            $MpesaReceiptNumber=$value['Value'];
        }else if($value['Name']=="TransactionDate"){
            $TransactionDate=$value['Value'];
        }else if($value['Name']=="PhoneNumber"){
            $PhoneNumber=$value['Value'];
        }}}


$sql="insert into transactions
(merchant_request_id,checkout_request_id,result_code,amount,mpesa_receipt_number,transaction_date,phone_number )
values
('$merchant_id','$request_id','$ResultCode','$amount','$MpesaReceiptNumber','$TransactionDate','$PhoneNumber')";

//run the above query
$result=mysqli_query($conn,$sql);

if(!$result)
{
    die("ERROR :". mysqli_error($conn));
}
else
{
    echo "Records successfully inserted";
}


//close the connection
mysqli_close($conn);