Creating a Personal Finance Manager project involves several components, including a MySQL database schema, file structure, layout design using Bootstrap 5, and complete PHP scripts for user authentication and management. Below is a comprehensive guide to help you set up your system.
Project Introduction
The Personal Finance Manager is designed to help users manage their financial activities effectively. This system allows users to track their income and expenses, manage budgets, set financial goals, and monitor their savings and investments. With a robust MySQL database backend, the platform ensures secure data management and provides a user-friendly experience for individuals looking to take control of their personal finances.
Project Objectives
- To create a secure user registration and login system for managing personal finance.
- To enable users to create and manage multiple financial accounts, including bank accounts and credit cards.
- To facilitate the tracking of transactions, categorizing them as income or expenses.
- To allow users to set and manage budgets for different categories of spending.
- To provide tools for setting and tracking financial goals, including savings targets.
- To enable users to manage their savings and investments across various types.
- To track debts and provide insights into repayment schedules and interest rates.
- To send alerts and notifications to users regarding important financial activities and reminders.
Project Modules
- User Management: Handles user registration, login, and profile management.
- Account Management: Allows users to create, update, and manage their financial accounts.
- Transaction Management: Facilitates the recording and tracking of financial transactions.
- Budget Management: Enables users to set and monitor budgets for different spending categories.
- Financial Goals Management: Allows users to set, track, and manage their financial goals.
- Savings and Investments Management: Provides tools for managing savings and investment portfolios.
- Debt Management: Helps users track their debts, including total and remaining amounts.
- Notification System: Sends alerts and notifications to users regarding important financial updates.
1. MySQL Database Schema
CREATE DATABASE personal_finance_manager;
USE personal_finance_manager;
-- Table for users
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL,
email VARCHAR(100) NOT NULL UNIQUE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- Table for accounts
CREATE TABLE accounts (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
account_name VARCHAR(100) NOT NULL,
account_type ENUM('bank', 'credit_card', 'investment') NOT NULL,
balance DECIMAL(10, 2) NOT NULL DEFAULT 0.00,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for transactions
CREATE TABLE transactions (
id INT AUTO_INCREMENT PRIMARY KEY,
account_id INT NOT NULL,
transaction_date DATETIME NOT NULL,
amount DECIMAL(10, 2) NOT NULL,
category VARCHAR(100) NOT NULL,
description TEXT,
type ENUM('income', 'expense') NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (account_id) REFERENCES accounts(id) ON DELETE CASCADE
);
-- Table for budgets
CREATE TABLE budgets (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
category VARCHAR(100) NOT NULL,
budget_amount DECIMAL(10, 2) NOT NULL,
start_date DATE NOT NULL,
end_date DATE NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for financial goals
CREATE TABLE financial_goals (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
goal_name VARCHAR(100) NOT NULL,
target_amount DECIMAL(10, 2) NOT NULL,
current_amount DECIMAL(10, 2) NOT NULL DEFAULT 0.00,
due_date DATE NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for savings and investments
CREATE TABLE savings_investments (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
investment_name VARCHAR(100) NOT NULL,
amount DECIMAL(10, 2) NOT NULL,
investment_type ENUM('savings', 'stocks', 'bonds', 'real_estate') NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for debts
CREATE TABLE debts (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
debt_name VARCHAR(100) NOT NULL,
total_amount DECIMAL(10, 2) NOT NULL,
remaining_amount DECIMAL(10, 2) NOT NULL,
interest_rate DECIMAL(5, 2) NOT NULL,
due_date DATE NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for alerts and notifications
CREATE TABLE notifications (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
message TEXT NOT NULL,
is_read BOOLEAN DEFAULT FALSE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
2. File and Folder Structure
personal_finance_manager/
│
├── config/
│ └── db.php
│
├── public/
│ ├── index.php
│ ├── login.php
│ ├── register.php
│ ├── dashboard.php
│ ├── accounts.php
│ ├── transactions.php
│ ├── budgets.php
│ ├── goals.php
│ ├── savings_investments.php
│ ├── debts.php
│ ├── notifications.php
│ └── admin_dashboard.php
│
├── includes/
│ ├── header.php
│ ├── footer.php
│ └── functions.php
│
├── assets/
│ ├── css/
│ │ └── styles.css
│ ├── js/
│ │ └── scripts.js
│ └── images/
│
└── vendor/
└── (Bootstrap and other libraries)
3. Layout Based Design with Bootstrap 5
Header (includes/header.php)
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="assets/css/styles.css">
<title>Personal Finance Manager</title>
</head>
<body>
<div class="container">
<header class="my-4">
<h1>Personal Finance Manager</h1>
</header>
<nav class="navbar navbar-expand-lg navbar-light bg-light">
<div class="container-fluid">
<a class="navbar-brand" href="index.php">Home</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" href="accounts.php">Accounts</a>
</li>
<li class="nav-item">
<a class="nav-link" href="transactions.php">Transactions</a>
</li>
<li class="nav-item">
<a class="nav-link" href="budgets.php">Budgets</a>
</li>
<li class="nav-item">
<a class="nav-link" href="goals.php">Goals</a>
</li>
<li class="nav-item">
<a class="nav-link" href="savings_investments.php">Savings & Investments</a>
</li>
<li class="nav-item">
<a class="nav-link" href="debts.php">Debts</a>
</li>
<li class="nav-item">
<a class="nav-link" href="notifications.php">Notifications</a>
</li>
<li class="nav-item">
<a class="nav-link" href="login.php">Login</a>
</li>
<li class="nav-item">
<a class="nav-link" href="register.php">Register</a>
</li>
</ul>
</div>
</div>
</nav>
<main class="my-4">
Footer (includes/footer.php)
</main>
<footer class="text-center my-4">
<p>© 2023 Personal Finance Manager. All rights reserved.</p>
</footer>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
4. PHP Code for User Authentication
Registration (public/register.php)
<?php
require '../config/db.php';
require '../includes/header.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$username = $_POST['username'];
$email = $_POST['email'];
$password = password_hash($_POST['password'], PASSWORD_DEFAULT);
$stmt = $conn->prepare("INSERT INTO users (username, email, password) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $username, $email, $password);
$stmt->execute();
$stmt->close();
header("Location: login.php");
}
?>
<form method="POST" action="">
<div class="mb-3">
<label for="username" class="form-label">Username</label>
<input type="text" class="form-control" id="username" name="username" required>
</div>
<div class="mb-3">
<label for="email" class="form-label">Email</label>
<input type="email" class="form-control" id="email" name="email" required>
</div>
<div class="mb-3">
<label for="password" class="form-label">Password</label>
<input type="password" class="form-control" id="password" name="password" required>
</div>
<button type="submit" class="btn btn-primary">Register</button>
</form>
<?php require '../includes/footer.php'; ?>
Login (public/login.php)
<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$username = $_POST['username'];
$password = $_POST['password'];
$stmt = $conn->prepare("SELECT * FROM users WHERE username = ?");
$stmt->bind_param("s", $username);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
if ($user && password_verify($password, $user['password'])) {
$_SESSION['user_id'] = $user['id'];
header("Location: dashboard.php");
} else {
echo "Invalid credentials.";
}
}
?>
<form method="POST" action="">
<div class="mb-3">
<label for="username" class="form-label">Username</label>
<input type="text" class="form-control" id="username" name="username" required>
</div>
<div class="mb-3">
<label for="password" class="form-label">Password</label>
<input type="password" class="form-control" id="password" name="password" required>
</div>
<button type="submit" class="btn btn-primary">Login</button>
</form>
<?php require '../includes/footer.php'; ?>
5. Additional PHP Scripts
Dashboard (public/dashboard.php)
<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
header("Location: login.php");
exit();
}
$user_id = $_SESSION['user_id'];
$stmt = $conn->prepare("SELECT * FROM users WHERE id = ?");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
?>
<h2>Welcome, <?php echo $user['username']; ?></h2>
<p>Your role: <?php echo ucfirst($user['role']); ?></p>
<?php require '../includes/footer.php'; ?>
Account Management (public/accounts.php)
<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
header("Location: login.php");
exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$account_name = $_POST['account_name'];
$account_type = $_POST['account_type'];
$balance = $_POST['balance'];
$stmt = $conn->prepare("INSERT INTO accounts (user_id, account_name, account_type, balance) VALUES (?, ?, ?, ?)");
$stmt->bind_param("issd", $_SESSION['user_id'], $account_name, $account_type, $balance);
$stmt->execute();
$stmt->close();
header("Location: accounts.php");
}
?>
<h2>Manage Accounts</h2>
<form method="POST" action="">
<div class="mb-3">
<label for="account_name" class="form-label">Account Name</label>
<input type="text" class="form-control" id="account_name" name="account_name" required>
</div>
<div class="mb-3">
<label for="account_type" class="form-label">Account Type</label>
<select class="form-select" id="account_type" name="account_type" required>
<option value="bank">Bank</option>
<option value="credit_card">Credit Card</option>
<option value="investment">Investment</option>
</select>
</div>
<div class="mb-3">
<label for="balance" class="form-label">Balance</label>
<input type="number" class="form-control" id="balance" name="balance" required>
</div>
<button type="submit" class="btn btn-primary">Add Account</button>
</form>
<?php require '../includes/footer.php'; ?>
Transaction Management (public/transactions.php)
<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
header("Location: login.php");
exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$account_id = $_POST['account_id'];
$transaction_date = $_POST['transaction_date'];
$amount = $_POST['amount'];
$category = $_POST['category'];
$description = $_POST['description'];
$type = $_POST['type'];
$stmt = $conn->prepare("INSERT INTO transactions (account_id, transaction_date, amount, category, description, type) VALUES (?, ?, ?, ?, ?, ?)");
$stmt->bind_param("isssss", $account_id, $transaction_date, $amount, $category, $description, $type);
$stmt->execute();
$stmt->close();
header("Location: transactions.php");
}
// Fetch accounts for the form
$stmt = $conn->prepare("SELECT * FROM accounts WHERE user_id = ?");
$stmt->bind_param("i", $_SESSION['user_id']);
$stmt->execute();
$result = $stmt->get_result();
$accounts = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Manage Transactions</h2>
<form method="POST" action="">
<div class="mb-3">
<label for="account_id" class="form-label">Select Account</label>
<select class="form-select" id="account_id" name="account_id" required>
<?php foreach ($accounts as $account): ?>
<option value="<?php echo $account['id']; ?>"><?php echo $account['account_name']; ?></option>
<?php endforeach; ?>
</select>
</div>
<div class="mb-3">
<label for="transaction_date" class="form-label">Transaction Date</label>
<input type="date" class="form-control" id="transaction_date" name="transaction_date" required>
</div>
<div class="mb-3">
<label for="amount" class="form-label">Amount</label>
<input type="number" class="form-control" id="amount" name="amount" required>
</div>
<div class="mb-3">
<label for="category" class="form-label">Category</label>
<input type="text" class="form-control" id="category" name="category" required>
</div>
<div class="mb-3">
<label for="description" class="form-label">Description</label>
<textarea class="form-control" id="description" name="description"></textarea>
</div>
<div class="mb-3">
<label for="type" class="form-label">Type</label>
<select class="form-select" id="type" name="type" required>
<option value="income">Income</option>
<option value="expense">Expense</option>
</select>
</div>
<button type="submit" class="btn btn-primary">Add Transaction</button>
</form>
<?php require '../includes/footer.php'; ?>
Reporting Module (public/reports.php)
<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
header("Location: login.php");
exit();
}
// Fetch transactions for reporting
$stmt = $conn->prepare("SELECT * FROM transactions WHERE account_id IN (SELECT id FROM accounts WHERE user_id = ?)");
$stmt->bind_param("i", $_SESSION['user_id']);
$stmt->execute();
$result = $stmt->get_result();
$transactions = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Transaction Reports</h2>
<table class="table">
<thead>
<tr>
<th>ID</th>
<th>Account ID</th>
<th>Date</th>
<th>Amount</th>
<th>Category</th>
<th>Description</th>
<th>Type</th>
</tr>
</thead>
<tbody>
<?php foreach ($transactions as $transaction): ?>
<tr>
<td><?php echo $transaction['id']; ?></td>
<td><?php echo $transaction['account_id']; ?></td>
<td><?php echo $transaction['transaction_date']; ?></td>
<td><?php echo $transaction['amount']; ?></td>
<td><?php echo $transaction['category']; ?></td>
<td><?php echo $transaction['description']; ?></td>
<td><?php echo ucfirst($transaction['type']); ?></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
<?php require '../includes/footer.php'; ?>
6. Additional Features to Consider
User Profiles: Allow users to edit their profiles and manage their settings.
Advanced Reporting: Implement more sophisticated reporting features for better insights.
Mobile Responsiveness: Ensure the application is fully responsive for mobile users.
7. Security Measures
Input Validation: Ensure all user inputs are validated to prevent SQL injection and XSS attacks.
Password Security: Use strong hashing algorithms for storing passwords.
Session Security: Implement secure session management practices to protect user sessions.
8. Testing and Deployment
Unit Testing: Conduct unit tests for individual components to ensure they function correctly.
Integration Testing: Test the integration of different modules to ensure they work together seamlessly.
Deployment: Choose a reliable hosting provider and deploy the application, ensuring all configurations are optimized for performance.
9. Documentation
User Documentation: Create a user manual to guide users through the platform's features and functionalities.
Developer Documentation: Document the codebase and architecture for future reference and maintenance.
10. Future Enhancements
AI-Powered Insights: Implement machine learning algorithms to provide insights into spending habits and financial trends.
Mobile Application: Develop a mobile application for users to access the platform on the go.
Integration with Other Systems: Consider integrating with existing banking or financial systems for a more comprehensive solution.
This structured approach will help you build a comprehensive Personal Finance Manager that meets user needs and adapts to future requirements.
AI 
ASP.NET API 
ASP.NET CLI 
ASP.NET Core 
ASP.NET MVC 
ASP.NET Projects With Source Code 
ASP.NET Web Forms 
ASP.NET Web Pages 
AWS 
Angular 10 
Bash 
Bitcoin 
Blockchain 
C Tutorial 
C# 
CPP 
Chat GPT 
Cheat Sheet 
Cyber Security 
Dart 
Django 
Docker 
Ether.js 
Ethereum 
Flask 
Flask Projects With Source Code 
GEN AI 
Git 
Go Language 
Google Cloud Platform 
GraphQL 
Hardhat 
INI 
JSON 
Java 
JavaScript 
Kotlin 
Kubernetes 
LaTeX 
Laravel 
Laravel 10 E-Commerce Project 
Laravel 11 E-Commerce Project 
Laravel 9 E-Commerce Project 
Laravel 9 React Tutorial 
Laravel E-Commerce Project 
Laravel Home Services Project 
Laravel Projects With Source Code 
Laravel Tutorial Advanced 
Laravel Tutorial Beginners 
Livewire 
Markdown 
Matlab 
Metamask 
Microsoft Azure 
MongoDB Tutorial Advanced 
MongoDB Tutorial Beginners 
MySql Tutorial Advanced 
MySql Tutorial Beginners 
NextJS 
Node JS 
Node JS Projects With Source Code 
PHP Projects With Source Code 
PHP Tutorial Advanced 
PHP Tutorial Beginners 
Project Database Schema 
Python 
React JS 
Ruby 
Rust 
SQL Server Queries 
SQL Server Tutorial Advanced 
SQL Server Tutorial Beginners 
Sass 
Solidity 
Spring Boot 
Truffle 
TypeScript 
VueJS 
Web3.js 
WordPress Tutorial Advanced 
WordPress Tutorial Beginners 
YAML