How to fill a text input depending on a drop down list selection

Question

I have a drop down list:

<select  class="form-control" name = "Terminal_ID" id = "Terminal_ID" onchange="updateValue();">
<option>Select</option>
<?php
    $query="SELECT *  FROM mytable";
    $result=mysqli_query($con,$query);
    while($rows=mysqli_fetch_array($result2))
    {
            $tid=$rows['Idcolumn'];
            $tn=$rows['Namecolumn'];
    ?>  
    <option value="<?=$tn;?>"><?=$tid;?></option> 
    <?php
    }
    ?>
</select>

and a text input box

<input class="form-control" type="text" id="textboxid" name="tname" />

I have this on updateValue function in javascript:

function updateValue()
    {
$('#textboxid').val($('#Terminal_ID').val());
    }

    $(document).ready(function () {
    updateValue();
});

It work's, since it shows the value of $tn in my text input box. The problem is that, the function change the value of the selection in the dropdown list. and if, i want to use the selection of the drop down to insert some data in my database it sends me the $tn value, and i need the $tid value. If I change this <option value="<?=$tn;?>"> to <option value="<?=$tid;?>"> it change the value of the text input box. Is there anything i can modify to this code to get the $tn as value in text input box and the $tid as value of the selection?

None of this questions answer to the mine, since i have to take values from my database and i can't use the text or the value of the drop down list. I have already done that. What i need is to fill the text input box having as condition the selection on the dropdown list. Pleas don't mark it as dublicate — irena, Sep 27 '17 at 15:25

A l w a y s S u n n y · Answer 1 · 2017-09-27T15:37:01.313

0

if you set your html option like this,

HTML

<option value="<?=$tid;?>"><?=$tn;?></option>

JS

function updateValue()
{
  $('#textboxid').val($('#Terminal_ID option:selected').text()); // this will set name 
}

$(document).ready(function () {
    updateValue();
});

edited Sep 27 '17 at 15:37

answered Sep 27 '17 at 15:13

A l w a y s S u n n y

36,497
8
60
103

this shows all the possible values of the drop down list in my text input box – irena Sep 27 '17 at 15:15
how can i get the `tn` value if i don't put it as a value or as a text on the dropdown list? – irena Sep 27 '17 at 15:21
@irena see my edit – A l w a y s S u n n y Sep 27 '17 at 15:37
if i set my option like that the combo box will have the value of `$tid `but it will show in my page the records of `$tn`. – irena Sep 28 '17 at 06:48

score 0 · Answer 2 · answered Sep 27 '17 at 15:36

0

you can update you function like below that fix your problem

    function updateValue()
    {
    $('#textboxid').val($('#Terminal_ID option:selected').text());
    }

answered Sep 27 '17 at 15:36

sonsor

31
2

How to fill a text input depending on a drop down list selection

2 Answers2