<?php  

$link=mysqli_connect("localhost","root","xunil999", "db" );  
if (!$link)  
{  
   echo "MySQL 접속 에러 : ";
   echo mysqli_connect_error();
   exit();  
}  

mysqli_set_charset($link,"utf8");


$sql="select * from Person";

$result=mysqli_query($link,$sql);
$data = array();   
if($result){  
   
   while($row=mysqli_fetch_array($result)){
       array_push($data,
           array('id'=>$row[0],
           'name'=>$row[1],
           'address'=>$row[2]
       ));
   }

   echo "<pre>"; print_r($data); echo '</pre>';

}  
else{  
   echo "SQL문 처리중 에러 발생 : ";
   echo mysqli_error($link);
}



mysqli_close($link);  
  
?>

echo "<pre>"; print_r($data); echo '</pre>';

header('Content-Type: application/json; charset=utf8');
$json = json_encode(array("webnautes"=>$data), JSON_PRETTY_PRINT+JSON_UNESCAPED_UNICODE);
echo $json;

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
  package="com.example.webnautes.phptest">

  <uses-permission android:name="android.permission.INTERNET" />

  <application

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
  xmlns:tools="http://schemas.android.com/tools"
  android:layout_width="match_parent"
  android:layout_height="match_parent"
  android:orientation="vertical"
  tools:context=".MainActivity"
  android:layout_margin="15dp"
  android:padding="10dp">

  <ListView
      android:layout_width="match_parent"
      android:layout_height="0dp"
      android:layout_weight="6"
      android:layout_margin="5dp"
      android:padding="5dp"
      android:id="@+id/listView_main_list" />

  <TextView
      android:layout_width="match_parent"
      android:layout_height="0dp"
      android:layout_weight="4"
      android:layout_margin="5dp"
      android:padding="5dp"
      android:id="@+id/textView_main_result" />

</LinearLayout>

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
  xmlns:app="http://schemas.android.com/apk/res-auto"
  android:layout_width="match_parent"
  android:layout_height="wrap_content"
  android:orientation="horizontal"
  android:layout_margin="15dp"
  android:padding="10dp">


  <TextView
      android:id="@+id/textView_list_id"
      android:layout_width="0dp"
      android:layout_height="wrap_content"
      android:layout_weight="1"
      android:layout_margin="5dp"
      android:padding="5dp" />


  <TextView
      android:id="@+id/textView_list_name"
      android:layout_width="0dp"
      android:layout_height="wrap_content"
      android:layout_weight="4"
      android:layout_margin="5dp"
      android:padding="5dp" />


  <TextView
      android:id="@+id/textView_list_address"
      android:layout_width="0dp"
      android:layout_height="wrap_content"
      android:layout_weight="5"
      android:layout_margin="5dp"
      android:padding="5dp" />

</LinearLayout>

package com.example.webnautes.phptest;


import android.app.ProgressDialog;
import android.os.AsyncTask;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.util.Log;
import android.widget.ListAdapter;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.TextView;


import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;

import java.io.BufferedReader;

import java.io.InputStream;
import java.io.InputStreamReader;

import java.net.HttpURLConnection;
import java.net.URL;
import java.util.ArrayList;
import java.util.HashMap;


public class MainActivity extends AppCompatActivity {

  private static String TAG = "phptest_MainActivity";

  private static final String TAG_JSON="webnautes";
  private static final String TAG_ID = "id";
  private static final String TAG_NAME = "name";
  private static final String TAG_ADDRESS ="address";

  private TextView mTextViewResult;
  ArrayList<HashMap<String, String>> mArrayList;
  ListView mlistView;
  String mJsonString;



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

      mTextViewResult = (TextView)findViewById(R.id.textView_main_result);
      mlistView = (ListView) findViewById(R.id.listView_main_list);
      mArrayList = new ArrayList<>();

      GetData task = new GetData();
      task.execute("http://10.0.2.2/getjson.php");
  }


  private class GetData extends AsyncTask<String, Void, String>{
      ProgressDialog progressDialog;
      String errorString = null;

      @Override
      protected void onPreExecute() {
          super.onPreExecute();

          progressDialog = ProgressDialog.show(MainActivity.this,
                  "Please Wait", null, true, true);
      }


      @Override
      protected void onPostExecute(String result) {
          super.onPostExecute(result);

          progressDialog.dismiss();
          mTextViewResult.setText(result);
          Log.d(TAG, "response  - " + result);

          if (result == null){

              mTextViewResult.setText(errorString);
          }
          else {

              mJsonString = result;
              showResult();
          }
      }


      @Override
      protected String doInBackground(String... params) {

          String serverURL = params[0];

         
          try {

              URL url = new URL(serverURL);
              HttpURLConnection httpURLConnection = (HttpURLConnection) url.openConnection();


              httpURLConnection.setReadTimeout(5000);
              httpURLConnection.setConnectTimeout(5000);
              httpURLConnection.connect();


              int responseStatusCode = httpURLConnection.getResponseCode();
              Log.d(TAG, "response code - " + responseStatusCode);

              InputStream inputStream;
              if(responseStatusCode == HttpURLConnection.HTTP_OK) {
                  inputStream = httpURLConnection.getInputStream();
              }
              else{
                  inputStream = httpURLConnection.getErrorStream();
              }


              InputStreamReader inputStreamReader = new InputStreamReader(inputStream, "UTF-8");
              BufferedReader bufferedReader = new BufferedReader(inputStreamReader);

              StringBuilder sb = new StringBuilder();
              String line;

              while((line = bufferedReader.readLine()) != null){
                  sb.append(line);
              }


              bufferedReader.close();


              return sb.toString().trim();


          } catch (Exception e) {

              Log.d(TAG, "InsertData: Error ", e);
              errorString = e.toString();

              return null;
          }

      }
  }


  private void showResult(){
      try {
          JSONObject jsonObject = new JSONObject(mJsonString);
          JSONArray jsonArray = jsonObject.getJSONArray(TAG_JSON);

          for(int i=0;i<jsonArray.length();i++){

              JSONObject item = jsonArray.getJSONObject(i);

              String id = item.getString(TAG_ID);
              String name = item.getString(TAG_NAME);
              String address = item.getString(TAG_ADDRESS);

              HashMap<String,String> hashMap = new HashMap<>();

              hashMap.put(TAG_ID, id);
              hashMap.put(TAG_NAME, name);
              hashMap.put(TAG_ADDRESS, address);

              mArrayList.add(hashMap);
          }

          ListAdapter adapter = new SimpleAdapter(
                  MainActivity.this, mArrayList, R.layout.item_list,
                  new String[]{TAG_ID,TAG_NAME, TAG_ADDRESS},
                  new int[]{R.id.textView_list_id, R.id.textView_list_name, R.id.textView_list_address}
          );

          mlistView.setAdapter(adapter);

      } catch (JSONException e) {

          Log.d(TAG, "showResult : ", e);
      }

  }

}

$link=mysqli_connect("localhost","root","root 계정 비밀번호","데이터베이스 이름");
if (!$link)  
{  
   echo "MySQL 접속 에러 : ";
   echo mysqli_connect_error();
   exit();  
}  

$sql="select * from Person";

$result=mysqli_query($link,$sql);