Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host='localhost';
- $user='root';
- $password='';
- $db='employee101';
- $_id = $_POST['id'];
- $sql = "select * from employee_comments where id = $_id;";
- $con = mysqli_connect($host,$user,$password,$db);
- $result = mysqli_query($con, $sql);
- $response = array();
- while($row = mysqli_fetch_array($result)){
- array_push($response,array("id"=>$row[0],"comment"=>$row[1],"rating"=>$row[2]));
- }
- echo json_encode(array("server_respo"=>$response));
- mysqli_close($con);
- ?>
- import android.content.Intent;
- import android.os.AsyncTask;
- import android.support.v7.app.AppCompatActivity;
- import android.os.Bundle;
- import android.view.View;
- import android.widget.ArrayAdapter;
- import android.widget.EditText;
- import android.widget.ListView;
- import android.widget.TextView;
- import android.widget.Toast;
- import org.json.JSONArray;
- import org.json.JSONException;
- import org.json.JSONObject;
- import org.w3c.dom.Text;
- import java.io.BufferedReader;
- import java.io.BufferedWriter;
- import java.io.IOException;
- import java.io.InputStream;
- import java.io.InputStreamReader;
- import java.io.OutputStream;
- import java.io.OutputStreamWriter;
- import java.net.HttpURLConnection;
- import java.net.MalformedURLException;
- import java.net.URL;
- import java.net.URLEncoder;
- public class MainActivity extends AppCompatActivity {
- String Json_STRING;
- TextView textView;
- @Override
- protected void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.activity_main);
- new BackgroundTask().execute();
- //new line
- }
- /*public void getJSON(View view) {
- new BackgroundTask().execute();
- }*/
- class BackgroundTask extends AsyncTask<Void, Void, String> {
- String json_url;
- String JSON_STRING;
- @Override
- protected void onPreExecute() {
- json_url = "http://10.0.2.2/json_comments.php";
- }
- @Override
- protected String doInBackground(Void... params) {
- try {
- URL url = new URL(json_url);
- HttpURLConnection httpURLConnection = (HttpURLConnection) url.openConnection();
- InputStream inputStream = httpURLConnection.getInputStream();
- BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream));
- StringBuilder stringBuilder = new StringBuilder();
- while ((JSON_STRING = bufferedReader.readLine()) != null) {
- stringBuilder.append(JSON_STRING + "n");
- }
- bufferedReader.close();
- inputStream.close();
- httpURLConnection.disconnect();
- return stringBuilder.toString().trim();
- } catch (MalformedURLException e) {
- e.printStackTrace();
- } catch (IOException e) {
- e.printStackTrace();
- }
- return null;
- }
- @Override
- protected void onProgressUpdate(Void... values) {
- super.onProgressUpdate(values);
- }
- @Override
- protected void onPostExecute(String result) {
- TextView textView = (TextView)findViewById(R.id.textView2);
- textView.setText(result);
- Json_STRING = result;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement