How can i send such a transaction to my database am using php

<?php if(isset($_GET["transaction_id"]) AND isset($_GET["status"]) AND isset($_GET["tx_ref"])){ $trans_id = htmlspecialchars($_GET['transaction_id']); $trans_status = htmlspecialchars($_GET['status']); $trans_ref = htmlspecialchars($_GET['tx_ref']); //Verify Endpoint $url = "https://api.flutterwave.com/v3/transactions/".$trans_id."/verify"; //Create cURL session $curl = curl_init($url); //Turn off SSL checker curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, 0); //Decide the request that you want curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); curl_setopt($curl, CURLOPT_CUSTOMREQUEST, "GET"); //Set the API headers curl_setopt($curl, CURLOPT_HTTPHEADER, [ "Authorization: Bearer FLWSECK_TEST-575e463bd4041c2f056a0281fa88bd57-X", "Content-Type: Application/json" ]); //Run cURL $run = curl_exec($curl); //Check for erros $error = curl_error($curl); if($error){ die("Curl returned some errors: " . $error); } //echo"
" . $run . "
"; //Convert to json obj $result = json_decode($run); $status = $result->data->status; $message = $result->message; $id = $result->data->id; $reference = $result->data->tx_ref; $amount = $result->data->amount; $charged_amount = $result->data->charged_amount; $fullName = $result->data->customer->name; $email = $result->data->customer->email; $phone = $result->data->customer->phone_number; if(($status != $trans_status) OR ($trans_id != $id)){ header("Location: index.php"); exit; }else{ //Give value } curl_close($curl); }else{ header("Location: index.php"); exit; } ?> Rave or Flutterwave Integration in PHP and cURL

Rave Verification Page!


Full Name Phone Number Email Transaction Status Reference Transaction Id Amount Charged Amount
<?php echo $fullName; ?> <?php echo $phone; ?> <?php echo $email; ?> <?php echo $status; ?> <?php echo $reference; ?> <?php echo $id; ?> <?php echo $amount; ?> <?php echo $charged_amount; ?>

Hi @richard_momanyi

Thank for choosing flutterwave.

Here are a list of resources on storing data into a database.

  1. w3school
  2. How to Use PHP to Insert Into MySQL Database: 2 Easy Methods