function log_api_call($conn, $api_type, $call_type, $status, $details = null) {
    $stmt = $conn->prepare("INSERT INTO api_call_logs (api_type, call_type, status, details) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("ssss", $api_type, $call_type, $status, $details);
    $stmt->execute();
    $stmt->close();
}