json output is not as what expected

Question

I have the following code which generates a good json output but it has '[' and ']' at the start and end respectively. You can also check the output at

http://android.ezinfotec.com/functions.php?method=getquestions

$query = mysql_query("select * from questions");
$i = 0;
        while($fetch = mysql_fetch_array($query))
        {

$output[] = array (
            "row".$i => array   (
                "id" => $fetch['id'],
                "answers" => $fetch['answers'],
                "status" => $fetch['ans_status'],
                "postedon" => substr($fetch['month'],0,3).' '.$fetch['day'].' '.$fetch['year'],
                "question" => $fetch['question'],
                "category" => $fetch['category'],
                "parent" => $fetch['parentcategory'],
                "authorid" => $fetch['author'],
                "authorname" => $fetch['author_name']   
                                )                   
                );
            $i++;           
        }
echo json_encode($output);

Here is my html page which generate [Object object] when I try to get the data from the url

$(function() {
$('#getdata').click(function(){
        $.ajax({
        url: 'http://localhost:8080/android/functions.php',
        type : 'GET',
        data : 'method=getquestions',           
        dataType : 'json',
        success : function(s) {
            alert(s);
        },
        error: function(XMLHttpRequest,textStatus,errorThrown)
        {
            console.log(XMLHttpRequest+' '+textStatus+' '+errorThrown);
        }
    });
});

});

I think it is because of the '[' and ']' I'm not able to access data using ajax. IN the success function i get [Object object]

THE ONLY ONE · Accepted Answer · 2013-12-22 11:53:26Z

1

ok i got it you have to change your javascript to this code as below and let your php code to be run as it is you have written

success : function(s) {
                        for(var i =0 ;i < s.length; i++){
                              alert(s[i]["row"+i].id);
                              alert(s[i]["row"+i].answers);
                              alert(s[i]["row"+i].status);
                              alert(s[i]["row"+i].postedon);
                              alert(s[i]["row"+i].question);
                              alert(s[i]["row"+i].category);
                              alert(s[i]["row"+i].parent);
                              alert(s[i]["row"+i].authorid);
                              alert(s[i]["row"+i].authorname);
                       } 
                     }

edited Dec 22, 2013 at 11:53

answered Dec 22, 2013 at 10:26

THE ONLY ONE

2,1901 gold badge12 silver badges6 bronze badges

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

14 Comments

Ashik Basheer Over a year ago

since $Output is not a variable only the last record is shown. Still the '[' and ']' persist

THE ONLY ONE Over a year ago

Please check it i have change my answer as above

THE ONLY ONE Over a year ago

ok add i as index to row as above and try it such as alert(s[i].row[i].id);

THE ONLY ONE Over a year ago

no just add index to row as above and try it such as alert(s[i].row[i].id); As you are providing index i to row in your php code. Please see i have edit the answer as above.

THE ONLY ONE Over a year ago

i got it working this is the code which works alert(t[i]["row"+i].id);. Sorry for the late reply but i was testing the code and its working

|

Noishe · Accepted Answer · 2013-12-22 10:47:22Z

1

Your output is currently of the form:

[
    {
        row0:
        {
            id: "17",
            answers: "0",
            status: "0",
            postedon: "Dec 4 2013",
            question: "How many courses within Aqeedah?",
            category: "91",
            parent: "89",
            authorid: "14",
            authorname: "Mehrakbar"
        }
    },
    {
        row1:
        {
            id: "18",
            answers: "0",
            status: "0",
            postedon: "Dec 10 2013",
            question: "what is jinn?",
            category: "97",
            parent: "89",
            authorid: "53",
            authorname: "Jack"
        }
    },
    etc
]

If the beginning and ending [ ] brackets were switched to { } braces, then your output will no longer be valid JSON. What do you want the output to look like?

If it's

{
    row0:
    {
        blah: blah
        blee: blah
    },
    row1:
    {
        blah: blah
        blee: blah
    }
}

that you are looking for, then change the

$output[] = array (
        "row".$i => array   (

to a

$output['row'.$i] = array (

and clean up the the corresponding parantheses.

answered Dec 22, 2013 at 10:47

Noishe

1,42111 silver badges14 bronze badges

1 Comment

Ashik Basheer Over a year ago

Cool, now '[' and ']' are removed. But i'm not able to access the data via s.row0.id

user2678106 · Accepted Answer · 2013-12-22 10:22:50Z

0

$query = mysql_query("select * from questions");
$i = 0;
$output = array(); // add this line

answered Dec 22, 2013 at 10:22

user2678106

1 Comment

user2678106 Over a year ago

do you get any data of variable s in success : function(s)?

Collectives™ on Stack Overflow

json output is not as what expected

3 Answers 3

14 Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

14 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related