current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite

So, my problem here is this: I am trying to follow up a tutorial in order to create an app, but i'm stuck at the part of json array...

So what i need is to create something like this:

{
    "contacts": [
        {
                "id": "c200",
                "name": "Ravi Tamada",
                }
        },
        {
                "id": "c201",
                "name": "Johnny Depp",

                }
        },

  ]
}

While, with what i've done, i get something like this:

[{"ID":"1","SPECIFIKIME":"12,9916,7165,1747,6973","IDPEMA":"119"}][{"ID":"2","SPECIFIKIME":null,"IDPEMA":"110"}]

My code is this:

while( $row = odbc_fetch_array($res) ) {
$return_arr = array();


    $row_array['ID'] = $row['ID'];
    $row_array['SPECIFIKIME'] = $row['SPECIFIKIME'];
    $row_array['IDPEMA'] = $row['IDPEMA'];

    array_push($return_arr,$row_array);

echo json_encode($return_arr);


}

Could you please help me how to do this? Thanks

share|improve this question

1 Answer 1

up vote 4 down vote accepted

first of all, you have to move $return_arr out of the loop, because you are redefining it every time (same as json_encode), then you have to add subarray contacts to make your code look like that you've presented

here's your code:

$return_arr = array();
$return_arr['contacts'] = array();
while( $row = odbc_fetch_array($res) ) {
    $row_array['ID'] = $row['ID'];
    $row_array['SPECIFIKIME'] = $row['SPECIFIKIME'];
    $row_array['IDPEMA'] = $row['IDPEMA'];

    array_push($return_arr['contacts'],$row_array);
}
echo json_encode($return_arr);
share|improve this answer
    
Perfect :) thank you very much! –  pyetjegoo Feb 8 '13 at 11:45

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.