����
������������������������������������
<?php
// store.php

// Include the database connection file
require_once 'database.php';

// Set headers for JSON response
header('Content-Type: application/json');

// Define company details
$company_id = 1234;
$company_name = 'Haris Isani';


// Get the raw POST data
$raw_data = file_get_contents('php://input');

// Decode JSON data if it's in JSON format
$post_data = json_decode($raw_data, true);

// If JSON decoding fails, treat it as raw data
if (json_last_error() !== JSON_ERROR_NONE) {
    $post_data = $raw_data;
}


try {
    // Prepare the SQL query to insert data
    $stmt = $pdo->prepare("
        INSERT INTO webhookdata_1234 (api_call_type,company_id, company_name, data_type, event, data)
        VALUES (:api_call_type,:company_id, :company_name, :data_type, :event, :data)
    ");

    // Bind parameters
      $stmt->bindParam(':api_call_type',$_SERVER['REQUEST_METHOD']);
    $stmt->bindParam(':company_id', $company_id, PDO::PARAM_INT);
    $stmt->bindParam(':company_name', $company_name, PDO::PARAM_STR);
    $stmt->bindValue(':data_type', is_array($post_data) ? 'JSON' : 'RAW', PDO::PARAM_STR);
    $stmt->bindValue(':event', $post_data['Event'], PDO::PARAM_STR); // Default event name
    $stmt->bindParam(':data', $raw_data, PDO::PARAM_STR);

    // Execute the query
    $stmt->execute();

    // Return success response
    echo json_encode([
        'status' => 'success',
        'message' => 'Data stored successfully',
        'data' => $post_data
    ]);
} catch (PDOException $e) {
    // Handle database errors
    http_response_code(500);
    echo json_encode([
        'status' => 'error',
        'message' => 'Failed to store data: ' . $e->getMessage()
    ]);
}
?>