<?php
include("include/connection.php");

$req_type = $_POST['req_type'];
$cat_id = $_POST['cat_id'];
$sub_cat_id = $_POST['sub_cat_id'];
$fr_id = $_POST['fr_id'];
$ptm = $_POST['ptm'];
$sptm = $_POST['sptm'];

switch($req_type)
{
    case 'get_sub_cat';
    {
        $qry_subcat="SELECT * FROM sub_category_master WHERE cat_id='$cat_id' ";
$rsc_subcat=mysqli_query($con,$qry_subcat);

echo '<option value="">Select</option>';
while($subCat = mysqli_fetch_assoc($rsc_subcat))
{
    echo '<option value="'.$subCat['sub_cat_id'].'">'.$subCat['sub_cat_name'].'</option>';
}
exit;        
    }

    case 'get_sub_cat2';
    {
        $qry_subcat="SELECT * FROM sub_category_master2 WHERE sub_cat_id='$sub_cat_id' ";
$rsc_subcat=mysqli_query($con,$qry_subcat);

echo '<option value="">Select</option>';
while($subCat = mysqli_fetch_assoc($rsc_subcat))
{
    echo '<option value="'.$subCat['sub_cat_id2'].'">'.$subCat['sub_cat_name2'].'</option>';
}
exit;        
    }
    
case 'get_fr';
    {
        $qry_fr="SELECT * FROM `feature_master` where fr_id='$fr_id' limit 1 ";
        $rsc_fr=mysqli_query($con,$qry_fr);
        $fr_det = mysqli_fetch_assoc($rsc_fr);
        $fr_v = explode(',',$fr_det['fr_value']);
        foreach($fr_v as $v)
        {
         echo '<option value="'.$v.'">'.$v.'</option>';   
        }
exit;        
    }    
    
    case 'get_subtype';
    {
        $qry_stype="SELECT * FROM sub_product_type_master where product_type_id='$ptm' limit 1 ";
        $rsc_stype=mysqli_query($con,$qry_stype);
        echo '<option value="">Select</option>';
        while($det = mysqli_fetch_assoc($rsc_stype))
        {
            echo '<option value="'.$det['sub_product_type_id'].'">'.$det['sub_product_type'].'</option>';
        }
exit;        
    }
    case 'get_subtype2';
    {
        $qry_stype="SELECT * FROM sub_product_type_master2 where product_type_id='$ptm' and sub_product_type='$sptm' limit 1 ";
        $rsc_stype=mysqli_query($con,$qry_stype);
        echo '<option value="">Select</option>';
        while($det = mysqli_fetch_assoc($rsc_stype))
        {
            echo '<option value="'.$det['sub_product_type_id2'].'">'.$det['sub_product_type2'].'</option>';
        }
exit;        
    }
    
}


?>