Combobox基于另一个组合框

Question

I'm trying to do the following. I am selecting an item from a combobox then I want the values of the next combobox to be the result of a query based on the first selection. This is what I have so far.... HTML

    <fieldset>
<div class="form-group">
    <select class="custom-select" name="serviciuSelect" id="serviciuSelect" onchange="arataAngajat()">
      <option selected="">Selecteaza serviciul dorit</option>
      <?php foreach ($servicii as $item): ?> 
        <option value="<?php echo $item['denumire']; ?>"><?php echo $item['denumire']; ?></option>
      <?php endforeach;?>
    </select>
 </div>
</fieldset>

<fieldset>
<div class="form-group">
    <select class="custom-select" name="angajatSelect" id="angajatSelect" style="visibility: hidden">
      <option selected="">Selecteaza angajatul dorit</option>
      <!-- <?php foreach ($angajati as $item): ?> 
        <option value="<?php echo $item['nume']; ?>"><?php echo $item['nume']; ?></option>
      <?php endforeach;?> -->
    </select>
 </div>
</fieldset>

JavaScript

    <script>
    function arataAngajat() {
        document.getElementById("angajatSelect").style.visibility = "visible";
        var e = document.getElementById("serviciuSelect").value;
        document.cookie = "selectSer = " + e;  
   }
   </script>

PHP

    <?php 
function getSelectServiciu(){
    $selectServiciu= $_COOKIE['selectSer'];
    $query = "SELECT COD_A FROM angajat WHERE COD_A IN (
    SELECT COD_A FROM angajat_serviciu WHERE COD_S='".
    $selectServiciu."')";
    $result = $this->db->query($query)->result_array();
    return $result;
}
    ?>

I got stuck when I had to call the PHP function getSelectServiciu(). Also, If there's a better way of doing this, please let me know.

Thanks, Tibi

Answer 1

this script is get data from server under a service display as a combobox options

services.php

<?php

//i'm using array u can use mysql array
$services=array();
$services[]=array('name'=>'Flowers');
$services[]=array('name'=>'Fruits');

//data under services
$data=array();
$data['Flowers']=array('Rose','Belly');
$data['Fruits']=array('Banana','Mango');

//check the the client is requested for data under a service
if(isset($_GET['get_data'])){
$current_service=$_GET['get_data'];
$data_array=$data[$current_service];
echo  '<option selected="">Select</option>';
foreach($data_array as $op){
echo  '<option value="'.$op.'">'.$op.'</option>';
}
}else{
?>
 <fieldset>
<div class="form-group">
    <select class="custom-select" name="Services" id="Services" onchange="Getnext_option(this.value)">
      <option selected="">Select</option>
      <?php foreach ($services as $item): ?> 
        <option value="<?php echo $item['name']; ?>"><?php echo $item['name']; ?></option> <?php endforeach;?>
    </select>
 </div>
</fieldset>

<fieldset>
<div class="form-group">
    <select class="custom-select" name="Loaded_data" id="Loaded_data" style="display: none"> </select>
 </div>
</fieldset>

<script>function Getnext_option(id){
var load_to=document.getElementById('Loaded_data');
load_to.style.display="none";
var xhttp = new XMLHttpRequest();
  xhttp.onreadystatechange = function() {
    if (this.readyState == 4 && this.status == 200) {
      load_to.innerHTML=
      this.responseText;
        load_to.style.display="block";
    }
  };
  xhttp.open("GET","services.php?get_data="+id, true);//get data from server
  xhttp.send();
}</script>

<?php } ?>