Retrieving hosted MySql/MariaDB data using api

[hua]

A hosting company I'm using provide MySql database but doesn't opened it to world so I can't use FWCONNECT.

They suggest I create a script to act as an api to communicate with the server.

Anyone has done something similar? The script would need to cover the usual stuffs; adding, editing record, make enquiry

TIA

[anserkk]

1. You can have a php script on your hosted server.
2. You will be calling this php script from your Fivevin application
3. This php script will accept parameters from your Fivewin application which will be your SQL queries or Data manipulation commands
4. This php script will return the resulting recordset as JSON
5. The JSON data received from the hosted server will be processed in your fivewin application

[hua]

Thanks for the quick reply Anserk. Now I have a starting point

If anyone else has some useful links, pointers especially code snippets to share they are welcomed and I thank you in advance

The database in question need not even be a MySql database but simple dbfs