从MySQL数据库中检索数据并将其显示在列表视图中

Question

I am trying to retrieve data from a MySQL databse, which is hosted in Microsoft Azure, and to display it in a listview( in a fragment). I have followed the indications of this post:

Retrieving data from Mysql DB with PHP and JSON in Xamarin Android C#.NET

But I am still getting a blank list. I think the error comes from my PHP as when I run my PHP script I get nothing in my browser. Here is my code:

PHP:

 <?php
  ini_set('display_errors', 1); 
  error_reporting(E_ALL);

  $servername = "eu-cdbr-azure-north-e.cloudapp.net";
  $username = "****************";
  $password = "**********";

 try 
 { 
 $conn = new PDO("mysql:host=$servername;dbname=******",$username,        $password);
 $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 }
 catch(PDOException $e)
 {
echo "Connection failed: " . $e->getMessage();
 }

  $query = $conn->prepare("SELECT FROM contact_info");
 $rows = array();


 while($row = $query->fetch(PDO::FETCH_ASSOC))
{
  $rows['contact_name'][]= $row;
  $rows['contact_email'][]= $row;
  $rows['contact_password'][]= $row;
  $rows['contact_trip'][]=$row;
}

 header("Content-type: application/json; charset=utf-8");

 echo json_encode($rows);

C#(fragment):

    public class Customers : Android.Support.V4.App.Fragment
{
    List<people> mClient = new List<people>();
    ListView client;
    private WebClient webClient;
    private Uri mUrl;
    private BaseAdapter<people> mAdapter;

    public override void OnActivityCreated(Bundle savedInstanceState)
    {
        base.OnActivityCreated(savedInstanceState);
        client = View.FindViewById<ListView>(Resource.Id.list);

        webClient = new WebClient();
        mUrl = new Uri("http://*********.azurewebsites.net/admin.php");
        webClient.DownloadDataAsync(mUrl);
        webClient.DownloadDataCompleted += webClient_DownloadDataCompleted;

        MyListViewAdapter adapter = new MyListViewAdapter(this.Activity, mClient);
        client.Adapter = adapter;
    }

    private void webClient_DownloadDataCompleted(object sender, DownloadDataCompletedEventArgs e)
    {
        Activity.RunOnUiThread(() =>
        {
            string json = Encoding.UTF8.GetString(e.Result);
            mClient = JsonConvert.DeserializeObject<List<people>>(json);
            mAdapter = new MyListViewAdapter(this.Activity, mClient);
            client.Adapter = mAdapter;
        });
    }

    public override View OnCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState)
    {

        var view = inflater.Inflate(Resource.Layout.Frag1Layout, container, false);
        return view;
       }


    public override string ToString()
    {
        return "Customers";
    }
}

C#(adapter):

   using System;
   using Android.App;
   using Android.Content;
   using Android.Widget;
   using Android.Runtime;
   using System.Collections.Generic;
   using Android.Views;
   using Android.OS;

   namespace Tonio_Pick_Me_Up.Droid
 {
class MyListViewAdapter : BaseAdapter<people>
{
    public List<people> mItems;
    private Context mContext;

    public MyListViewAdapter(Context context, List<people> items)
    {
        mItems = items;
        mContext = context;
    }

    public override int Count
    {
        get { return mItems.Count; }
    }

    public override long GetItemId(int position)
    {
        return position;
    }

    public override people this[int position]
    {
        get { return mItems[position]; }
    }

    public override View GetView(int position, View convertView, ViewGroup parent)
    {
        View row = convertView;

        if (row == null)
        {
            row = LayoutInflater.From(mContext).Inflate(Resource.Layout.contactlist, null, false);
        }

        TextView ContactName = row.FindViewById<TextView>(Resource.Id.ContactName);
        ContactName.Text = mItems[position].Contact_Name;

        TextView ContactEmail = row.FindViewById<TextView>(Resource.Id.ContactEmail);
        ContactName.Text = mItems[position].Contact_Email;

        TextView ContactNextTrip = row.FindViewById<TextView>(Resource.Id.ContactNextTrip);
        ContactName.Text = mItems[position].Contact_Email;

        return row;
    }
      }
   }


   C#(people class):

using System;
using Newtonsoft.Json;

namespace Tonio_Pick_Me_Up.Droid
{

public class people
{
    [JsonProperty("Contact_Name")]
    public string Contact_Name { get; set;}

    [JsonProperty("Contact_Email")]
    public string Contact_Email { get; set; }

    [JsonProperty("Contact_Trip")]
    public string Contact_Trip { get; set; }

}
}

Hope you can help, thanks in advance.