<?php

 $reference = $_GET['reference'];
 $montant = $_GET['montant'];
 $phone = $_GET['phone'];
 $phonevendeur = $_GET['phonevendeur'];
 $etat = $_GET['etat'];
 $idsim = $_GET['idsim'];


echo 'Bonjour';


$con=mysqli_connect("67.43.226.2","gamayap_gamga830897","ttwtaudsq0");
mysqli_select_db($con,'gamayap_gamga830897') or die (mysqli_error($con))  ;
mysqli_query($con,'set names utf8')  ;

  // if (mysqli_connect_errno($con)) {
    // echo "Failed to connect to MySQL: " . mysqli_connect_error();
   //}

     //$req=mysqli_query($con,"insert into gamrechargehist  values ('','".$username. "','".$password."','".$sender."','".$receiver."','".$idsim."','refid"','mnt1."','mnt2','mnt3','mnt4','mnt5','mnt6','montant','phonevendeur','numeroclient')");

     $req=mysqli_query($con," insert into failed_transaction values set code3= '".$CODEID."'");


$req3=mysqli_query($con,"update failed_transaction set etat='".$etat."' where id='".$CODEID."'");

$req=mysqli_query($con,"insert into failed_transaction values ('','".$reference. "','".$phone."','".$montant."','".$phonevendeur."','".$etat."','".$idsim."','refid','Commentaire_ici','mnt1','mnt2','mnt3','mnt4','mnt5','mnt6','mnt7','mnt8','param1','param2','param3','param4','param5','param6','param7','param8','createdat','update_at',null)");


   mysqli_close($con);
?>