jquery - Retrieving data from JSON array (PHP) and populating textboxes -


i'm trying pull data gathered mysql query referenced below , populate corresponding textboxes data:

<?php header('content-type: application/json');  $server = "••••"; $username = "••••"; $password = "••••"; $database = "••••";  $username_pull = $_post['a_username'];  $con = mysql_connect($server, $username, $password) or die ("could not connect: " . mysql_error()); mysql_select_db($database, $con);  $sql = "select uname, pword, fullname, phone_num, email_add, car_details app_login uname = '$username_pull'"; $result = mysql_query($sql) or die ("query error: " . mysql_error());  $records = array();  while($row = mysql_fetch_assoc($result)) {     $records[] = $row; }  mysql_close($con);  echo $_get['jsoncallback'] . json_encode($records);  ?> 

if insert in $username_pull = "admin", following json info, know works:

[{"uname":"admin","pword":"password","fullname":"john smith","phone_num":"123-456-7890","email_add":"john@website.com","car_details":"2013 black cadillac ats"}] 

here's json callback function:

function fillthegap()  {     var f_uname = $("#a_username").val();      $.ajax({         url: "login2.php",         data: f_uname,         datatype: "jsonp",         jsonp: "jsoncallback",         success: function(data)          {                 $("#a_phonenum").val(data.phone_num);             $("#a_fullname").val(data.fullname);             $("#a_email").val(data.email_add);             $("#a_cardetails").val(data.car_details);             },}); } 

here's form initiates data pulling:

    <form name="check_user" method="" action="post">         username:          <input id="a_username" name="a_username" type="text" onblur="fillthegap()">         full name:          <input id="a_fullname" name="a_fullname" type="text">         phone num:         <input id="a_phonenum" name="a_phonenum" type="text">         <input name="submit" type="button" value="submit"> </form> 

how make populates textboxes corresponding id name?

i appreciate everyone's in advance!

try this:

data = {"uname":"admin","pword":"password","fullname":"john smith","phone_num":"123-456-7890","email_add":"john@website.com","car_details":"2013 black cadillac ats"}  $.each(data, function(key, value){        $("#a_"+key).val(value); }); 

so function should like:

function fillthegap()  {     var f_uname = $("#a_username").val();      $.ajax({         url: "login2.php",         data: f_uname,         datatype: "jsonp",         jsonp: "jsoncallback",         success: function(data)          {               $.each(data, function(key, value){                  $("#a_"+key).val(value);               });         }     }); } 

also can try here: http://jsfiddle.net/nhkks/


Comments

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

c++ - qgraphicsview horizontal scrolling always has a vertical delta -