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
Retrieving hosted MySql/MariaDB data using api
Retrieving hosted MySql/MariaDB data using api
FWH 11.08/FWH 19.03
xHarbour 1.2.1 (Rev 6406) + BCC
Harbour 3.1 (Rev 17062) + BCC
Harbour 3.2.0dev (r1904111533) + BCC
xHarbour 1.2.1 (Rev 6406) + BCC
Harbour 3.1 (Rev 17062) + BCC
Harbour 3.2.0dev (r1904111533) + BCC
Re: Retrieving hosted MySql/MariaDB data using api
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
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
Re: Retrieving hosted MySql/MariaDB data using api
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
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
FWH 11.08/FWH 19.03
xHarbour 1.2.1 (Rev 6406) + BCC
Harbour 3.1 (Rev 17062) + BCC
Harbour 3.2.0dev (r1904111533) + BCC
xHarbour 1.2.1 (Rev 6406) + BCC
Harbour 3.1 (Rev 17062) + BCC
Harbour 3.2.0dev (r1904111533) + BCC