//php



$callbackJSONData=file_get_contents('php://input');
        $callbackData=json_decode($callbackJSONData);
        $transactionType=$callbackData->TransactionType;
        $transID=$callbackData->TransID;
        $transTime=$callbackData->TransTime;
        $transAmount=$callbackData->TransAmount;
        $businessShortCode=$callbackData->BusinessShortCode;
        $billRefNumber=$callbackData->BillRefNumber;
        $invoiceNumber=$callbackData->InvoiceNumber;
        $orgAccountBalance=$callbackData->OrgAccountBalance;
        $thirdPartyTransID=$callbackData->ThirdPartyTransID;
        $MSISDN=$callbackData->MSISDN;
        $firstName=$callbackData->FirstName;
        $middleName=$callbackData->MiddleName;
        $lastName=$callbackData->LastName;


        $dbhost = "localhost";
        $dbname = "mpesa";
        $dbusername = "root";
        $dbpassword = "";

        $link = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbusername, $dbpassword);

        $statement = $link->prepare("INSERT INTO validation(transactionType, transID, transTime,transAmount,businessShortCode,billRefNumber,invoiceNumber,orgAccountBalance,thirdPartyTransID,MSISDN,firstName,middleName,lastName)
    VALUES(:transactionType, :transID, :transTime,:transAmount,:businessShortCode,:billRefNumber,:invoiceNumber,:orgAccountBalance,:thirdPartyTransID,:MSISDN,:firstName,:middleName, :lastName)");
        $statement->execute(array(
            "transactionType"=>$transactionType,
            "transID"=>$transID,
            "transTime"=>$transTime,
            "transAmount"=>$transAmount,
            "businessShortCode"=>$businessShortCode,
            "billRefNumber"=>$billRefNumber,
            "invoiceNumber"=>$invoiceNumber,
            "orgAccountBalance"=>$orgAccountBalance,
            "thirdPartyTransID"=>$thirdPartyTransID,
            "MSISDN"=>$MSISDN,
            "firstName"=>$firstName,
            "middleName"=>$middleName,
            "lastName"=>$lastName
        ));




        CREATE TABLE validation (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
TransactionType varchar(250) null,
TransID varchar(250) null,
TransTime varchar(250) null,
TransAmount varchar(250) null,
BusinessShortCode varchar(250) null,
BillRefNumber varchar(250) null,
InvoiceNumber varchar(250) null,
OrgAccountBalance varchar(250) null,
ThirdPartyTransID varchar(250) null,
MSISDN varchar(250) null,
FirstName varchar(250) null,
MiddleName varchar(250) null,
LastName varchar(250) null
)ENGINE=;