I'm making a website for an e-commerce purpose. On the main page there will be a permanent text-block or a featured article, which is going to display information about latest money transactions.
For security reasons I want to hide the source where this information is coming from. So I decided to create 2 sites:
a) "Main Site" (MS): will be a fully custom site with an engine, which will be responsible to deal with and handle financial transactions. This site will contain all financial data and will be known/accessible only for limited people.
b) "Customer Site" (CS): will provide basic information along with "Latest transaction" page.
Main point is that "Latest transaction" on CS will be just a static copy of "latest" table in MS database and will not be available to be tracked back, as it will be uploaded/input from MS side each time when there is a new transaction. I presume that even if someone dumps the CS database, he/she will only be able to get a plain-text, without reaching the core database in MS. Because data input will be one-way from MS to CS.
Here is the draft scheme how I assume it to be, but don't know how to do:
- Database-to-Database: to write a custom php file, which will be triggered after a new transaction and copy "latest" table values from MS database to a "latest" table in CS database.
Thanking in advance for any ideas, guides and especially for inputs.