Income-and-Expenditure

Expense Tracker Track Income Track Expense

Description

Budget is a simple web app that provides a means for users to record their income and expenses. It helps you to keep track of your spending. Budget is written in Vanilla php.

Features

• Authentication
• Create multiple accounts or books
• Record Income
• Record Expense

Techonologies used

Languages

• Vanilla PHP
• MYSQL
• HTML
• CSS
• JS

Dependency Manager

• composer

Configuration

Go to root and run the commands

composer install
cd public
php -S localhost

Database Structure

Category Table must be filled with Income category and Expense category.
Sub category table must be filled with any sub category of your choice each sub category belonging to a catgory. For example, sub categories movies, food, entertainment can belong to the expense category on the other hand sub categories salary, bonus, gift can belong to the income catgeory.

---

Below is the database structure, define `foreign constraint` where neccessary

Table	Columns
users	user_id, first_name, last_name, email, password, date_registered
books	book_id, user_id, book_name, book_desc, book_date, category_id
transactions	transaction_id, user_id, book_id, category_id, type, sub_category_id, transaction_amount, transaction_desc, transaction_date
category	category_id, category_name, category_desc
category	sub_category_id, category_id, sub_category_name

Database configuration

The only configuration needed is in the config/config.php file, open it and set your Database Configurations.

Ready made database

A budget.sql file is availabe at the root of this repo. Import this to your database to kickstart the app.