B4J Question [BANanoVueMaterial] Error on cloud

[micro]

Hi to all
always for my tests I loaded a simple project for reading table from a mysql db on my cloud space (aruba)
In local it's work fine (with laragon server).
if I start the call remotely the project starts and the graphic part is loaded but I don't read the tables because I don't access labarc.php

Sub Process_Globals
    Public BANano As BANano 'ignore
    Public AppName As String = "labarc"
    Public AppTitle As String = "LabArc"
    Private Publish As String = "C:\laragon\www"
    Public ServerIP As String = "XX.XX.XX.XX"
    Public Version As String = "1.00"
    Public Port As String = "80"'"8080"
End Sub

the address to point to labarc.php is wrong, why?

if I correct the link and insert it in the address bar of the browser, the php file answers correctly with: ' invalid request: '

 

[Mashiane]

This is just incorrect:

The issue is how you have set up your PHP host, because the path to the php file to be executed is read from there.

Propably its this,

BANano.PHPHost = $"http://${ServerIP}:${Port}/${AppName}/"$

You can either use the actual web server address on it

For example

BANano.PHPHost = "http://www.labarc.com/labarc/"

or, remove the port indicated.

BANano.PHPHost = $"http://${ServerIP}/${AppName}/"$

Ta!

 

[micro]

or, remove the port indicated.

Ok, now the link is correct.

the database on the cloud is a copy equal to the one present locally (localhost) only that locally I can see all the tables while on the cloud even if it says that the tables have all been loaded you do not see anything

On the cloud

Local

tests made with the code correct by you
https://www.b4x.com/android/forum/t...tabase-schema-data-solved.121559/#post-760503
Post#8

Thanks

 

[Mashiane]

Q1. Which database backend are you using on the cloud?
Q2. Is your cloud database open to the outside world?

 

[micro]

Q1. Which database backend are you using on the cloud?
Q2. Is your cloud database open to the outside world?

Mysql for DB
It is accessible from the outside but it is private for work

 

[Mashiane]

Will continue this via the DM as I will need more details.

Ta!

 

[micro]

Thanks Mashiane for your suggestion on the case-sensitive problem.
Another question:
If i insert after I loaded the data into the table this code:

dt1.SetColumnWidth("id", 0)

The id column is always visible with the right width, why?