ANDROID&PHP - How to display JSONArray from MySql using PHP

Question

The code that I use to displaying value of table into JSONArray below

send_data.php

<?php
include 'dbconfig.php';
$con = new mysqli($servername, $username, $password, $dbname);
if (mysqli_connect_errno())
  {
   echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

  $query = "select id,ask from pertanyaan";

  $result = mysqli_query($con,$query);

  $rows = array();
  while($r = mysqli_fetch_array($result)) {
    $rows[] =$r;
  }
echo json_encode(array_values($rows));

  mysqli_close($con);
?>

and the JSONArray output is like this

[{"0":"1","id":"1","1":"pertanyaan ke 1","ask":"pertanyaan ke 1"},{"0":"2","id":"2","1":"pertanyaan ke 2","ask":"pertanyaan ke 2"},{"0":"3","id":"3","1":"pertanyaan ke 3","ask":"pertanyaan ke 3"},{"0":"4","id":"4","1":"pertanyaan ke 4","ask":"pertanyaan ke 4"},{"0":"5","id":"5","1":"pertanyaan ke 5","ask":"pertanyaan ke 5"}]

but everytime i try that URL to display in android, i got an error that say

Value <html><body<>script of type java.lang.String cannot be converted to JSONArray

but when i create new API with the same output here into android studio, its work fine,

did i use wrong code to encode JSON from PHP?

How are you accessing the URL in Android? WebView in your app? Through a browser app? — Frederic Klein
– Frederic Klein, Commented Oct 23, 2016 at 8:04
@MikeM. ohh sorry sir if i already breaking the rules, i just suggested to ask a new question about php code, @FredericKlein i try to displaying thats all value into TextView sir — Flix
– Flix, Commented Oct 23, 2016 at 8:08
zxccvvv.cuccfree.com/send_data.php needs JavaScript to redirect to http://www., try it with http://www.zxccvvv.cuccfree.com/send_data.php in your request. — Frederic Klein
– Frederic Klein, Commented Oct 23, 2016 at 8:15
so i just need to add/enable JavaScript in my hosting folder sir? — Flix
– Flix, Commented Oct 23, 2016 at 8:16
For this simple request, you probably don't want to use a WebView or a headless browser with JavaScript support, just avoid the redirect by directly calling http://www.zxccvvv.cuccfree.com/send_data.php — Frederic Klein
– Frederic Klein, Commented Oct 23, 2016 at 8:18

Frederic Klein · Accepted Answer · 2016-10-24 15:50:16Z

1

Problem

HttpURLConnection has no JavaScript support, but a needed cookie is generated using JavaScript.

Your call

String reqUrl = "http://zxccvvv.cuccfree.com/send_data.php";
URL url = new URL(reqUrl);
HttpURLConnection conn = (HttpURLConnection) url.openConnection();

fails, because the cookie __test is missing.

Fix

From a first glance at the JavaScript source the cookie seems to be constant for a given url, so it might be enough to set for a constant cookie:

String cookie = "__test=2bf7c15501c0ec57f8e41cb84871a69c";

URL url = new URL(reqUrl);
HttpURLConnection conn = (HttpURLConnection) url.openConnection();
conn.setConnectTimeout(7000);
conn.setRequestMethod("GET");
conn.setRequestProperty("Cookie", cookie);

Alternative: Using a WebView we can grab the cookie, so this is the preferable approach, since it will not break, if the cookie changes and it is not much of a time delay:

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);

    getCookie();

    if(cookie!=null) {
        new GetContacts().execute();
    }
}

private void getCookie(){
    CookieManager.setAcceptFileSchemeCookies(true);
    WebView wv = new WebView(getApplicationContext());
    wv.getSettings().setJavaScriptEnabled(true);
    wv.loadUrl(url);
    cookie = CookieManager.getInstance().getCookie("zxccvvv.cuccfree.com");
}

and set it as in above example:

conn.setRequestProperty("Cookie", cookie);

Output in logcat

Response from url: [{"0":"1","id":"1","1":"pertanyaan ke 1","ask":"pertanyaan ke 1"},{"0":"2","id":"2","1":"pertanyaan ke 2","ask":"pertanyaan ke 2"},{"0":"3","id":"3","1":"pertanyaan ke 3","ask":"pertanyaan ke 3"},{"0":"4","id":"4","1":"pertanyaan ke 4","ask":"pertanyaan ke 4"},{"0":"5","id":"5","1":"pertanyaan ke 5","ask":"pertanyaan ke 5"}]

edited Oct 24, 2016 at 15:50

answered Oct 23, 2016 at 8:25

Frederic Klein

2,8753 gold badges25 silver badges37 bronze badges

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

6 Comments

Flix Over a year ago

sorry for slow response, i still dont know what the answer u mean above, should i try the code into android studio??

Frederic Klein Over a year ago

Yes, I tested it on an Android device, booth approaches work, while I would prefer the WebView approach.

Flix Over a year ago

so I just need to enable javascript between hosting or android sir?

Frederic Klein Over a year ago

The host (zxccvvv.cuccfree.com) uses JavaScript to set a cookie, then forwards you to the data. The cookie seems to be static, so adding the cookie to your request enables you to request the data, bypassing the need for JavaScript. In case the approach breaks (the cookie might change) then the usage of a WebView to request the cookie can be used.

Flix Over a year ago

But when i searching, almost all of the tutorial using webview to set the cookie, do you have a simple coding just to enable the cookie? Or your answer above is the right answer for me? Sorry for noob question, im so newbie about android studio

|

Collectives™ on Stack Overflow

ANDROID&PHP - How to display JSONArray from MySql using PHP

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related