Welcome Guest, Not a member yet? Register   Sign In
Ajax concatenate query
#1

Hi, sorry for english, i have 3 select input , i want concatenate , by selecting a value of first select only some values are show in second select , the same for the third.


This is my html ,this code is for the first and second select :


Code:
<div class="col-md-4 text-center login_form">
                 
                 <?= form_label('Regione*:' ,'regione',"class='black'") ;?>
                  <br>
                 <div class="form-group">
                    <div class="col-md-12 col-sm-12 col-xs-12">
                 <select id="regione_id" name="regione" >
                 <option value="" selected="selected">Regione --</option>
                   
                 <?php  foreach($regioni->result() as $regione) : ?>
                 <option value="<?php echo $regione->id ; ?>"><?php echo $regione->regione; ?></option>
                 <?php endforeach ; ?>
                 </select>
                    </div>
                 </div>
                 
             
           </div>
            <div class="col-md-4 text-center login_form">
                 <p>
                 <?= form_label('Provincia*:' ,'provincia',"class='black'") ;?>
                  <br>
                  <div class="form-group">
                    <div class="col-md-12 col-sm-12 col-xs-12">
                 <select id="province_id" name="province" >
                 
                 </select>
                    </div>
                 </div>
                 
             </p>
           </div>

this is the ajax:

Code:
<script
 src="https://code.jquery.com/jquery-3.2.1.min.js"
 integrity="sha256-hwg4gsxgFZhOsEEamdOYGBf13FyQuiTwlAQgxVSNgt4="
 crossorigin="anonymous"></script>

<script>

$(document).ready(function() {
 $("#regione_id").change(function(){
   
   var regione = $("#regione_id").val();
   
   $.ajax({
     type: "POST",
     url: "<?php echo base_url(); ?>index.php/user/get_province",
     data: "regione=1"  ,
     dataType: "html",
     success: function(msg)
     {
       $("#province_id").html(msg);
     },
     error: function()
     {
       alert("Chiamata fallita, si prega di riprovare...");
     }
   });
 });
});
</script>

this is the get_province() :

Code:
 public function get_province(){
       
     $regioni_id=$this->input->post('regione');
     
     $query = $this->db->query("SELECT * FROM  province WHERE id_regione= $regioni_id  ");
     echo '<option value="" selected="selected">-- seleziona --</option>';
        foreach($query->result() as $province){
       
        $id=$province->id;
        $provincia=$province->provincia;
        echo "<option value='$id'>$provincia</option>";
 
        }
     }
     



But when i change a value of first select i have error alert :  "Chiamata fallita, si prega di riprovare..."

how can i solve ?
Reply


Messages In This Thread
Ajax concatenate query - by pippuccio76 - 07-10-2017, 01:50 PM
RE: Ajax concatenate query - by rtenny - 07-12-2017, 08:50 AM
RE: Ajax concatenate query - by pippuccio76 - 07-12-2017, 09:16 AM
RE: Ajax concatenate query - by rtenny - 07-12-2017, 08:55 AM
RE: Ajax concatenate query - by pippuccio76 - 07-12-2017, 09:22 AM
RE: Ajax concatenate query - by Paradinight - 07-12-2017, 09:43 AM
RE: Ajax concatenate query - by pippuccio76 - 07-12-2017, 10:58 AM
RE: Ajax concatenate query - by Paradinight - 07-12-2017, 11:08 AM
RE: Ajax concatenate query - by ivantcholakov - 07-12-2017, 11:12 AM
RE: Ajax concatenate query - by pippuccio76 - 07-12-2017, 12:08 PM
RE: Ajax concatenate query - by Wouter60 - 07-12-2017, 11:40 AM
RE: Ajax concatenate query - by ivantcholakov - 07-12-2017, 12:19 PM
RE: Ajax concatenate query - by pippuccio76 - 07-13-2017, 09:13 AM
RE: Ajax concatenate query - by pippuccio76 - 07-13-2017, 09:44 AM
RE: Ajax concatenate query - by pippuccio76 - 07-13-2017, 10:44 AM
RE: Ajax concatenate query - by Paradinight - 07-13-2017, 10:52 AM
RE: Ajax concatenate query - by pippuccio76 - 07-13-2017, 11:36 AM
RE: Ajax concatenate query - by pippuccio76 - 07-14-2017, 04:16 AM
RE: Ajax concatenate query - by Paradinight - 07-13-2017, 10:45 AM
RE: Ajax concatenate query - by skunkbad - 07-12-2017, 03:37 PM
RE: Ajax concatenate query - by pippuccio76 - 07-13-2017, 04:13 AM



Theme © iAndrew 2016 - Forum software by © MyBB