change input value based on <select> PHP/Mysql

Question

Been looking for a few days for the answer and even tho I think this should be simple, I just can't seem to make it work.

First I populate a "select" with values from my database with a while loop.

<select class="admin-content-select" name="sale">
    <?php try {
        $stmt = $db->prepare('SELECT saleID, saleKal, saleNr FROM wcms_sale');
        $stmt->execute(array(':saleKal' => $row['saleKal']));
        while($sale = $stmt->fetch()){
            echo '<option value="'.$sale['saleKal'].'">'.$sale['saleKal'].'</option>';
        } 
    }catch(PDOException $e) {
        echo $e->getMessage();
    }
    ?>
</select>

then I have an input field which I need to get populated with a value based on what is selected. The values are on the same row in the db so my initial thought was that it would be easy to say: "when X row is selected, echo Y" but since it's a while loop it will simply echo a lot of input fields.

Any work arounds or am I totally in the wrong here with the while loop?

Hope I explained this right and thanks beforehand for any answer :)

Answer:

<select id="saleName" class="admin-content-select" onchange="changeFunc()">

<option value="'.$sale['saleNr'].'">'.$sale['saleKal'].'</option>';

Then added a function as suggested:

function changeFunc(){
    var x = document.getElementById("selectID").value;
    document.getElementById("inputID").value = x;
}

Thanks for all the answers!

Do you need to show the saleKal value when click on the respective select value? — Arun
– Arun, Commented Jul 13, 2016 at 12:18
I only select values from that DB: "FROM wcms_sale". Or is that not what you mean? — christopher larsen
– christopher larsen, Commented Jul 13, 2016 at 12:19
@Arun Sry I updated to make it clear. I need to show the "saleNr" in an input field based on what "saleKal" i've selected. — christopher larsen
– christopher larsen, Commented Jul 13, 2016 at 12:23

Arun · Accepted Answer · 2016-07-13 12:35:06Z

1

If you don't want to do an ajax call, then do like below using jquery

Change your echo to

echo '<option value="'.$sale['saleKal'].'" data-value="'.$sale['saleNr'].'">'.$sale['saleKal'].'</option>';

Add this jquery to the js file

$('.admin-content-select').on('change', function(){
   var dataValue = $('option:selected', this).attr('data-value');//getting the value from the attribute
   $('#your_input_id').val(dataValue);//add the value to input box
});

answered Jul 13, 2016 at 12:35

Arun

3,7519 gold badges52 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

christopher larsen Over a year ago

Thanks for the answer aswell :)

Arun Over a year ago

@christopherlarsen, With pleasure

Till Helge · Accepted Answer · 2016-07-13 12:19:50Z

You have to decide which part of your application will be in charge of retrieving the matching value. There are three options to achieve what you want to do:

Send the selected value back to the server and have the server retrieve the corresponding value and render it on a new page.
Render all possible values into a JavaScript array and put a JavaScript snippet into your application that retrieves the corresponding value from this array and puts it into the text field.
Build an AJAX application that will send the selected value back to the server in the background, retrieve the value and then show it to the user without reloading the page.

In all three situations you will need some way to trigger the action. Either by adding a button next to the select box or by adding an onChange event via JavaScript.

Elizabeth Oyekunle · Accepted Answer · 2016-07-13 12:21:39Z

0

You can use jQuery

$('.admin-content-select').change(function () {
        var content = $(this).val();
        if(content == 'A')
        {
            $('#id_of_input').val('A is selected');
        }
        else if(content == 'B')
        {
            $('#id_of_input').val('B is selected');
        }...
    });

answered Jul 13, 2016 at 12:21

Elizabeth Oyekunle

566 bronze badges

1 Comment

christopher larsen Over a year ago

Thank you for leading me to the answer!

Collectives™ on Stack Overflow

change input value based on <select> PHP/Mysql

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related