Android Question Connecting MySql error OkHttpUtils2 / HttpUtils2. Help

[studio4]

Hi,
I used B4A five years ago and now I would like work again with it, but somethings are changed.
I am trying to connect to a Mysql database (very simple). In the past, I used the http library and all works fine, but now It is impossible for me using the new library okhttputils, and okhttp library.
I read several post such as... https://www.b4x.com/android/forum/threads/httputils2-web-services-are-now-even-simpler.18992/ but I can not understand it.

I have attached a screenshot about the error and the code. Help me please.
Sorry. My english skill is very low.

 

[walterf25]

Hi,
I used B4A five years ago and now I would like work again with it, but somethings are changed.
I am trying to connect to a Mysql database (very simple). In the past, I used the http library and all works fine, but now It is impossible for me using the new library okhttputils, and okhttp library.
I read several post such as... https://www.b4x.com/android/forum/threads/httputils2-web-services-are-now-even-simpler.18992/ but I can not understand it.

I have attached a screenshot about the error and the code. Help me please.
Sorry. My english skill is very low.

I would suggest checking your php file, make sure the php file is in the folder or directory that you are pointing to in your code, or that it doesn't contain any errors, also check and make sure you have the right credentials, username, password etc.

The error you are getting is very obvious, you are expecting a Json Array, but instead you are receiving a String.

You should check out this tutorial instead.

Walter

 

[DonManfred]

you are expecting a Json Array, but instead you are receiving a String.

the result is the content from this url: https://hosting.miarroba.com/indice.php
The call is redirected to this url. Account deleted/deactivated?

http://www.webcindario.com/spirited22/php/conexion3.php
Host: www.webcindario.com
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:70.0) Gecko/20100101 Firefox/70.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: de,en-US;q=0.7,en;q=0.3
Accept-Encoding: gzip, deflate
DNT: 1
Connection: keep-alive
Upgrade-Insecure-Requests: 1
GET: HTTP/1.1 301 Moved Permanently
Server: nginx
Date: Wed, 20 Nov 2019 05:31:28 GMT
Content-Type: text/html
Content-Length: 162
Location: https://hosting.miarroba.com/indice.php

 

[studio4]

the result is the content from this url: https://hosting.miarroba.com/indice.php
The call is redirected to this url. Account deleted/deactivated?

Thank you for you help...
May be that my problems are due to a free hosting plan?

 

[DonManfred]

Free accounts usually get deleted after a while of not using it.

It this the case maybe? Check their website if you still can login to your account.

 

[studio4]

Free accounts usually get deleted after a while of not using it.

It this the case maybe? Check their website if you still can login to your account.

I have checked it and I can login without problems, but certanly I think that the problem may be due to the advertisements of the website.

 

[DonManfred]

I suggest to get a paid account where you do not need any advertisements on your page.

There are cheap ones available too.

Maybe just search for another free hoster.

 

[studio4]

Hello again,

Finally, I have decided to by a hosting and a domain (not free) to avoid possible errors, but my app doesn’t work again.

Certainly, the error has changed, but I can not to resolve it.

I have changed all the parameters in the app and .php file. Attachment it. Please help.

This is my .php file:

<?php

$databasehost = "localhost";
$databasename = "test1";
$databaseusername ="user1";
$databasepassword = "pwduser1";

$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);
?>

 

[DonManfred]

Post errors as TEXT please. It IS text
As you can see you do not get an answer from your php.
Start searching for problems here.

I suggest NOT to use php://input at all! Use Post request and give correct post vars to the php. Job.Postmultipart

 

[studio4]

Thank you for your help.
I have resolved the problem. It consisted of an incorrect setting of my hosting server. I asked to the admin of it and now, it is all is ok.
Thank you again.