Problem creating JSON Object

Question

0.00/5 (No votes)

See more:

I have a jString like this:

[{"name":"Sergio Seiji de Souza Shimose"},{"name":"Marcelo Camargo"},...]

and when I do

JSONObject jObject = new JSONObject(jstring);

I get a JSON Exception that string cannot be converted to json object.

Any help?

EDIT: That jstring is returned from a PHP web service:

PHP

function listar($username)
{
    $result = mysql_query("SELECT Name FROM APKs WHERE Tipo=0 LIMIT 5");
    $numero = 0;
    while($registo = mysql_fetch_array($result))
    {
        $regs[] = array('name' => $registo["Name"]);
        $numero++;
    }
    return json_encode($regs);
}

Posted 15-Jul-11 2:03am

Maxdd 7

Updated 15-Jul-11 3:07am

v2

Add a Solution

2 solutions

Solution 2

Guys I need your help also in similar situation :

String jsonString =new String("{");
                jsonString= jsonString + "\"";
                jsonString= jsonString +"myArray\":";
                jsonString= jsonString +returnString;
                jsonString= jsonString +"}";
                Dialog.alert(jsonString);//[{"cnt":"1","username":"tamer"}]
             // Now the call should succeed

                   JSONObject myjson = new JSONObject(jsonString);

                   JSONArray nameArray = myjson.names();
                  JSONArray valArray = myjson.toJSONArray(nameArray);
                  int size = valArray.length();
                  for(int i=0;i<valarray.length();i++)>
                  {
                      String p = nameArray.getString(i) + "," + valArray.getString(i);
                      Dialog.alert(p);
                  }

I want to access for example the value of nameArray["cnt"] while looping ... how to do that ???

Posted 14-Aug-11 0:17am

Tamer Hatoum

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manfred Rudolf Bihy · Accepted Answer · 2011-07-15T03:04:00

Solution 1

That one is easy: JSONObject constructor taking a string expects a JSON string which always starts with { and ends with }. You'll have to wrap your array into { and } like this for instance:

Java

string jsonString("{ "myArray" : [{"name":"Sergio Seiji de Souza Shimose"},{"name":"Marcelo Camargo"},...]}");
// Now the call should succeed
JSONObject jo = new JSONObject(jsonString);

[Edit]

Java

JSONArray array = new JSONArray(jsonString);

[/Edit]

Cheers!

—MRB

Posted 15-Jul-11 3:04am

Manfred Rudolf Bihy

Updated 15-Jul-11 3:38am

v2

Comments

Maxdd 7 15-Jul-11 9:08am

Yes I supposed that, however the problem is the jstring is sent from a PHP web service

$regs[] = array('name' => $registo["Name"]);
return json_encode($regs);

See my updated question for more details...

Any change on this situation to make this work? :)

Manfred Rudolf Bihy 15-Jul-11 9:28am

You'd have to either look into the PHP implementation of json_encode or check in your java application if the string starts and ends with {}.

Manfred Rudolf Bihy 15-Jul-11 9:36am

I just saw that there is a corresponding JSONArray object in java. When you can make sure that the response will be an array in JSON notation or by checking for [ at the start and for ] at the end of your string, you can use JSONArray. See update!

Maxdd 7 15-Jul-11 11:40am

It works. Thank you very much.

Manfred Rudolf Bihy 15-Jul-11 12:08pm

Great! So you are now using JSONArray?

Espen Harlinn 19-Jul-11 4:50am

Good reply, my 5

Manfred Rudolf Bihy 19-Jul-11 6:08am

Thanks Espen!

Dalek Dave 14-Aug-11 6:22am

Good call, have a 5