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
Post a Comment