php - How can I display value in each textbox in loop that the value based on the value selected in its combobox?

I tried to write codes which display value in textbox based on value selected in combobox, but I have one problem I puted combobox and texbox in loop but only first row can display value of selected item in combobox where I want each row to display value based on value selected in its combobox Below are my codes

<?php
require_once('connection.php');
for($counter=0;$counter<=1;$counter++)
{
$queItem= mysqli_query($connect,"select * from oitm");
echo"<select name=\"segment_id\" class=\"form-control\" id=\"segment_id\" STYLE=\"width: 300px\" >";
echo"<option value=\"\" selected=\"selected\">Select a product</option>";

            while($rowStockIn = mysqli_fetch_array($queItem))
            {
            $ItemCode2=$rowStockIn['ItemCode'];
            $ItemName2=$rowStockIn['ItemName'];
            $ItemPrice2=$rowStockIn['ItemPrice'];

            echo "<option value=\"$ItemCode2\" data-itemprice = \"$ItemPrice2\">
        $ItemCode2 $ItemName2";
            }
echo"</select>";
?>
</span>
<?php   
echo"<input id=\"title\" name=\"title\" type=\"text\" value=\"$ItemPrice2\"
><br/>";
}
?>





        <script>
$(document).ready(function(){
    $("#segment_id").on('change', function () {
        var id = $(this).val(); 
        var itemprice = $('option:selected',this).data('itemprice');
        $("#title").val(itemprice);
    });
});
        </script>
Copy code

I think I have to edit jQuery in order to allow each row to work

Please anyone can help me

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.