How to return PHP array and receive it with Java

Question

I have this on my webservice:

 function listar($username)
{
    $result = mysql_query("SELECT Name FROM APKs WHERE Tipo=0");
    //$registo = mysql_fetch_array($result);

    $numero = 0;
    while($registo = mysql_fetch_array($result))
    {
        $regs[$numero] = $registo['Name'];
        $numero++;
    }

    return $regs;

    //return mysql_fetch_array($result);

}

in Java, after the SOAP call (not relevant now) I read it this way:

Object response = envelope.getResponse();
String x = response.toString();

I need to access which one of those fields (selected from the database) so I thought, why not split the array into strings?

I tried two methods:

String[] arr=x.split(&quot; &quot;);
        System.out.println(&quot;Array :&quot;+arr.length);
        for(int i=0;i&lt;arr.length;i++)
        {
            ..
        }

        StringTokenizer stArr=new StringTokenizer(x,&quot; &quot;);
        while(stArr.hasMoreTokens())
        {
            ...
        }

But none of them worked, whick make me believe I'm returning badly the array in first place.

Any help?

UPDATE:

So I'm using again xsd:string;
Now I have on my webservice return json_encode($regs);
To convert the object from the response I'm using a specific google api http://www.mkyong.com/java/how-do-convert-java-object-to-from-json-format-gson-api/

Object response = envelope.getResponse(); Gson gson = new Gson(); String jstring = gson.toJson(response);
But I'm with difficulty parsing the "jstring" because it's format: "[\"SOMETHING\",\"SOMETHING\",\"SOMETHING\",\"SOMETHING\",.....]". I have not any identifier to get those values.

How can I extract those dynamic values and assign them to String[]?

armandomiani · Accepted Answer · 2011-07-14 23:27:53Z

2

USE:

json_encode($array); in PHP

and

JSONObject in Java to read.

See this example: http://www.androidcompetencycenter.com/2009/10/json-parsing-in-android/

UPDATE

Change the line:

$regs[$numero] = $registo['Name'];

to:

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

If you need to get the ID, you also can do:

$regs[] = array('name' => $registo["name"], 'id' => $registo["id"]);

FORGET:

The mysql_fetch_array returns a real array not a string. It's not needed to split a string.

Be sure that your PHP Web Service is returning a xsd:array
Generate a new proxy using some generator like http://www.soapui.org. Just use the proxy. Nothing else.

edited Jul 14, 2011 at 23:27

answered Jul 14, 2011 at 21:49

armandomiani

7306 silver badges16 bronze badges

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

12 Comments

Tiago Over a year ago

I edited the function listar because it was return a multi dimensional array. I was returning xsd:string indeed. Corrected. Use proxy? Why? And how? I've no idea what you are suggesting.

armandomiani Over a year ago

Proxy it's a design pattern. Some proxy generator will generate Java classes that will the dirt work for you and return a clean Array.

armandomiani Over a year ago

Follow this link: albeesonline.com/blog/2008/01/29/…

Tiago Over a year ago

I appreciate your help, but I have no idea how to apply this in my java android client... much because that tutorial is to create a web client.

armandomiani Over a year ago

Ok, you didn't mentioned that you were using Android, so I think the best way it's use a simpler approach like JSON.

|

Sergii Zagriichuk · Accepted Answer · 2011-07-14 21:52:02Z

0

Try to use JSON and you can esy build easy object and read it.

answered Jul 14, 2011 at 21:52

Sergii Zagriichuk

5,3995 gold badges30 silver badges46 bronze badges

1 Comment

Sergii Zagriichuk Over a year ago

One part was specified by @armandomiani and what about android you can use developer.android.com/reference/org/json/JSONTokener.html for this case

Collectives™ on Stack Overflow

How to return PHP array and receive it with Java

2 Answers 2

12 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

12 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related