ebeyjoeregi/personal-expense-tracker

A DBMS project on Personal Expense Tracking

Personal Expense Tracker

The Expense Tracking Database Management System DBMS project is a user-friendly application that allows an unlimited number of users to register, log in, and efficiently manage their personal expenses across diverse categories. Users have the flexibility to add, view, and delete expenses, providing a seamless experience for tracking their financial activities. The system also empowers users to manage expenses by sorting them based on months and categories, facilitating a clear overview of their spending habits. Moreover, the DBMS generates detailed expense reports on a daily, monthly, and yearly basis, assisting users in making informed financial decisions. This project simplifies expense tracking and enhances financial management for users of all backgrounds

Installation

1. Download and Install XAMPP :

   • Go to https://www.apachefriends.org/index.html and download XAMPP.

2. Start XAMPP :

   • Open the XAMPP control panel.
   • Start the Apache and MySQL services.

3. Access htdocs Directory :

   • In your XAMPP installation directory, navigate to the htdocs folder.
   • This is where you'll place your web projects.

4. Fork and Clone the Repository :

   • Fork the repository to your GitHub account by clicking the "Fork" button at the top right of the repository page.
   • Open a terminal or command prompt.
   • Navigate to the htdocs directory in your XAMPP installation folder:

     cd /path/to/xampp/htdocs

   • Clone the forked repository from your account:

     git clone https://github.com/EbeyJoeRegi/Personal-Expense-Tracker.git

5. Setting up the Database :

   • Open phpMyAdmin by going to http://localhost/phpmyadmin in your browser.
   • Log in using the default credentials ( username: root, no password by default ).
   • Create a new database:
     • Click on "Databases" in the top menu.
     • Enter a name for the database - dailyexpense and choose the appropriate collation ( usually utf8_general_ci ).
     • Click "Create".
   • Import the SQL file from the repository:
     • Click on the newly created database from the left sidebar.
     • Choose "Import" from the top menu.
     • Click "Choose File" and select the SQL file provided in the repository.
     • Click "Go" to import the data into the database.

Usage

1. Access the Project :

   • Open your browser and type http://localhost/repository-folder-name to access the project.
   • Replace repository-folder-name with the name of the folder created during the cloning process (By default : DailyExpense-System).

2. Default Login Credentials

   • Upon accessing the web application for the first time, use the following default login credentials:
     • Email : [email protected]
     • Password : asdf1973

3. Work on the Project:

   • Any changes made within the cloned repository will reflect on the localhost URL (e.g., http://localhost/DailyExpense-System).

4. Manage XAMPP Services:

   • Use the XAMPP control panel to start/stop Apache, MySQL, and other services as needed.

---