Skip to content

This 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 and cash inflow.

Notifications You must be signed in to change notification settings

Timadey/Income-and-Expenditure

Repository files navigation

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.


About

This 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 and cash inflow.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published