Solved

One or two databases?

Posted on 2014-11-12
4
122 Views
Last Modified: 2014-11-19
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
0
Comment
Question by:burnedfaceless
  • 2
4 Comments
 
LVL 5

Expert Comment

by:meb_santoso
ID: 40437042
Let's put all the technical stuffs aside for a minute:
-. have you considered to just place the whole system online so that the two departments can work on single db (or single set of db)?
-. It will save you development and deployment time, costs --and maintenance.

On your questions:
1. See above
2. Depends on your setup and/or deploment scenario. SSL will secure the transaction / data interchange between the client(s) and the server; i think it should also secure server to server connection.
3. Depends on your setup (again); on a *nux based server, you can make use of the cron command (google it, it's easy!). The easiest would be a daily backup of the whole database and/or system (html / php files as well) and let it transferred to some off-site location. Yes, scripts are available, but if you use cPanel for your web control panel, it's easier :-) *your mileage and preferences may vary*
4. Oh boy....
0
 
LVL 108

Accepted Solution

by:
Ray Paseur earned 500 total points
ID: 40437048
You probably need to get professional help from a web development company.  There are (at least) a couple of years of college between these questions and the best-practices answers.  With all the storage businesses that exists today, you may be able to find software that is already built; you can license something and get started immediately.  But you may find that this is PC software and not web enabled.

To handle the login portion, you can follow the design patterns here:
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_2391-PHP-login-logout-and-easy-access-control.html

You probably want to use ONE database.  More databases for something like this means more headaches.  Just learn about the "normalization" process and have a DBA help you organize your tables before you start.

SSL will help keep data secure during internet transmission, but the more likely security exposure will occur when a careless employee leaves a logged-in computer or accidentally loses a laptop.  Or when a programming error exposes data inappropriately.  Security is a full-time, four year college major at the University of Maryland.  You may want to join OWASP to learn more.

Automatic and secure backups can be arranged by your hosting provider. Consider cloud-based hosting or a highly professional host like Blackmesh.

The MySQL manual is all online, as is the PHP manual.  
http://dev.mysql.com/
http://php.net/docs.php
0
 

Author Closing Comment

by:burnedfaceless
ID: 40453575
Thanks
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 40454026
Thanks for the points and thanks for using E-E, and best of luck with your project. ~Ray
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now