Android Question Get Data from SQL file using a GET command or similar

<?php

$host = "hostname";
$user = "dbuser";
$pw = "dbpw";
$db = "dbname";

$con = mysqli_connect($host,$user,$pw) or die(mysqli_error());
mysqli_select_db($con,$db) or die(mysqli_error());
mysqli_query($con,"SET CHARACTER SET utf8");
mysqli_query($con,"SET NAMES 'utf8'");

$q = mysqli_query($con,"SELECT * FROM mytable order by xxxx ASC") or die(mysqli_error($con));
        $rows = array();
        while($r = mysqli_fetch_assoc($q)) ' = culumn name -> value
        {
            $rows[] = $r;
        }
        print json_encode($rows);

?>

Dim GetDataJob As HttpJob
    GetDataJob.Initialize("GetData", Me)
    GetDataJob.PostString(ServerAddress & "/mypath/myscript.php", "Nothing")

Sub JobDone(Job As HttpJob)
  
    If Job.Success Then
        Dim res As String
      
        res = Job.GetString
        Log("Back from Job:" & Job.JobName )
        Log("Response from server: " & res)
      
        Dim MyDataList As List 'Define a list for the data coming from the php script
  
        Dim parser As JSONParser 'It's a JSON formatted string
        parser.Initialize(res)
          
        MyDataList.Initialize
        MyDataList=parser.NextArray 'Convert the JSON and put it in the list

        'you can save the list to a file and load it when you need it
       
        'Each list entry has a MAP with the data (500 rows = 500 maps). Just access it like this (simple code) or use for .... each ....

        Dim MyDataMap as Map
        MyDataMap.Initialize
        For i=0 To MyDataList.Size-1
              MyDataMap=MyDataList.Get(i)
              'Next: Parse the Map (key=culumn name, value=data) and put it. Hint: Take a look at the content in debug :-)
        Next
    Else
        Log("Error: " & Job.ErrorMessage)
    End If
    Job.Release
  
End Sub