<?php
$status = $_POST['status'];
$designation = $_POST['designation'];
$transaction_id = $_POST['transaction_id'];
$client_reference = $_POST['client_reference'];
$amount = $_POST['amount'];
$currency_code = $_POST['currency_code'];
$buyer_name = $_POST['buyer_name'] ? $_POST['buyer_name'] : 'null';
$cancelled_at = $_POST['cancelled_at'] ? $_POST['cancelled_at'] : 'null' ;
$approuved_at = $_POST['approuved_at'] ?? 'null' ;
$transaction_type = $_POST['transaction_type'] ?? 'null' ;
$notification = $db->prepare("INSERT INTO notifications(status,designation,transaction_id,client_reference,amount,
phone_number, buyer_name, currency_code, cancelled_at, approuved_at, transaction_type)
VALUES (?,?,?,?,?,?,?,?,?,?,?)");
$notification->execute(array($status,$designation,$transaction_id, $client_reference,
$amount, $phone_number, $buyer_name, $currency_code, $cancelled_at,
$approuved_at, $transaction_type));
?>