Search code examples
javascriptphpbootstrap-multiselect

How to populate Bootstrap Multiselect with selected values in php?


I am trying to populate Bootstrap multiselect , I used the following code html

<form>
   <tr>
      <td><label>Code Planteur :</label></td>
      <td> <input type="text" id="code_planteur" name="code_planteur" class="code_planteur"></td>
   </tr>
   <tr>
      <td><label>Numero de Ticket :</label></td>
      <td><select id="num_ticket" name="num_ticket" class="num_ticket">
          <option value="0"> numero de ticket </option>
          </select></td> 
   </tr>
</form>

and my php file ticket.php

<?php
    require 'conn.php';
        if($_POST['id'])
       {
            $id=$_POST['id'];
            $req="select column from table where code_planteur='".$id."' ";
            $req = $pdo->query($req);
            $results = array();
                while($row=$req->fetch())

                    {
                      $data=$row['column'];
                      echo "<option value=".$data.">".$data."</option>";
                    }

        }
?>

my javascript

$(document).ready(function(){
$(".code_planteur").change(function(){
     var id=$(this).val();
     var dataString = 'id='+ id;
$.ajax({
     type: "POST",
     url: "ticket.php",
     data: dataString,
     cache: false,
     success: function(html){
$(".num_ticket").html(html);
                } 
            });
    });});

how can i transforme my code to use with bootstrap multiselect

example https://jsfiddle.net/j086fkdf/


Solution

  • it work with this javascript

    $(document).ready(function()
    {
       $(".code_planteur").change(function()
            {
                 var id=$(this).val();
                 var dataString = 'id='+ id;
                 $.ajax({type: "POST",
                    url: "ticket1.php",
                    data: dataString,
                    cache: false,
                    dataType: "json",
                    success: function(data)
                        {
                            $("#num_ticket").empty();
                            $.each(data, function (key, val) {
                            $("#num_ticket").append('<option value="' + val + '">' + val + '</option>');
    
                        });
    
                             $("#num_ticket").attr('multiple', 'multiple'); 
                             $("#num_ticket").multiselect(); 
    
    
    
                        } 
    
                    }
                );
            }
        );
    });
    

    and my ticket1.php

    <?php
         require "conn.php";
    
            if($_POST['id']){
    
              $id=$_POST['id'];
              $req="select num_ticket from paiement where code_planteur='".$id."' ";
              $req = $pdo->query($req);
    
                 while ($row=$req->fetch() ){
    
                     $resultat[] = $row['num_ticket'];
                    } 
    
                 echo json_encode($resultat);
    
            }
    

    ?>