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/
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);
}
?>