One or two databases?
Posted on 2014-11-12
The business I am designing a website we are considering making use of php and MySQL to automate some functions.
This business is unit storage and is divided into two departments in two different physical locations a considerable distance away.
We were considering moving from our manual system to one where the storage department can access a html page, login, view available units, and when one is rented send an invoice or a bill depending on how they have it set up.
Regardless I thinking of having two separate databases, one for invoices and bills, and granting both departments read access to both databases, but the ability to write only to their own database.
I had some questions
1. Have I provided enough information to let me know if I'm on the right track with two databases
2. I need some hefty reading on how to securely login to MySQL database from php. Ebooks are preferred. Would SSL affect this situation? I've worked through some books but I feel like I need something dense for it to be secure.
3. What is the best way to automatically and securely backup your databases? I'm guessing you can write some scripts?
4. I never learned SQL commands and I have to build these with that so I need a book to read on that too thanks