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.mdHow 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
