<?php
// Connect to your database
include'../../admin/dbc.php'; 

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

if(isset($_POST["categoryId"])) {
    $categoryId = $_POST["categoryId"];
    
    // Fetch subcategories for the selected category
    $query = "SELECT id, name FROM tbl_subcategory WHERE category_id = ?";
    $stmt = $conn->prepare($query);
    $stmt->bind_param("i", $categoryId);
    $stmt->execute();
    $result = $stmt->get_result();

    // Generate subcategory dropdown options
    $options = "<option value=''>Select a subcategory</option>";
    while ($row = $result->fetch_assoc()) {
        $options .= "<option value='{$row["id"]}'>{$row["name"]}</option>";
    }
    
    echo $options;
}
?>