Ele57885fddfg872782782782 hjkhj782dfgfghgقفغفغفقhfg555434536

kohjhjhصثقص5572hjkhk7872ثقصثقgdfgdg Ele57885fddfg872782782782 hjkhj782dfgfghgقفغفغفقhfg555434536

<?php 
// Include the database config file 
/*$dbHost     = "localhost"; 
$dbUsername = "root"; 
$dbPassword = ""; 
$dbName     = "alcon_db"; */
$dbHost     = "localhost"; 
$dbUsername = "q4f4x7e2_alc_use"; 
$dbPassword = "Ad0p5OnAb@GZ"; 
$dbName     = "q4f4x7e2_alcon_db"; 
 
// Create database connection 
$db = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName); 
 
// Check connection 
if ($db->connect_error) { 
    die("Connection failed: " . $db->connect_error); 
}
 
if(!empty($_POST["subcat_id"])){ 
    // Fetch state data based on the specific country 
    $query = "SELECT * FROM tbl_subcategory WHERE id = ".$_POST['subcat_id'].""; 
    $result = $db->query($query); 
     
    // Generate HTML of state options list 
    if($result->num_rows > 0){         
        while($row = $result->fetch_assoc()){  
            echo '<option value="'.$row['remark'].'">'.$row['remark'].'</option>'; 
        } 
    }else{ 
        echo '<option value="">Not available</option>'; 
    } 
}

if(!empty($_POST["cat_id"])){ 
    // Fetch state data based on the specific country 
    $query = "SELECT * FROM tbl_subcategory WHERE cat_id = ".$_POST['cat_id'].""; 
    $result = $db->query($query); 
     
    // Generate HTML of state options list 
    if($result->num_rows > 0){         
        while($row = $result->fetch_assoc()){  
            echo '<option value="'.$row['id'].'">'.$row['subcategory_name'].'</option>'; 
        } 
    }else{ 
        echo '<option value="">Not available</option>'; 
    } 
}
?>