~NAXC~

File Content: `fetch_checkbox.php`

<?php 
include 'new_con.php';
$sqlfun = new sqlfunction();
$admin = new admin_login();


if(isset($_POST['brand_id']))
{
    $brand_id = $_POST['brand_id'];
    //echo "select id,name from cat where id not in(select cat_id from rest_cat where r_id = '$res_id');";
    $check=$sqlfun->query("select id , m_name from model where b_id ='$brand_id'");
    // print_r($check);
    // die;
    if($check->rowCount() > 0){
        echo "<option value=''>Select Model</option>";
        while($row=$check->fetch(PDO::FETCH_OBJ)){
            // print_r($row);
            // die;
            $id = $row->id;  
            $name = $row->m_name;
            echo '<option value = "'.$row->id.'">'.$name.'</option>';  
        }
    }
    else
    {
        echo '<option value = "">model not found</option>';
    }

}

if(isset($_POST['model_id']))
{
    $model_id = $_POST['model_id'];
    // $brand_id=$_POST['brand_id'];
    //echo "select id,name from cat where id not in(select cat_id from rest_cat where r_id = '$res_id');";
    $checks=$sqlfun->query("select id , s_id from add_model_acc where m_id ='$model_id'");
    print_r($check);
    // die;
    if($checks->rowCount() > 0){
    echo "<option value=''>Select Accessories</option>";
        while($rows=$checks->fetch(PDO::FETCH_OBJ)){
            // print_r($row);
            // die;
            $s_id = $rows->s_id;  
            $cnd_s="id='$s_id'";
            $check_s = $sqlfun->fetchdata("subcat",$cnd_s);
            $row_s=$check_s->fetch(PDO::FETCH_OBJ);
            $name = $row_s->subcat;
            echo '<option value = "'.$rows->s_id.'">'.$name.'</option>';  
        }
    }
    else
    {
        echo '<option value = "">Accessories not found</option>';
    }

}









 
?>
File Content: fetch_checkbox.php

File Content: `fetch_checkbox.php`
