项目作者: TomGrozev

项目描述 :
A very simple database manager
高级语言: JavaScript
项目地址: git://github.com/TomGrozev/Simple-Database-Manager--DBMS-.git
创建时间: 2017-10-09T13:45:19Z
项目社区:https://github.com/TomGrozev/Simple-Database-Manager--DBMS-

开源协议:Other

下载


Simple Database Manager (DBMS)

This is a very simple database manager that I made for a school project a while back. It works well as a database management system and currently, it is set up as an Australian Football (AFL) merchandise database (this is easy to change to your needs).

In essence, it has customers, products, orders and suppliers tables and can be viewed and edited in either a list view or portal view. There is a full invoice generator system included for the orders table. There are some examples of reports that can be made such as the most popular product per month. There is a graph that displays the data for some of the reports.

Index Page
Portal Page

Disclaimer

I know that in its current state it has some errors and isn’t designed very well and looking back I would have made this system very differently now. I will be updating it in the future but any contributions are greatly appreciated.

Why?

I will be updating this repository in the future but due to a request for something similar on StackOverflow I decided to post this for any that may need a system similar to this.

Getting Started

These instructions are purely for getting you a copy of the project up and running on your local machine for development and testing purposes. On my local machine, I use a program called MAMP, I highly recommend it and it’s free! See deployment for notes on how to deploy the project on a live system.

Prerequisites

What you need to have installed to use the software. I recommend installing MAMP as it is a GUI interface that installs and manages all of these packages, I cannot recommend it enough, it saves you a great deal of time.

If you haven’t already got it Sublime Text is probably the best text editor for coding, seriously just get it, it’s free!

  1. PHP Server
  2. Apache Server
  3. MYSQL Server

Installing

Simply put the contents of the folder into your web server folder.

E.g for the default location of MAMP’s web directory on macOS

  1. /Applications/MAMP/htdocs/

So that your file structure should look like

  1. /Applications/MAMP/htdocs/assets
  2. /Applications/MAMP/htdocs/invoice
  3. /Applications/MAMP/htdocs/index.php
  4. /Applications/MAMP/htdocs/...

Upload the Database Save.sql to your MySQL database.

Edit the database config at the top of each PHP file to fit your database details (I know it’s tedious but it’s late and I’ll probably just add a config file tomorrow).

  1. $servername = "localhost";
  2. $username = "root";
  3. $password = "root";
  4. $dbname = "afl";

If it works you should be getting the results like in the images above.

Styling

Style it to how it fits your needs. I will be making a template feature so please send them I will be happy to receive them.

CSS file in

  1. assets/css/style.css

Deployment

After testing this and modifying to your needs on your local system simply repeat the install process for your public web server.

Contributing

Please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to us.

Versioning

This repository SemVer for versioning. For the versions available, see the tags on this repository.

Authors

See also the list of contributors who participated in this project.

License

This project is licensed under the MIT License - see the LICENSE.md file for details

Acknowledgments

  • Hat tip to anybody’s code that was used that I failed to mention