Android Question need help with php in b4a project

[tufanv]

Hello,

I want to send a list of symbols to a php file to request data from mysql. my php is currently :

$liste = clean($_GET["girdi1"]);

    $q = "SELECT * FROM genel WHERE sembol = '".$liste."' ";
    $r = mysql_query($q);
    $all = array();
     if ( mysql_num_rows($r) > 0 )    {

            while(($row = mysql_fetch_assoc($r))) {
                 $all[] = $row;

                            }
                         print json_encode($all);

and the data i am sending from b4a app is :

Dim connection As HttpJob
connection.Initialize("annebabaliste",Me)
connection.download2("https://.....connect.php", Array As String ("action", "senddata", "girdi1", listsymbols))

what i am trying to da basically here , I want to send a list of symbols hold in a list on my app and send it to php and the php need to execute
$q = "SELECT * FROM genel WHERE sembol = listitem1 , listitem2, listitem3 .... etc ";

how can i achieve this ?

 

[DonManfred]

Check this example: it shows how to define a list in B4A and the php uses this list to get the data. The list in the example does contains always a Map. But you should see the principle.

https://www.b4x.com/android/forum/threads/create-dynamic-jpg-using-b4a-and-php.40880/