Put row of data from back-end service into ListView

Question

Before trying to get a row of data from a MySQL server, I used a column and managed to get that into a listView through tutorials. But for getting data in a row from a table, I couldn't manage to put it into a listView.

So what I'm trying to do is put "shift" from background worker into a listview.

PHP SQL query:

$sql = "SELECT id, employee, hours FROM selected_shifts WHERE day = '$day';";

Navigation drawer from Main Activity:

if (items[0].equals(mExpandableListTitle.get(groupPosition))) {
                if (items[0].equals(mExpandableListTitle.get(childPosition))) {
                    String day = "Monday";
                    OnChoice(day);
                } else if (items[1].equals(mExpandableListTitle.get(childPosition))) {
                    String day= "Tuesday";
                    OnChoice(day);
                } else if (items[2].equals(mExpandableListTitle.get(childPosition))) {
                    String day = "Wednesday";
                    OnChoice(day);
                } else if (items[3].equals(mExpandableListTitle.get(childPosition))) {
                    String day = "Thursday";
                    OnChoice(day);
                } else if (items[4].equals(mExpandableListTitle.get(childPosition))) {
                    String day = "Friday";
                    OnChoice(day);
                }
            }

            mDrawerLayout.closeDrawer(GravityCompat.START);
            return false;
        }
    });
}

public void OnChoice(String day) {
    String type = "choice";
    BackgroundWorker backgroundWorker = new BackgroundWorker(this);
    backgroundWorker.execute(type, day);
}

Background worker(getting data from MySQL server):

public class BackgroundWorker extends AsyncTask<String,Void,String> {
Context context;
AlertDialog alertDialog;
BackgroundWorker (Context ctx) {
    context = ctx;
}
@Override
protected String doInBackground(String... params) {
    String type = params[0];
    String shifts_url = "***PHP LINK***";
    if(type.equals("choice")) {
        try {
            String day = params[1];
            URL url = new URL(shifts_url);
            HttpURLConnection httpURLConnection = (HttpURLConnection)url.openConnection();
            httpURLConnection.setRequestMethod("POST");
            httpURLConnection.setDoOutput(true);
            httpURLConnection.setDoInput(true);
            OutputStream outputStream = httpURLConnection.getOutputStream();
            BufferedWriter bufferedWriter = new BufferedWriter(new OutputStreamWriter(outputStream, "UTF-8"));
            String post_data = URLEncoder.encode("day","UTF-8")+"="+URLEncoder.encode(day,"UTF-8");
            bufferedWriter.write(post_data);
            bufferedWriter.flush();
            bufferedWriter.close();
            outputStream.close();
            InputStream inputStream = httpURLConnection.getInputStream();
            BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream,"iso-8859-1"));
            String shift="";
            String line="";
            while((line = bufferedReader.readLine())!= null) {
                shift += line;
            }
            bufferedReader.close();
            inputStream.close();
            httpURLConnection.disconnect();
            return shift;
        } catch (MalformedURLException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    return null;
}

@Override
protected void onPreExecute() {
    alertDialog = new AlertDialog.Builder(context).create();
    alertDialog.setTitle("Status");
}

@Override
protected void onPostExecute(String shift) {
    //Toast the data as json
    Toast.makeText(context, shift, Toast.LENGTH_LONG).show();
}

@Override
protected void onProgressUpdate(Void... values)
{
    super.onProgressUpdate(values);


   }
}

EDIT

Putting it into ListView:

public void onTaskCompleted(String shift) {
    try {
        loadIntoListView(shift);
    } catch (JSONException e) {
        e.printStackTrace();
    }
}

private void loadIntoListView(String shift) throws JSONException {
    JSONArray jsonArray = new JSONArray(shift);
    String[] list = new String[jsonArray.length()];
    for (int i = 0; i < jsonArray.length(); i++) {
        JSONObject obj = jsonArray.getJSONObject(i);
        list[i] = obj.getString(shift);
    }
    ArrayAdapter<String> arrayAdapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, list);
    listView.setAdapter(arrayAdapter);
}

Answer 1

At your onPostExecute() you should add the "shift" to a dataSet in your adapter.

Answer 2

So what you want to do to pass the shift back is use a custom "Listener".

Create this

public interface TaskListener {
    void onTaskCompleted(String shift);
}

And on your BackgroundWorker change the constructor as follow:

TaskListener taskListener;
BackgroundWorker(Context context, TaskListener taskListener){
  this.context = context;
  this.taskListener = taskListener;
}

Then on the onPostExecute method, do a taskListener.onTaskCompleted(shift).

When you call the BackgroundWorker constructor pass this as the second parameter:

BackgroundWorker backgroundWorker = new BackgroundWorker(this, this)

Then implement TaskListener on your Main and implement the method. Something like this:

... MainActivity implements TaskListener
...
@override
onTaskCompleted(String shift) {
// You have your `shift` here to do with as you please
}