How can I access JSON objects from my call back to php script?

Question

From within my scrip.js file, I'm using jquery $.post function to post some data (Actually as of right now I'm just trying get my call back to work so I can read some data).

 $('document').ready(function(){

    $.post("index.php/main/showData", 
     function(data){
        console.log(data);
        for (var name in data){
            alert(name);
        }
     }, "json");
});

I'm using codeigniter to access to data the data from mysql:

class Main extends CI_Controller
{
    function showData()
{
    $this->load->model('ajax');
    $array = array($this->ajax->getRecArray());

    // $this->index();
    echo json_encode($array);
}

My model

class Ajax extends CI_Model
{
    function getRecArray()
{
    $query = $this->db->query("SELECT * FROM record_table WHERE id = 1");
    $row = $query->result();
    return $row;
}
}

When I console.log(data) I get:

[[Object { id="1", name="scott"}]]

My question is, How do I access the individual properties or objects from with script.js? For example, how do I access the value of name in that Object array?

Mahn · Accepted Answer · 2012-07-03 01:51:39Z

1

 $('document').ready(function(){

    $.post("index.php/main/showData", 
     function(data){
        console.log(data);
        for (var name in data[0][0]){
            alert(data[0][0][name]);
        }
     }, "json");
});

That should do it.

When you iterate over an object using for .. in, the specified variable doesn't contain the data, but the string of the member name. In JS you can access object members by the syntax data.member, or data["member"], and you will want to use the later in this case since you have the string.

Additionally in this specific case the data is an object inside an array which is inside an array, here is the returned data broken down by levels:

[
    [
        Object { 
            id="1", 
            name="scott"
        }
    ]
]

Hence why you need the syntax data[0][0][name]; this should be easy to fix in the PHP counter part.

edited Jul 3, 2012 at 1:51

answered Jul 3, 2012 at 1:34

Mahn

16.7k17 gold badges66 silver badges82 bronze badges

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

4 Comments

MikeTheCoder Over a year ago

With your solution, My alert dialog says [object Object].

Mahn Over a year ago

In fact see edit this time. Apparently you are getting an object inside an array inside an array, you should probably change your code a bit :)

MikeTheCoder Over a year ago

Okay, this is making sense now. I was able to shave off one of the arrays by passing in $this->ajax->getRecArray() directly in in my JSON_encode() function as an argument.

Mahn Over a year ago

If you only need one row from getRecArray, I think you can chop the second array by returning $row[0] instead of $row in getRecArray(), give it a try.

Collectives™ on Stack Overflow

How can I access JSON objects from my call back to php script?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related