Android Question Connect Android to remote MySQL Database : Problem when migrating to a new server

[Che Mohamad]

Dears (Hi Erel),
I have been using, for more than 2 years the Tutorial by Erel here to connect my apps to remote mysql server, without any issues.
The below PHP code "

<?php

$databasehost = "localhost";
$databasename = "xxxx";
$databaseusername ="xxxx";
$databasepassword = "xxxx";

$con = mysqli_connect($databasehost,$databaseusername,$databasepassword, $databasename) or die(mysqli_error($con));
mysqli_set_charset ($con , "utf8");
$query = file_get_contents("php://input");
$sth = mysqli_query($con, $query);

if (mysqli_errno($con)) {
   header("HTTP/1.1 500 Internal Server Error");
   echo $query.'\n';
   echo mysqli_error($con);
}
else
{
   $rows = array();
   while($r = mysqli_fetch_assoc($sth)) {
     $rows[] = $r;
   }
   $res = json_encode($rows);
    echo $res;
    mysqli_free_result($sth);
}
mysqli_close($con);
?>

However I have decided to migrate the server to a new remote server (website hosting) :
1. No issue when posting "SELECT" statement
2. Issue when posting "INSERT" or "UPDATE" statement. The "JobDone(Job As HttpJob)" will return Job.ErrorMessage as "" (no string message).
After INSERT or UPDATE statement, I checked that the record has been inserted or updated in mySQL server, however the return message is the issue here.
This issue didn't occurs while using the old server. In the old server it will return as Job.Success = True

Is there something at the server setting that I need to change of the PHP code itself?
In Erel's tutorial he mentioned that "I've restricted the database user to SELECT queries (in MySQL configuration)"
Could it be the reason? If so where exactly do I need to change?

Thank you for your feedback.

 

[josejad]

Could it be the reason? If so where exactly do I need to change?

Yes, that could be the problem. Check your database with phpMyAdmin or any other DBMS to check if the user you're using to connect to your database has permissions to write on db.

 

[Che Mohamad]

Yes, that could be the problem. Check your database with phpMyAdmin or any other DBMS to check if the user you're using to connect to your database has permissions to write on db.

Additional info : after INSERT or UPDATE statement, I checked that the record has been inserted or updated in mySQL server, however the return message is the issue here.

 

[aeric]

I have been very long time no program with PHP but I think you are doing something wrong in your PHP.

SELECT query -> returns results.
INSERT / UPDATE -> does NOT return results.

When you use mysqli_fetch_assoc(), it should return the array of data when you do a SELECT query. This has nothing to do with INSERT/UPDATE queries.

 

[aeric]

$query = file_get_contents("php://input");

This look very wrong to me in term of security. How come you allow SQL query come from the user post? For. e.g, user posted "DELETE FROM users"