';
            var_dump($inv);
            die('l123');

            $sql = "INSERT INTO MyGuests (firstname, lastname, email) VALUES ('John', 'Doe', 'john@example.com')";
            if($conn->query($sql) === TRUE){
                echo "New record created successfully";
            }else{
                echo "Error: " . $sql . "
" . $conn->error;
            }

            $conn->close();



        }else{
            die('Payment Fail...');
        }
    }
}else{
    die('NO');
}



//echo '
';
//var_dump($x[0]['ADD-KEY-2']);
//die('l123');



//        $servername = "localhost";
    //        $username = "kumbukri_krdbuse";
    //        $password = "Q(T8d76#Abt3";
    //        $dbname = "kumbukri_testkrdb";
    //        $conn = new mysqli($servername, $username, $password, $dbname);
    //
    //        if ($conn->connect_error) {
    //            die("Connection failed: " . $conn->connect_error);
    //        } 


            //$reservationid = (explode("-",$completeResponse->extraData('ADD-KEY-2')));




//        $sql = "SELECT * FROM reservation WHERE paylink_hash = 1469702942.2403";
//        $result = $conn->query($sql);
//        $row = $result->fetch_assoc();
        
//        echo '
';
//        var_dump($completeResponse->responseCode);


//    die($completeResponse->getResponseCode());
    
    //header('Location: http://sandbox.kumbukriver.com/payment/receiptPage');
//    echo '
';
//    var_dump($completeResponse);
    
//    echo '
//    

//        
//        
//        
//        
//        
//    
//    ';



/*echo '

PCW Payment-Complete Respopnse: ----------------------------------';
echo '
Txn Reference : ' . $completeResponse->getTxnReference();
echo '
Response Code : ' . $completeResponse->getResponseCode();
echo '
Response Text : ' . $completeResponse->getResponseText();
echo '
Settlement Date : ' . $completeResponse->getSettlementDate();
echo '
Auth Code : ' . $completeResponse->getAuthCode();
echo '
Token : ' . $completeResponse->getToken();
echo '
Token Response Text: ' . $completeResponse->getTokenResponseText();
echo '
----------------------------------------------------------------------';*/
?>




2){//check any aditional persons
            $additional_persons = $adults - 2;//number of aditional persons
            $additional_persons_total = $additional_rate * $additional_persons;//aditional persons totle price
            $adultsno = 2;//number of adults
            $adults_total = $adult_rate * $adultsno;//adults totle price
        }else{
            //elseif($adults <= 2){//check only adults
            $adults = 2;
            $adults_total = $adult_rate * $adults;//adults totle price
            $adultsno = $adults;//number of adults
            //}
        }

        $children_total = $child_rate * $children;//children totle price
        $baby_total = $baby_rate * $baby;//baby totle price
        $total = $adults_total + $children_total + $baby_total + $additional_persons_total;//total 
        $grand_total = $total * $nights;//full amount
        
        $return['adultsno'] = $adultsno;
        $return['adults_total'] = $adults_total;
        $return['additional_persons'] = $additional_persons;
        $return['additional_persons_total'] = $additional_persons_total;
        $return['children_total'] = $children_total;
        $return['baby_total'] = $baby_total;
        $return['total'] = $total;
        $return['grand_total'] = $grand_total;
        return $return;
    }
?>