jquery array

[pradeepjain]

hi guys ,

$("#patient_id").change(function(){
$.post("/diabetes/patient_detail_change.php",{ location:$("#location").val(),doctor:$("#doctor").val(),patient_id:$("#patient_id").val()} ,function(data){
alert(data);
//$("#patient_id").html(data);
});
    });

i have written a code like this. It returns a array of value like Name => 'pradeep',Age=> '23'
i.e data is array

there are form fields like Name and Age. I need to take the values from the data and set it to each form fields how to do this.how to deal with arrays in jquery.

[pradeepjain]

i outputted the array its like

{"Patient_id":"R00020","Name":"admin","Age":"12"," Weight":"67","Gest_age":"2"}
i tried to iterate through it by using this code

$.each(data, function(key, value) { 
alert(key + ': ' + value); 
});
 

but its not working . Is anything wrong?

[Dormilich]

the only thing on my mind … debug by hand using Firebug and setting breakpoints.

[pradeepjain]

when i am printing it ,its printing like 0 :P 1:a 2:t .its taking each letter as an array element.

[pradeepjain]

no solution to this prob?

[zorgi]

Ok I am trying to understand what you need. Basicly you have a form and you have array. You want to populate your form with values from this array? If so can you copy/paste your form?

[pradeepjain]

i am getting the array in jquey in format
{"Patient_id":"R00020","Name":"admin","Age":"12 "," Weight":"67","Gest_age":"2"}

is this the rite format?

[zorgi]

var my_var = {"Patient_id":"R00020","Name":"admin","Age":"12"," Weight":"67","Gest_age":"2"}
 

Yes you could do it that way

[zorgi]

You might want to have a look here JSON

[pradeepjain]

i use php for server side scripting . i use json to convert php array to jquery required format array and sent it back to jquery and tried to iterate but the iteration is not happening.

[zorgi]

If you want to iterate through JSON

var my_json = {"Patient_id":"R00020","Name":"admin","Age":"12"," Weight":"67","Gest_age":"2"};
$.each(my_json, function(i){alert(this)})
 

Or if you want to iterate through form elements:

$(function(){
           $("form > *").each(function(){alert(this.name)})
           })
 

[pradeepjain]

i will give this a try and let u know.

each of this key values is a form element like,Patient_id,Name,Age. how do i take these values from array and give the form elements these values.

[pradeepjain]

i am posting the code for help

here the jquery is printing properly if my_json array is passed but if i pass data which i returned from php code its not printing properly

$("#patient_id").change(function(){
$.post("/diabetes/patient_detail_change.php",{ location:$("#location").val(),doctor:$("#doctor").val(),patient_id:$("#patient_id").val()} ,function(data){
alert(data);
 
 var my_json = {"Patient_id":"R00020","Name":"admin","Age":"12"," Weight":"67","Gest_age":"2"};
//alert(my_json);
$.each(my_json, function(i){alert(this)});

patient_detail_change.php

<?php
include_once('db.php');
$location = $_POST['location'];
$doctor = $_POST['doctor'];
$patient_id = $_POST['patient_id'];
if(($location != "") && ($doctor != "")){
$sql = "select Name,Age,Gest_age,Weight from rop_form where Location = '".$location."' and Doctor = '".$doctor."' and Patient_id = '".$patient_id."'";
$result = mysql_query($sql);
$myresult  = "";
while($row = mysql_fetch_array($result))
        {
        $myresult['Patient_id'] = "R".$patient_id;
        $myresult['Name'] = $row['Name'];
        $myresult['Age'] = $row['Age'];
        $myresult['Weight'] = $row['Weight'];
        $myresult['Gest_age'] = $row['Gest_age'];
        $myresult = json_encode($myresult);
        }
}
else
{
$myresult .= "";
}
echo $myresult;
?>
 

[pradeepjain]

hope ma code is clear enough!

[zorgi]

$.post("/diabetes/patient_detail_change.php", function(json_data){alert(json_data);})
 

That should clear it up.

I didnt check your patient_detail_change.php at all but glanced over. You have variable $myresult that keeps changing type from string to array back to string. Even though that php is loosely typed language and will allow you to do things like that you should be avoiding it. Imagine you have 5000 lines of code and your variables keeps changing type like that. It would be very difficult to understand or to read code like that.

[pradeepjain]

nope man it did not work :(

see the code
jquery code:

$("#patient_id").change(function(){
$.post("/diabetes/patient_detail_change.php",{ location:$("#location").val(),doctor:$("#doctor").val(),patient_id:$("#patient_id").val()} ,function(json_data){
 
alert(json_data);
 
$.each(json_data, function(key,value){
alert(key + ': ' + value);
if(key == 'Name'){ $("#name").val(value);}
if(key == 'Age'){ $("#age").val(value);}
if(key == 'Weight'){ $("#ropweight").val(value);}
if(key == 'Gest_age'){ $("#gest_age").val(value);}
 
});
 
});
    });

the alert(json_data); line prints this

{"Patient_id":"R00008","Name":"","Age":"12","Weigh t":"67","Gest_age":"2"}

but the alert(key + ': ' + value); is printing like
0:{ 1:P 2:a and so on .

the php code is like this and as u pointed out i have corrected the variable and array issue

<?php
include_once('db.php');
$location = $_POST['location'];
$doctor = $_POST['doctor'];
$patient_id = $_POST['patient_id'];
if(($location != "") && ($doctor != "")){
$sql = "select Name,Age,Gest_age,Weight from rop_form where Location = '".$location."' and Doctor = '".$doctor."' and Patient_id = '".$patient_id."'";
$result = mysql_query($sql);
$myresult  = "";
while($row = mysql_fetch_array($result))
        {
        $myresult1['Patient_id'] = 'R'.$patient_id;
        $myresult1['Name'] = $row['Name'];
        $myresult1['Age'] = $row['Age'];
        $myresult1['Weight'] = $row['Weight'];
        $myresult1['Gest_age'] = $row['Gest_age'];
        }
        $myresult = json_encode($myresult1);
}
else
{
$myresult .= "";
}
echo $myresult;
?>

[zorgi]

$.getJSON("/diabetes/patient_detail_change.php", function(json_data){ $.each(json_data, function(i){alert(i + ":" + this)})})
 

Hope this works

[pradeepjain]

nope.its not printing anything at all now after adding getJSON

[zorgi]

$_GET instead of $_POST.

More info about getJSON here

[pradeepjain]

hii i had to use something like

$("#patient_id").change(function(){
$("#name").val('');
$("#Age").val('');
$("#ropweight").val('');
$("#Gest_age").val('');
 
$.getJSON (
  "/diabetes/patient_detail_change.php",
  { 
    location:$("#location").val(),
    doctor:$("#doctor").val(),
    patient_id:$("#patient_id").val()
  }, 
 
  function (json_data){
 
    if (json_data.Name) { $("#name").val(json_data.Name);}
    if (json_data.Age) { $("#age").val(json_data.Age);}
    if (json_data.Weight) { $("#ropweight").val(json_data.Weight);}
    if (json_data.Gest_age) { $("#gest_age").val(json_data.Gest_age);}
  }, 
  "Json"
);
});

and $_GET in the php file. :).thanks for all the help!