Change textbox value using dropdown selected in php and mysql

Question

I have texbox and dropdown list which is populated from mysql database.I want to change textbox value using dropdown list, without refreshing the page. Here is my code and Thanks in Advance.

<select name="select" id="dropdownlist1">
     <option id="0">-- Select the Company --</option>
           <?php
              require("dbcon.php");

        $getallcompanies = mysql_query("SELECT * FROM ifcandetails6");

        while($viewallcompanies = mysql_fetch_array($getallcompanies)){
             ?>
 <option id="<?php echo $viewallcompanies['tcuid']; ?>"><?php echo $viewallcompanies['tcname'] ?></option>
                <?php
                      }
                  ?>
              </select>

Here is my Input field code:

<input type="text" id="field1" value="<?php echo $viewallcompanies['tcname']?>" disabled/>

mysql_* is EVIL. Please google it first

Pratik Joshi
– Pratik Joshi

2015-07-05 18:16:27 +00:00
Commented Jul 5, 2015 at 18:16 — Pratik Joshi
– Pratik Joshi, Commented Jul 5, 2015 at 18:16

Pratik Joshi · Accepted Answer · 2015-07-05 17:53:37Z

1

Use following

   $(document).ready(function(){
    $("#dropdownlist1").change(function(){
        $("#field1").val($(this).val());
    });
   });

As you can do it on front side itself, you dont need to change in your PHP code. Add the following code on DOM ready.

answered Jul 5, 2015 at 17:53

Pratik Joshi

11.7k7 gold badges44 silver badges73 bronze badges

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

3 Comments

Pratik Joshi Over a year ago

@MuhammedParveezKhushaali , if it solves your problem , you can accept answer.

Muhammed Parveez Khushaali Over a year ago

i want to retrieve the saved data from database using the dropdown list.. but in this code i am getting the same value in inputbox what i am selecting in dropdown list..

Pratik Joshi Over a year ago

But you told .I want to change textbox value using dropdown list. Please First clarify the Question by editing it. There is Edit button.

Collectives™ on Stack Overflow

Change textbox value using dropdown selected in php and mysql

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related