Daily Expense Tracker System Using PHP and MySQL

Daily Expense Tracker System Using PHP and MySQL

Daily Expense Tracker using PHP and MySQL is web based application. This application used to manage daily expenses of a user.

Project Name Daily Expense Tracker System
Language Used PHP5.6, PHP7.x
Database MySQL 5.x
User Interface Design HTML, AJAX,JQUERY,JAVASCRIPT
Web Browser Mozilla, Google Chrome, IE8, OPERA
Software XAMPP / Wamp / Mamp/ Lamp (anyone)

Daily Expense Tracker — overview

Core features

  • User registration & login (per-user data)

  • Expense categories (food, transport, bills, etc.)

  • Add / edit / delete expenses (date, amount, category, note)

  • View daily / monthly / custom-range reports & totals

  • Export CSV of expenses

  • Simple responsive UI (Bootstrap)

  • Basic security: prepared statements, password hashing, session use

Project structure

expense-tracker/
├─ sql/
│ └─ expense_tracker.sql
├─ public/
│ ├─ index.php # home / dashboard (monthly summary)
│ ├─ login.php
│ ├─ register.php
│ ├─ logout.php
│ ├─ expenses.php # list + filter + delete
│ ├─ add_expense.php
│ ├─ edit_expense.php
│ ├─ categories.php # admin or user categories
│ ├─ export_csv.php
│ └─ assets/
│ ├─ css/
│ └─ js/
├─ includes/
│ ├─ config.php
│ ├─ functions.php # helper functions (e(), csrf, etc.)
│ └─ header.php
└─ README.md

How to run the Daily Expense Tracking System Project

1. Download the zip file
2. Extract the file and copy dets folder
3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/html)
4. Open PHPMyAdmin (http://localhost/phpmyadmin)
5. Create a database with name detsdb
6. Import detsdb.sql file(given inside the zip package in sql file folder)
7.Run the script http://localhost/dets (frontend)
*****************Credential for user panel OR you can register your self******************
Username: testuser@gmail.com
Password: Test@123

 

Download Daily Expense Tracker System Using PHP

CodeCapsule

Sanjit Sinha — Web Developer | PHP • Laravel • CodeIgniter • MySQL • Bootstrap Founder, CodeCapsule — Student projects & practical coding guides. Email: info@codecapsule.in • Website: CodeCapsule.in

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *