Apps Spurious Characters coming back from MySQL PHP

[ac4android]

My PHP script returns a dataset from an SQL query in mySQL.

In Android, I instantiate a HttpURLConnection and do a GET.

The BufferedReader returns the dataset to my Android with a lot of spurious characters.

I don't quite know where to debug this, can some of the gurus here point me in the right direction please:

Maybe I should just put in some work to create a nice XML layout for it in onPostExecute(String result) ???

 

[Deleted User]

What do you mean by 'spurious characters'? The JSON fragment you show looks ok.

 

[ac4android]

The {"db_response", and the many square and round brackets etc
I wasn't expecting those.
I hope I don't have to strip them before I can display them in XML layout...

 

[Deleted User]

The web service you've called is returning data in JSON format. You need to use a JSON parser to process it.

https://www.tutorialspoint.com/android/android_json_parser.htm

 

[ac4android]

Got it and parsed it. Thanks

Pushing my luck here, can you point me to tute-point or discussion for long-lasting, bi-directional traffic with a transactional-db , say 30-60 seconds. Upload a parameter to query a database and get a response e.g. upload license plate and get last long/latitude of vehicle.

Thanks again.