I am trying to get my raspberry pi to act as a server for the database and datatransfer for our android app aswell as a simple php page as a admin panel, and want help with setting up everything correctly, currently we're in the stage where we can reach the standard index page from other computers on the network but the rest of the world cant.
In the server we will need first of all to port forward it i assume, so the rest of the world can reach it, but also php, mysql db aswell a SQLite DB.
Some info about the entire project: We have a search app where you search on streets that been using a local json file meaning every time we make a update everyone have to download the app once again. we have been remaking it so the main purpose of this server is to store data in a database so we can update the database on the server, then all users of the app will get fully updated sqlite db's pushed to them once every day or so. i belive the steps would be like MYSQL-> server SQlite -> local SQlite