You can use JSON with older versions of MYSQL. You may need to write a MYSQL function or let your programming language of choice encode/decode JSON. For example, you can convert a JSON string to an array, save it to the DB and when you pull it back out of the DB, you can covert it back to a JSON object. You can also use serialize to covert an object to a string before saving. Every programing language I can think of either provides a function or your can write your own.
You can change your Apache public directory using the GUI provided by Cloudways. I think it's under "application settings".
Sagar Kapasi, you're the noob.
You can use JSON with older versions of MYSQL. You may need to write a MYSQL function or let your programming language of choice encode/decode JSON. For example, you can convert a JSON string to an array, save it to the DB and when you pull it back out of the DB, you can covert it back to a JSON object. You can also use serialize to covert an object to a string before saving. Every programing language I can think of either provides a function or your can write your own.
You can change your Apache public directory using the GUI provided by Cloudways. I think it's under "application settings".