CODEWITHSUNDEEP
phpjquerymysqlajax
Ayan Shaikh
Ayan Shaikh

Reputation: 35

Fetch Database Value in multiple textbox while selecting dropdown in php

I have two pages add_admin.php and ajax_admin.php when i select name in dropdown it display FIRSTNAME, MIDDLENAME and LASTNAME in TEXTBOXES.

HERE is My Code:

add_admin.php

<!-- Department -->
<div class="col-xs-12 col-sm-12 col-md-12" >
<div class="form-group">
    <select id="faculty_name" name="faculty_name" class="form-control" onchange='fetch_select(this.value)' required>
        <option selected="selected" disabled="disabled">Please Select Faculty</option>
        <?php
            $query = mysql_query("select * from faculty_details");
            while($row = mysql_fetch_array($query))
            {
        ?>
        <option value="<?php echo $row['FACULTY_ID'];?>"><?php echo $row['FIRSTNAME']." ".$row['MIDDLENAME']." ".$row['LASTNAME'];?></option>
        <?php
            }
        ?>
    </select>
</div>
</div>

<!-- First Name -->
<div class="col-xs-12 col-sm-4 col-md-4">
<div class="form-group">
    <div class="input-group">
    <div class="input-group-addon"><i class="fa fa-fw fa-user"></i></div>
        <input type="text" id="fname" name="fname" class="form-control input-md" placeholder="First Name" value="">
    </div>
</div>
</div>

other text box are there contaisn middlename, lastname

Ajax Code

function fetch_select(val)
{
    $.ajax
    ({
    type: 'post',
    url: 'ajax_admin.php',
    data: 
    {
        get_option:val
    },
    success: function (response) 
    {
        $('#fname').val(response);
    }
});

ajax_admin.php

<?php
    if(isset($_POST['get_option']))
    {
        $state = $_POST['get_option'];
        $find=mysql_query("select * from faculty_details where    FACULTY_ID=$state");
        while($row=mysql_fetch_array($find))
        {
        echo "$row[FIRSTNAME]";
        }
    }
?>

Upvotes: 2

Views: 2858

Answers (1)

Sarath Kumar
Sarath Kumar

Reputation: 1146

Get the result as json from the server so that you can easily use it in jQuery:
ajax-admin.php

if(isset($_POST['get_option']))
{
   $state = $_POST['get_option'];
   $row1=array();
   $find=mysql_query("select firstname,middlename,lastname from faculty_details where  FACULTY_ID=$state");

   while($row=mysql_fetch_array($find))
  {
    $row1[]=$row;
  }
  die(json_encode($row1));
}

Ajax Code

function fetch_val(val) {
    $.ajax({
        url:"ajax-admin.php",
        type:"POST",
        data:{"get_option":val},
        dataType:"JSON",
        success:function(data){
            $('#fname').val((data[0].firstname));
            $('#mname').val((data[0].middlename));
            $('#lname').val((data[0].lastname));

        }
    });
}

Upvotes: 1

Related Questions