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