I'm planning to make a PHP and MySQL Point of Sale program through XAMPP. The plan is to make a whole database program server that will contain the stats while the client program that's intended to be connected to it be used by the clients so they could update their stats.
For example: Clients would be named Store1 and Store2 for the store chain and they'll be limited to submit stats/daily reports only and I'll be the overseer with Main server since I'm the owner lol (with different username and passwword). Next is to make a .exe file installer so they could easily install it without me having to install many other apps/copy the program all the way through.
I won't be asking directly to the specifics of coding them all yet but I want to know how do I proceed with this plan? What should be the flow of the procedure?
The main questions are:
Is it possible to make a .exe installer (for Windows 10) for that client specific program I made so they could just update the stat reports? If so how, which applications or admin system do I need to access or use for it?
Would it be possible that when the .exe file is installed, the client could already connect to my database server ofc with given username and passwords?
For example the main database server went offline (power outage) and while the client is online, he updated the stats but I'm still offline, when I get online again, would the main database server also get updated with the changes he made automatically?
Would the changes I made in the system affect the installed client program from the client's PC instantly? Or would it automatically update it? Or do I have to create another installer for each update?
I know this could be a pretty big question but thank you all so much for considering.