Hello,
I want to send a list of symbols to a php file to request data from mysql. my php is currently :
and the data i am sending from b4a app is :
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 ?
I want to send a list of symbols to a php file to request data from mysql. my php is currently :
B4X:
$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 :
B4X:
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 ?