<?php
// delete_variation.php
header('Content-Type: application/json');
require_once 'db.php'; // Your database connection file

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $attribute_id = isset($_POST['attribute_id']) ? intval($_POST['attribute_id']) : 0;
    $value_to_remove = isset($_POST['value']) ? trim($_POST['value']) : '';

    try {
        // First, get the current VARIATION_VAL
        $stmt = $con->prepare("SELECT VARIATION_VAL FROM attributes WHERE ID = ?");
        $stmt->bind_param("i", $attribute_id);
        $stmt->execute();
        $result = $stmt->get_result();
        $row = $result->fetch_assoc();
        
        if ($row) {
            // Convert comma-separated string to array
            $values = explode(',', $row['VARIATION_VAL']);
            
            // Remove the value
            $values = array_filter($values, function($v) use ($value_to_remove) {
                return trim($v) !== $value_to_remove;
            });
            
            // Convert back to comma-separated string
            $new_values = implode(',', $values);
            
            // Update the database
            $update_stmt = $con->prepare("UPDATE attributes SET VARIATION_VAL = ? WHERE ID = ?");
            $update_stmt->bind_param("si", $new_values, $attribute_id);
            $success = $update_stmt->execute();
            
            echo json_encode(['success' => $success]);
        } else {
            echo json_encode(['success' => false, 'error' => 'Attribute not found']);
        }
    } catch (Exception $e) {
        echo json_encode(['success' => false, 'error' => $e->getMessage()]);
    }
} else {
    echo json_encode(['success' => false, 'error' => 'Invalid request method']);
}