Hello
I am conecting my app to remote mysql server. I can use insert and select but with update i have a problem
In my app I am using :
reportsending3.download2("https://www.xx.com/connectios.php", Array As String ("action", "updatepuan", "adaminadi3", "feridun","adaminadi4","311"))
and in my php i have:
I get Success for response at jobdone but when i check the mysql entries i see thaat it is not updated. What am i doing wrong ?
TY
I am conecting my app to remote mysql server. I can use insert and select but with update i have a problem
In my app I am using :
reportsending3.download2("https://www.xx.com/connectios.php", Array As String ("action", "updatepuan", "adaminadi3", "feridun","adaminadi4","311"))
and in my php i have:
B4X:
<?
include ("dbpushios.php");
$con = mysql_connect($dbhost,$dbuser,$dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
mysql_query("SET CHARACTER SET utf8");
$action = $_GET["action"];
switch ($action)
{
case "updatepuan":
$silincek6 = $_GET["adaminadi3"];
$silincek7 = $_GET["adaminadi4"];
$q = mysql_query("update tblonline set score='$silincek7' where username='$silincek6'");
print json_encode("udated");
break;
}
?>
I get Success for response at jobdone but when i check the mysql entries i see thaat it is not updated. What am i doing wrong ?
TY