Get the id value PHP, mysql, jquery

Question

I want to get the ID value in the department_tbl and put it in the TextBox instead of Alert.

<select name="departmentlvl" id="departmentlvl">
    <option value="" >Choose Department Level</option>
    <?php
        $qry="Select * from department_tbl";
        $result=mysqli_query($conn,$qry);
        while($row = mysqli_fetch_array($result))
        {
            extract($row);
            echo "<option value='".$department_id."'>".$departmentDesc."
         </option>";

        }
    ?> 
</select>
<input type="text" id="" value="">// put the id value here($department_id)

//jquery
$(document).ready(function() {
    $("#departmentlvl").on('change', function () {
        alert($(this).val());
    });
});

Sanjit Bhardwaj · Accepted Answer · 2018-01-27 05:31:50Z

2

Make a id attribute for the input field i.e

 <input type="text" id="department_id" value="">

On the jquery function just put the value

//jquery
$(document).ready(function() {
$("#departmentlvl").on('change', function () {
    $("#department_id").val($(this).val());
  });});

answered Jan 27, 2018 at 5:31

Sanjit Bhardwaj

8937 silver badges14 bronze badges

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

1 Comment

Sanjit Bhardwaj Over a year ago

glad... i helped :)

Sudhakar · Accepted Answer · 2018-01-27 09:58:17Z

0

you can give id or name to text field and later access it using the same e.g

<input type="text" name="myfirstinput" id="firstinput" />

//using name
$("input[name=myfirstinput]").val("demo");

//using id 
$("#firstinput").val("demo");

answered Jan 27, 2018 at 9:58

Sudhakar

3243 silver badges9 bronze badges

Collectives™ on Stack Overflow

Get the id value PHP, mysql, jquery

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related