Android Question Put data to MySQL Database?

ilan said:

can you recommend on a hosting that support remote access?

Click to expand...

Version 1.3 (Update 08 Feb 2019)
- Set targetSdkVersion=26
- Replaced HttpUtils2 with OKHttpUtils2
- Changed conflicting Job names with module names
- Added Change Password activity
- Removed Forgot Password activity
- Replaced MySQL functions in PHP script with MySQLi functions
- Added db.php in PHP script to store global variables

Click to expand...

DonManfred said:

Sorry in German, but

https://all-inkl.com/webhosting/uebersicht/

Click to expand...

aeric said:

You may refer to my code snippet Register User example using HttpUtils2

Click to expand...

DonManfred said:

Sorry in German, but

https://all-inkl.com/webhosting/uebersicht/

Click to expand...

ilan said:

so if i purchase a package on this hosting i can use jrdc?

Click to expand...

ilan said:

i also shared an example using php + mysql. but i dont understand what you mean change mysql to mysqli

Click to expand...

<?
$table = "tbl_users";
include ("db.php");

// $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'");

$con = new mysqli($host, $user, $pw, $db);
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}
mysqli_set_charset($con, "utf8");

$action = $_GET["action"];
 
switch ($action)
{
    Case "GetUserName":
        $username = $_GET["username"];
        // $q = mysql_query("SELECT password FROM $table WHERE username='$username'");
        $q = mysqli_query($con, "SELECT password FROM $table WHERE username='$username'");
        $rows = array();
        // while($r = mysql_fetch_assoc($q))
        while($r = mysqli_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')");
        $q = mysqli_query($con, "INSERT INTO $table (username, password) VALUES ('$username', '$password')");
        print "Inserted";
    break;
}
?>

ilan said:

where do i make the change? in the cpanel of my hosting?

Click to expand...

ilan said:

so how does it works exactly? i uploade the server.jar that is created with b4j to my ftp account and then i can connect my b4a app and send data to that server and receive data from it?

Click to expand...