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
-
Download and Install XAMPP :
- Go to https://www.apachefriends.org/index.html and download XAMPP.
-
Start XAMPP :
- Open the XAMPP control panel.
- Start the Apache and MySQL services.
-
Access
htdocs
Directory :- In your XAMPP installation directory, navigate to the
htdocs
folder. - This is where you'll place your web projects.
- In your XAMPP installation directory, navigate to the
-
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
-
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 ( usuallyutf8_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.
- Open phpMyAdmin by going to
-
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
).
- Open your browser and type
-
Default Login Credentials
- Upon accessing the web application for the first time, use the following default login credentials:
- Email : anjalita@sjec.in
- Password : asdf1973
- Upon accessing the web application for the first time, use the following default login credentials:
-
Work on the Project:
- Any changes made within the cloned repository will reflect on the localhost URL (e.g.,
http://localhost/DailyExpense-System
).
- Any changes made within the cloned repository will reflect on the localhost URL (e.g.,
-
Manage XAMPP Services:
- Use the XAMPP control panel to start/stop Apache, MySQL, and other services as needed.