Android Question Put data to MySQL Database?

ilan · Apr 3, 2019

Hi

until today i have sending data to my mySQL DB via php. I have a shared hosting and some mysql db on it. is there a different way to send data to mysql?

it seems like when i send it via php it is not updated immidiatley. sometimes i take some minutes until i see the updated data. is it normal like this? can it be that it has something to do with okhttp?

thanx, ilan
ps.: my hosting is on WHOIS.COM. if you know a better company please let me know i am ready to pay more for my hosting if it runs faster and better. thanx

DonManfred · Apr 3, 2019

ilan said:
it seems like when i send it via php it is not updated immidiatley. sometimes i take some minutes until i see the updated data. is it normal like this?

no. When i call a php and in the php i write data to the db the data is written immediately. A following request to get data get the updated data from db without problem.

ilan said:
can it be that it has something to do with okhttp?

i don´t think so.

Start with posting all relevant code.

josejad · Apr 3, 2019

I use jRDC2 and I can see the changes immediately. But you should use a VPS
I can't tell you for sure if it's normal through php, but I guess that's not the normal behaviour.

Erel · Apr 3, 2019

jRDC2 is the best option but as Jose wrote it requires a VPS. You can also connect directly to the database with JdbcSQL (assuming that the server is configured to allow remote access).

DonManfred · Apr 3, 2019

Erel said:
assuming that the server is configured to allow remote access

Most probably not allowed when using

ilan said:
I have a shared hosting and some mysql db on it

a shared hosting.

ilan · Apr 3, 2019

thanx for all answers.

DonManfred said:
Start with posting all relevant code.

this is my phpcode:

B4X:

<?

$table = "";

include ("");
$con = mysql_connect($host,$user,$pw) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES 'utf8'");

$action = $_GET["action"];
 
switch ($action)

{

    Case "GetUserName":
        $username = $_GET["username"];
        $q = mysql_query("SELECT password FROM $table WHERE username='$username'");
        $rows = array();
        while($r = mysql_fetch_assoc($q))
        {
            $rows[] = $r;
        }
        print json_encode($rows);
    break;
    
    case "SignUp":
        $username = $_GET["username"];
        $password = $_GET["password"];
        $q = mysql_query("INSERT INTO $table (username, password) VALUES ('$username', '$password')");
        print "Inserted";
    break;
    
    
}


?>

b4a code:

B4X:

Dim GetPersons As HttpJob
        GetPersons.Initialize("GetUserN", Me)
        GetPersons.download2(domain & "8bitlogin.php", Array As String ("action", "GetUserName", "username", user))

if JobDone event i am getting the data and showing to the user...

Erel said:
assuming that the server is configured to allow remote access).

is this what you mean erel?

josejad · Apr 3, 2019

I think he means that you probably have your php pages in the same server that your mysql, so your php files connect to localhost.

Try to connect to your database from your computer with i.e. HeidiSQL to see if your server admits remote connections, because you will need to connect from your android app.

ilan · Apr 4, 2019

José J. Aguilar said:
you probably have your php pages in the same server that your mysql

yes i have. should i not have?

José J. Aguilar said:
Try to connect to your database from your computer with i.e. HeidiSQL to see if your server admits remote connections, because you will need to connect from your android app.

ok i will check that out. thank you

josejad · Apr 4, 2019

ilan said:
yes i have. should i not have

Yes, no problem with that, it just means you’re accessing your server locally, and not remotely

aeric · Apr 4, 2019

Test your project using another hosting provider. Maybe on a free hosting such as https://www.000webhost.com/free-php-hosting and see any different. I suspect the issue is with the hosting.

aeric · Apr 4, 2019

ilan said:

thanx for all answers.

this is my phpcode:

B4X:

<?

$table = "";

include ("");
$con = mysql_connect($host,$user,$pw) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES 'utf8'");

$action = $_GET["action"];
 
switch ($action)

{

    Case "GetUserName":
        $username = $_GET["username"];
        $q = mysql_query("SELECT password FROM $table WHERE username='$username'");
        $rows = array();
        while($r = mysql_fetch_assoc($q))
        {
            $rows[] = $r;
        }
        print json_encode($rows);
    break;
  
    case "SignUp":
        $username = $_GET["username"];
        $password = $_GET["password"];
        $q = mysql_query("INSERT INTO $table (username, password) VALUES ('$username', '$password')");
        print "Inserted";
    break;
  
  
}


?>

b4a code:

B4X:

Dim GetPersons As HttpJob
        GetPersons.Initialize("GetUserN", Me)
        GetPersons.download2(domain & "8bitlogin.php", Array As String ("action", "GetUserName", "username", user))

if JobDone event i am getting the data and showing to the user...

View attachment 79051

is this what you mean erel?

You removed the table name and include file in your PHP file for demo purpose?

By the way, I am no longer using mysql_connect or mysql_query (or even mysqli) as my shared hosting complain in the error log that the function is deprecated in new PHP version. I am using PDO and stored procedure (parameterised query) now. I think you should take a look at it.

DonManfred · Apr 4, 2019

Note that mysql_* is deprecated since years.
You should use a MySQLi Class.

ilan · Apr 4, 2019

DonManfred said:
You should use a MySQLi Class.

i have very low experience with sql so i dont know what is mysqli. do you mean a b4a class?
are the database the same or are they different?

thank you

ilan · Apr 4, 2019

aeric said:
You removed the table name and include file in your PHP file for demo purpose?

yes

josejad · Apr 4, 2019

ilan said:
i dont know what is mysqli. do you mean a b4a class?

MySQLi extension is a driver to connect to mysql with php. You'll not have problems to change from mysql extension to mysqli. Just search for some examples, it's very similar to mysql extension.
i.e.

DonManfred said:
Get inspired here for ex.

https://github.com/joshcam/PHP-MySQLi-Database-Class

And in THIS example, Erel uses mysqli

DonManfred · Apr 4, 2019

If you need a good MySQLi-Class (Compatible with PHP 7): Here

I´m using it successfully since years.

ilan · Apr 4, 2019

DonManfred said:
If you need a good MySQLi-Class (Compatible with PHP 7): Here

I´m using it successfully since years.

thanx a lot don, do you have also a b4a version of it?

DonManfred · Apr 4, 2019

ilan said:
do you have also a b4a version of it?

For what? MySQLi classes are only relevant when using up a recent version of PHP.
MySQL Classes are deprecated in PHP.

If you want to access MySQL directly from B4A then you should use https://www.b4x.com/android/forum/threads/jdbcsql-directly-connect-to-remote-databases.84016/ though the best solution is for sure to use JRDC2.

For the communication with PHP you only need okhttputils.

ilan · Apr 4, 2019

DonManfred said:
For the communication with PHP you only need okhttputils.

this is what i am doing today.

DonManfred said:
If you want to access MySQL directly from B4A then you should use https://www.b4x.com/android/forum/threads/jdbcsql-directly-connect-to-remote-databases.84016/ though the best solution is for sure to use JRDC2.

what i have understood is that i will need for that a hosting that support remote access and shared hosting does not support it.
can you recommend on a hosting that support remote access?

aeric · Apr 4, 2019

ilan said:
thanx a lot don, do you have also a b4a version of it?

Basically, you just need to replace "mysql_" with "mysqli_" but some parts need to be alert.
https://www.php.net/manual/en/mysqli.query.php

The way you use OkHttp to access the PHP page in B4A will remain unchanged.

Android Question Put data to MySQL Database?

Expert

Expert

Expert

B4X founder

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency