Android Question About RDC

[MohammadNew]

Hello everyone , Could you give me answer please ?

I saw the thread about RDC

https://www.b4x.com/android/forum/t...connector-rdc-connect-to-any-remote-db.31540/

I talk about Mysql

This fie after modify
DriverClass= what I write her
JdbcUrl= also

where put it ? can I put it in my hosting not localhost like php file and just alone or with other files ?

Where is jdbc_driver folder ?

until now this questions enough

Thanks alot .

Warm Regards

 

[Anser]

Hello everyone , Could you give me answer please ?

I saw the thread about RDC

https://www.b4x.com/android/forum/t...connector-rdc-connect-to-any-remote-db.31540/

I talk about Mysql

This fie after modify
DriverClass= what I write her
JdbcUrl= also



where put it ? can I put it in my hosting not localhost like php file and just alone or with other files ?

Where is jdbc_driver folder ?

until now this questions enough

Thanks alot .

Warm Regards

if you are using MySQL then yo dont have to change anything

DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://YourMySqlServerIP:YourMySqlPortNumber/YourDatabaseName?characterEncoding=utf8

Where is jdbc_driver folder ?

It is mentioned in the post itself https://www.b4x.com/android/forum/t...connector-rdc-connect-to-any-remote-db.31540/
http://dev.mysql.com/downloads/connector/j/

 

[MohammadNew]

Thanks Anser, could you tell me can I put it in my hosting (smarterasp.net) or just localhost ?

I downloaded the mysql-connector-java-5.1.41

where is the jdbc_driver folder ?

Thanks again.

 

[Anser]

could you tell me can I put it in my hosting (smarterasp.net) or just localhost ?

If you are having a VPS server with your hosting provider then you can put jRDC folder anywhere on that server. The jRDC.jar should run on the server.

where is the jdbc_driver folder ?

If I am not wrong, the driver will be included in the jRDC.jar

 

[DonManfred]

can I put it in my hosting (smarterasp.net)

if you have a VPS with Remotedesktop root access, then yes.
The cheap hosting does not have root access so you are not able to start a java server i guess.

Best is to ask [email protected]

 

[MohammadNew]

I wrote a ticket (My hosting has VPS with Remotedesktop root access?)

and I am waiting them.

 

[MohammadNew]

Thanks alot DonManfred

 

[MohammadNew]

if you have a VPS with Remotedesktop root access, then yes.
The cheap hosting does not have root access so you are not able to start a java server i guess.

Best is to ask [email protected]

I asked them then told me "Your hosting is shared without VPS"

Now I am looking for VPS hosting.

thanks Mr. DonManFred

 

[MohammadNew]

Now my question is : RDC allow in my hosting without VPS server SSD... or same the JRDC v2 ?

 

[Erel]

Same requirements as jRDC2. You need a VPS.

 

[MohammadNew]

Ok Mr. Erel,

what is better I put sql statement inside php file or with code B4A for fast and secur ?

 

[Erel]

It is more secure to put the statements in the php file. Make sure to correctly escape all parameters.

 

[MohammadNew]

It is more secure to put the statements in the php file. Make sure to correctly escape all parameters.

this is php file how to modify it to write the sql statement inside the php file ? give me your help please .

<?php

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

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