<?php session_start();
require_once("./../../config/config.php");
//require_once("../config/commonsetting.php");

$myformId=SESS_MASTER;
$myIp= ipCheck() ;
$dateceated=date("Y-m-d G:i:s");
$createdby='0';
$api_key		=   secureSuperGlobalPOST($_REQUEST[SESS_MASTER.'api_key']);
$pub_id		=   secureSuperGlobalPOST($_REQUEST[SESS_MASTER.'user_id']);

$stat	=   secureSuperGlobalPOST($_REQUEST[SESS_MASTER.'stat']);
$api_type	=   secureSuperGlobalPOST($_REQUEST[SESS_MASTER.'api_type']);


 if($_POST){
  try{
      if($stat=='0'){
          $olgaquery="INSERT INTO api_coupan SET createdIp='$myIp',datecreated='$dateceated',api_key='$api_key',api_type='$api_type',affiliate_id='$pub_id'"; 
		$stmt = $conn->prepare($olgaquery);
		if($stmt->execute()){
			$last_insert_id = $conn->lastInsertId();

			$_SESSION["created"] = $last_insert_id ;
			$json['status'] = true;
            $json['message'] =  "Save Successfully";
			// echo "<script>window.location='../brandreward.php';</script>";;
		}
          
      }else{
          $olgaquery="UPDATE api_coupan SET createdIp='$myIp',datecreated='$dateceated',api_key='$api_key',affiliate_id='$pub_id' WHERE api_type='$api_type' "; 
		$stmt = $conn->prepare($olgaquery);
		if($stmt->execute()){
			$last_insert_id = $conn->lastInsertId();

			$_SESSION["created"] = $last_insert_id ;
			$json['status'] = true;
            $json['message'] =  "Save Successfully";
			// echo "<script>window.location='../brandreward.php';</script>";;
		}
          
      }
		
 
 
   }
         
        // show error
        catch(PDOException $exception){
            die('ERROR: ' . $exception->getMessage());
        }
    }

echo json_encode($json);
?>