formatting JSON array output via

Question

I am writing a small service in php to output a JSON string. The service is ultimately consumed by an Android JSONObject, if that helps. To keep it short, I have:

<?php
mysql_connect('localhost','myUser','myPwd') or die('Cannot connect to the DB');
mysql_select_db('ctgscott_myDB') or die('Cannot select the DB');
$query=mysql_query("SELECT name FROM customers ORDER BY name ASC");

while($e=mysql_fetch_assoc($query))
$output[]=$e;
print(json_encode($output));    

mysql_close();

?>

The problem is the output arrives in the form:

[{"name":"Client Number1"},{"name":"Client Number2"}]

'name' is the column header for the name field in the 'customer' table and it is unnecessary for me to repeat it... I am struggling to format the output like:

{"name":["Client Number1","Client Number2"]}

Any help would be greatly appreciated. Thanks!

christophmccann · Accepted Answer · 2011-01-28 09:49:40Z

1

You need to have a multi-dimensional array instead. Try using this:

mysql_connect('localhost','myUser','myPwd') or die('Cannot connect to the DB');
mysql_select_db('ctgscott_myDB') or die('Cannot select the DB');
$query=mysql_query("SELECT name FROM customers ORDER BY name ASC");

$names['name'] = array();
while($e = mysql_fetch_assoc($query)) {
   $names['name'][] = $e['name'];
}

print(json_encode($names));

edited Jan 28, 2011 at 9:49

answered Jan 28, 2011 at 0:29

christophmccann

4,2218 gold badges44 silver badges66 bronze badges

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

6 Comments

ctgScott Over a year ago

Thanks, Christopher! It looks like we are half way there. The output is now: {"name":[{"name":"Client Number2"},{"name":"Test Client"}]}

ctgScott Over a year ago

Sorry, let me clean that up: {"name":[{"name":"Client Number1"},{"name":"Client Number2"}]} Any other thoughts on pulling the 'name' out of the []? The problem I have is that on the consumption side without extra parsing the Android JSONObject will take either a key/value or a key/array() pair. Of course more work could be put in there... just trying to keep it simple on one side or the other. :)

ctgScott Over a year ago

Changing 'mysql_fetch_assoc($query)' to 'mysql_fetch_row($query) gave me: ... {"name":[["Client Number1"],["Client Number2"]]} ... so close. Maybe i'll just go ahead with the parsing on the receiving side.

christophmccann Over a year ago

Sorry - thats my bad. I have amended the code above that should correct it.

ctgScott Over a year ago

Brilliant! It works perfectly. Output={"name":["Client Number1","Client Number2"]} ...Thanks Christopher! Damn, I am new to StackOverflow and they won't let me 'up arrow' this question... boo.

|

user609239 · Accepted Answer · 2011-02-17 07:08:00Z

0

here is good article to fetch data from mysql to android using php http://blog.sptechnolab.com/2011/02/10/android/android-connecting-to-mysql-using-php/. i hope you like it.

answered Feb 17, 2011 at 7:08

user609239

3,3665 gold badges27 silver badges27 bronze badges

Collectives™ on Stack Overflow

formatting JSON array output via

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related