How to Make Editable Select Box using jQuery with PHP

Learn How to Create Editable Select Box using jQuery Editable Select plugin in PHP Script. How to make Editable HTML Combo Box with Autocomplete by using jQuery with PHP script. How to use Dynamic Editable Dropdown Listbox with PHP based Form application.

[janisstrazdins]

Excelent! Thank you!...i have one question...why in fetch.php is so important to use class="btn btn-primary btn-xs edit" on button edit? It stops working without it (at least edit class needs to be used) ...which seems really strange

[balajovidiu]

Thank you for this video. Do you have one where you explain how to create that beautiful web address? I'd appreciate it. Thank you in advance for your reply.

[Sanjay]

It work up to 800 entry beyond that it get hang

[freeblackbeauty]

Hi Webslesson team
Sir I have a big problem in a project inventory management which is how to show quantity in stock
when i select order product, I tried this solution but it did not work



var product_id =
var btn_action = 'load_qte';

$.ajax({
url:"order_action.php",
method:"POST",
data:{product_id:product_id, btn_action:btn_action},
success:function(data)
{
$('#qte_stock').html(data);

}
});

});

html += '<select name="product_id[]" id="product_id" class="form-control selectpicker" data-live-search="true" required>';
html += '<?php echo ?>';

html += '<div class="col-md-2">';
html += '<input type="text" name="qte_stock" id"qte_stock" value="" class="form-control" readonly/>';
html += '</div>';


if($_POST['btn_action'] == 'load_qte')
{
$output=' $qte = available_product_quantity($connect, $_POST["product_id"])';
 };
echo $output;
Where is the problem

have this ugly
which to add qte to select

function
{
$query = "
SELECT * FROM product
WHERE product_status = 'active'
ORDER BY product_name ASC
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$output = '';
foreach($result as $row)
{
$product_id= $row["product_id"];
$qte = available_product_quantity($connect, $product_id);

$output .= '<option '.$row["product_name"].' --> '.$qte.' </option>';

}
return $output;
}

thank you a lot