K kroesperanza Member Mar 30, 2020 #1 I'm new in using B4A and my only problem is to connect b4a to my database in cpanel. (there is no problem if im using xampp localhost). Thanks for the help
I'm new in using B4A and my only problem is to connect b4a to my database in cpanel. (there is no problem if im using xampp localhost). Thanks for the help
Erel B4X founder Staff member Licensed User Longtime User Mar 30, 2020 #2 Question is not clear. kroesperanza said: (there is no problem if im using xampp localhost). Click to expand... What does it mean? kroesperanza said: connect b4a to my database in cpanel Click to expand... There is no such thing. cPanel and phpmyadmin are tools that help you manage databases. You need to connect to the database server. Upvote 0
Question is not clear. kroesperanza said: (there is no problem if im using xampp localhost). Click to expand... What does it mean? kroesperanza said: connect b4a to my database in cpanel Click to expand... There is no such thing. cPanel and phpmyadmin are tools that help you manage databases. You need to connect to the database server.
K kroesperanza Member Mar 30, 2020 #3 This tutorial has no problem. but what if im using web hosting (because it has also phpmyadmin) Upvote 0
Erel B4X founder Staff member Licensed User Longtime User Mar 30, 2020 #4 Even the product name is wrong in this tutorial. There are two ways to connect to a remote database: JdbcSQL or jRDC2. JdbcSQL: https://www.b4x.com/android/forum/t...ly-connect-to-remote-databases.84016/#content jRDC2: https://www.b4x.com/search?query=jRDC2 jRDC2 which is the recommended method requires shell access. JdbcSQL requires the database to allow external connection. If external connections are not enabled then you cannot connect to the database. Upvote 0
Even the product name is wrong in this tutorial. There are two ways to connect to a remote database: JdbcSQL or jRDC2. JdbcSQL: https://www.b4x.com/android/forum/t...ly-connect-to-remote-databases.84016/#content jRDC2: https://www.b4x.com/search?query=jRDC2 jRDC2 which is the recommended method requires shell access. JdbcSQL requires the database to allow external connection. If external connections are not enabled then you cannot connect to the database.
K kroesperanza Member Mar 30, 2020 #5 I can connect it even if it is online web hosting ? Thanks Ill try this one Upvote 0
K kroesperanza Member Mar 30, 2020 #6 #DATABASE CONFIGURATION DriverClass=com.mysql.jdbc.Driver JdbcUrl=jdbc:mysql://(IP ADDRESS OF MY HOSTING)/starlan1_sms?characterEncoding=utf8 User=databaseusername Password=databasepassword #Java server port ServerPort=2083 (im using 2083 because it is remote) is this correct? Upvote 0
#DATABASE CONFIGURATION DriverClass=com.mysql.jdbc.Driver JdbcUrl=jdbc:mysql://(IP ADDRESS OF MY HOSTING)/starlan1_sms?characterEncoding=utf8 User=databaseusername Password=databasepassword #Java server port ServerPort=2083 (im using 2083 because it is remote) is this correct?
josejad Expert Licensed User Longtime User Mar 30, 2020 #7 kroesperanza said: I can connect it even if it is online web hosting ? Click to expand... It depends on the host. Maybe your host is online, but just let connect to the database from a web page inside the same host, not allow it from another webpage or external service. Upvote 0
kroesperanza said: I can connect it even if it is online web hosting ? Click to expand... It depends on the host. Maybe your host is online, but just let connect to the database from a web page inside the same host, not allow it from another webpage or external service.
DonManfred Expert Licensed User Longtime User Mar 30, 2020 #8 kroesperanza said: I can connect it even if it is online web hosting ? Click to expand... probably not. You need to check with your Provider. Upvote 0
kroesperanza said: I can connect it even if it is online web hosting ? Click to expand... probably not. You need to check with your Provider.
barx Well-Known Member Licensed User Longtime User Mar 30, 2020 #9 Most hosts (especially shared hosts) do not allow directc connection from outside to MySQL DB. Some will allow you to specify certain IP's to allow connection. The only real work around i know of is to create an API in PHP. Upvote 0
Most hosts (especially shared hosts) do not allow directc connection from outside to MySQL DB. Some will allow you to specify certain IP's to allow connection. The only real work around i know of is to create an API in PHP.
K kroesperanza Member Mar 31, 2020 #10 DonManfred said: probably not. You need to check with your Provider. Click to expand... Correct me if I'm wrong sir I'm still new in mobile applications. Using B4A there is no such way to connect my application in my web hosting like cPanel which it has also phpmyadmin? The only way is to connect it to the PC server that has JRDC and it is 24/7 online to connect my apps in the database? Thanks please help me in this matter Last edited: Mar 31, 2020 Upvote 0
DonManfred said: probably not. You need to check with your Provider. Click to expand... Correct me if I'm wrong sir I'm still new in mobile applications. Using B4A there is no such way to connect my application in my web hosting like cPanel which it has also phpmyadmin? The only way is to connect it to the PC server that has JRDC and it is 24/7 online to connect my apps in the database? Thanks please help me in this matter
DonManfred Expert Licensed User Longtime User Mar 31, 2020 #11 kroesperanza said: Using B4A there is no such way to connect my application in my web hosting like cPanel which it has also phpmyadmin? Click to expand... They are not related to mobil apps. Install your own php-scripts will do the trick. You can communicate with your php-scripts using okhttputils2. Search the forum; there are some Tutorials. A direct db-connection is most probably not possible with your Provider (as the most providers prevent this).. The best solution (#4) is jrdc2 (but you need a Server (not hosting) or VPS to be able to run it). Upvote 0
kroesperanza said: Using B4A there is no such way to connect my application in my web hosting like cPanel which it has also phpmyadmin? Click to expand... They are not related to mobil apps. Install your own php-scripts will do the trick. You can communicate with your php-scripts using okhttputils2. Search the forum; there are some Tutorials. A direct db-connection is most probably not possible with your Provider (as the most providers prevent this).. The best solution (#4) is jrdc2 (but you need a Server (not hosting) or VPS to be able to run it).
