# bitwheeler7/expense_tracker architecture

> Architecture diagram of the GitHub repository bitwheeler7/expense_tracker, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-06). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/bitwheeler7/expense_tracker
- Repository: https://github.com/bitwheeler7/expense_tracker

## Overview

This is a small PHP expense tracker: users register or log in, then view income and expense transactions, add entries, and delete them. The dashboard computes totals from the user’s transactions; PHP pages use a shared MySQL connection, session state, and shared page chrome. The graph follows references visible in the excerpts; the JavaScript and CSS contents were not sampled, so no behavior is attributed to them.

Main entry points: [`index.php`](https://github.com/bitwheeler7/expense_tracker/blob/main/index.php) (Dashboard), [`login.php`](https://github.com/bitwheeler7/expense_tracker/blob/main/login.php) (Login), [`db.php`](https://github.com/bitwheeler7/expense_tracker/blob/main/db.php) (MySQL connection and session), [`add.php`](https://github.com/bitwheeler7/expense_tracker/blob/main/add.php) (Add transaction)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_accounts["Account access"]
  node_register["Register<br/>[register.php]"]
  node_login["Login<br/>[login.php]"]
  node_logout["Logout<br/>[logout.php]"]
end

subgraph group_transactions["Transaction workflow"]
  node_dashboard["Dashboard<br/>[index.php]"]
  node_add["Add transaction<br/>[add.php]"]
  node_delete["Delete transaction<br/>[delete.php]"]
end

subgraph group_shared["Shared presentation"]
  node_header["Page header<br/>[header.php]"]
  node_sidebar["Navigation sidebar<br/>[sidebar.php]"]
  node_footer["Page footer<br/>[footer.php]"]
  node_styles["Stylesheet<br/>[style.css]"]
end

subgraph group_persistence["Persistence"]
  node_connection["MySQL connection and session<br/>[db.php]"]
  node_database[("MySQL database")]
end

node_user(("User"))

node_user -->|"registers"| node_register
node_user -->|"signs in"| node_login
node_user -->|"views"| node_dashboard
node_register -->|"loads"| node_connection
node_register -->|"inserts account"| node_database
node_register -->|"redirects"| node_login
node_login -->|"loads"| node_connection
node_login -->|"checks account"| node_database
node_login -->|"redirects"| node_dashboard
node_user -->|"signs out"| node_logout
node_logout -->|"redirects"| node_login
node_dashboard -->|"loads"| node_connection
node_dashboard -->|"reads transactions"| node_database
node_dashboard -->|"submits entry"| node_add
node_dashboard -->|"links deletion"| node_delete
node_dashboard -->|"includes"| node_header
node_dashboard -->|"includes"| node_footer
node_add -->|"loads"| node_connection
node_add -->|"inserts transaction"| node_database
node_add -->|"redirects"| node_dashboard
node_delete -->|"loads"| node_connection
node_delete -->|"deletes transaction"| node_database
node_delete -->|"redirects"| node_dashboard
node_header -->|"includes"| node_sidebar
node_header -->|"loads stylesheet"| node_styles
node_sidebar -->|"links dashboard"| node_dashboard
node_sidebar -->|"links entry"| node_add
node_connection -->|"connects"| node_database

click node_register "https://github.com/bitwheeler7/expense_tracker/blob/main/register.php"
click node_login "https://github.com/bitwheeler7/expense_tracker/blob/main/login.php"
click node_logout "https://github.com/bitwheeler7/expense_tracker/blob/main/logout.php"
click node_dashboard "https://github.com/bitwheeler7/expense_tracker/blob/main/index.php"
click node_add "https://github.com/bitwheeler7/expense_tracker/blob/main/add.php"
click node_delete "https://github.com/bitwheeler7/expense_tracker/blob/main/delete.php"
click node_header "https://github.com/bitwheeler7/expense_tracker/blob/main/includes/header.php"
click node_sidebar "https://github.com/bitwheeler7/expense_tracker/blob/main/includes/sidebar.php"
click node_footer "https://github.com/bitwheeler7/expense_tracker/blob/main/includes/footer.php"
click node_styles "https://github.com/bitwheeler7/expense_tracker/blob/main/assets/css/style.css"
click node_connection "https://github.com/bitwheeler7/expense_tracker/blob/main/db.php"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_register,node_login,node_logout,node_user toneBlue
class node_dashboard,node_add,node_delete toneAmber
class node_header,node_sidebar,node_footer,node_styles toneMint
class node_connection,node_database toneRose
```

## Components

### Account access

- [Register](https://github.com/bitwheeler7/expense_tracker/blob/main/register.php): `register.php`
- [Login](https://github.com/bitwheeler7/expense_tracker/blob/main/login.php): `login.php`
- [Logout](https://github.com/bitwheeler7/expense_tracker/blob/main/logout.php): `logout.php`

### Transaction workflow

- [Dashboard](https://github.com/bitwheeler7/expense_tracker/blob/main/index.php): `index.php`
- [Add transaction](https://github.com/bitwheeler7/expense_tracker/blob/main/add.php): `add.php`
- [Delete transaction](https://github.com/bitwheeler7/expense_tracker/blob/main/delete.php): `delete.php`

### Shared presentation

- [Page header](https://github.com/bitwheeler7/expense_tracker/blob/main/includes/header.php): `includes/header.php`
- [Navigation sidebar](https://github.com/bitwheeler7/expense_tracker/blob/main/includes/sidebar.php): `includes/sidebar.php`
- [Page footer](https://github.com/bitwheeler7/expense_tracker/blob/main/includes/footer.php): `includes/footer.php`
- [Stylesheet](https://github.com/bitwheeler7/expense_tracker/blob/main/assets/css/style.css): `assets/css/style.css`

### Persistence

- [MySQL connection and session](https://github.com/bitwheeler7/expense_tracker/blob/main/db.php): `db.php`
- **MySQL database**

### Other components

- **User**

## Connections

- User → Register: registers (evidence: `register.php`)
- User → Login: signs in (evidence: `login.php`)
- User → Dashboard: views (evidence: `index.php`)
- Register → MySQL connection and session: loads (evidence: `register.php`)
- Register → MySQL database: inserts account (evidence: `register.php`)
- Register → Login: redirects (evidence: `register.php`)
- Login → MySQL connection and session: loads (evidence: `login.php`)
- Login → MySQL database: checks account (evidence: `login.php`)
- Login → Dashboard: redirects (evidence: `login.php`)
- User → Logout: signs out
- Logout → Login: redirects (evidence: `logout.php`)
- Dashboard → MySQL connection and session: loads (evidence: `index.php`)
- Dashboard → MySQL database: reads transactions (evidence: `index.php`)
- Dashboard → Add transaction: submits entry (evidence: `index.php`)
- Dashboard → Delete transaction: links deletion (evidence: `index.php`)
- Dashboard → Page header: includes (evidence: `index.php`)
- Dashboard → Page footer: includes (evidence: `index.php`)
- Add transaction → MySQL connection and session: loads (evidence: `add.php`)
- Add transaction → MySQL database: inserts transaction (evidence: `add.php`)
- Add transaction → Dashboard: redirects (evidence: `add.php`)
- Delete transaction → MySQL connection and session: loads (evidence: `delete.php`)
- Delete transaction → MySQL database: deletes transaction (evidence: `delete.php`)
- Delete transaction → Dashboard: redirects (evidence: `delete.php`)
- Page header → Navigation sidebar: includes (evidence: `includes/header.php`)
- Page header → Stylesheet: loads stylesheet (evidence: `includes/header.php`)
- Navigation sidebar → Dashboard: links dashboard (evidence: `includes/sidebar.php`)
- Navigation sidebar → Add transaction: links entry (evidence: `includes/sidebar.php`)
- MySQL connection and session → MySQL database: connects (evidence: `db.php`)
