From recordset to json

Hi there I have a desktop application that historicaly accessed a local MySQL database, then we ported that database to a cloud server, giving the same acces (MySQL connection) to not change the app. We know this is a security issue and now they are asking me to change that.

The client wants the databases on their servers now, they will not open any port at all, we only have http or https and PHP7 to access the database, so we can have scripts to get access, query and return the results in json or whatever format.

Is there any plugin or code so the json could look or behave like a record set, not to change all the system, we use a lot of SQLSelect, SQLExecute, databaserecords, recordset

Thanks in advance

Your post is titled “From recordset to json” but then you ask “Is there any plugin or code so the json could look or behave like a record set” which is highly confusing and all this additional info about what your client wants and why just thickens the fog…How do you obtain “the json”? Show us some code!

Sounds like Aloe could help especially the luna express module