Generate a json array from SQL server using php

Question

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

pwolaq · Accepted Answer · 2013-02-08 11:37:18Z

5

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);

answered Feb 8, 2013 at 11:37

pwolaq

6,41221 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Generate a json array from SQL server using php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related