Android Question connect remote server

[Jose Briceño]

I need to connect to a Mysql Remote Server with port 3306, I want to know what is the best way to do it. Thank you

 

[DonManfred]

Best: jRDC2
Alternative: JdbcSQL

 

[BillMeyer]

It never ceases to amaze me how this forum works.

1 Question - 5 Answers and 2 tips from an Expert - just like that !!

Are we not a PRIVILEGED Bunch ??

 

[Jose Briceño]

this webservice marks me error, take it out of the forum

<?php

$databasehost = "http://201.111.111.111";
$databasename = "softcont";
$databaseusername ="softcont_root";
$databasepassword = ",sUF]AU8lH)m";


$con = mysql_connect($databasehost,$databaseusername,$databasepassword) or die(mysql_error());
mysql_set_charset("utf8");
mysql_select_db($databasename) or die(mysql_error());
$query = file_get_contents("php://input");

$sth = mysql_query($query);


if (mysql_errno()) {
header("HTTP/1.1 500 Internal Server Error");
echo $query.'\n';
echo mysql_error();
}
else
{
$rows = array();
while($r = mysql_fetch_assoc($sth)) {

$rows[] = $r;
}


print json_encode($rows);
}

[23-Mar-2019 15:36:49 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/cso43215/public_html/pasajes.php on line 9

 

[DonManfred]

Please use [CODE]code here...[/CODE] tags when posting code.

Use a MySQLi Class with PHP. the old mysql class is no longer supported.

 

[Jose Briceño]

Excuse me for the code, but I already solve it .. thanks