I've been considering building a simulation game for some time. Not for commercial use, more for the fun and potentially my own use and some of my friends etc.
Here's something that's been puzzling me for a while.
All my inventory and settings will be housed in a mySQL database.
I was initially going to code my site to directly interact with my database but am familiar with the concept of web services and how different sites share information between them or different systems in one environment share information but...
I understand and really want to control things via an intermediate medium (maybe a API or web service). This way my site isn't directly updating my database and if i want to change settings i just update my web services.
Is this a good idea?
Where do I get started with having web services on my own disk talking to my mySQL database etc?
Is there a plug an play web service out there or is there a simple function within PHP to achieve this?