# tsinho/tpbs architecture

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

- Interactive diagram: https://gitdiagram.com/tsinho/tpbs
- Repository: https://github.com/tsinho/tpbs

## Overview

TPBS is a PHP/MySQL personal blog with a public profile, article, donation, and guestbook experience, plus an authenticated administration area. Visitors browse content and can submit comments or messages; administrators manage posts, comments, messages, uploads, and site settings. The database connection is a shared runtime layer, with MySQL schema supplied by tpbs.sql. The index confirms several admin page dependencies, but most admin implementations and some public handlers were not excerpted, so their internal calls are not expanded.

Main entry points: [`config/database.php`](https://github.com/tsinho/tpbs/blob/main/config/database.php) (Database connection), [`admin/head.php`](https://github.com/tsinho/tpbs/blob/main/admin/head.php) (Admin session gate), [`index.php`](https://github.com/tsinho/tpbs/blob/main/index.php) (Profile home), [`page/blog/index.php`](https://github.com/tsinho/tpbs/blob/main/page/blog/index.php) (Article listing)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_public["Public site"]
  node_home["Profile home<br/>[index.php]"]
  node_bloglist["Article listing<br/>[index.php]"]
  node_article["Article and comments<br/>[post.php]"]
  node_comment_submit["Comment submission<br/>[submit.php]"]
  node_message_list["Guestbook listing<br/>[index.php]"]
  node_message_submit["Guestbook submission<br/>[post.php]"]
  node_donation["Donation page<br/>[index.php]"]
end

subgraph group_admin["Administration"]
  node_admin_login["Admin login<br/>[login.php]"]
  node_admin_auth["Admin session gate<br/>[head.php]"]
  node_dashboard["Dashboard<br/>[index.php]"]
  node_post_admin["Post management<br/>[posts.php]"]
  node_post_edit["Post editor<br/>[post_edit.php]"]
  node_comment_admin["Comment moderation<br/>[comments.php]"]
  node_message_admin["Message moderation<br/>[message.php]"]
  node_image_admin["Image upload<br/>[image.php]"]
  node_settings["Site settings<br/>[config.php]"]
  node_admin_demo["Demo management<br/>[demo.php]"]
  node_upload_handler["Upload handler<br/>[upload.php]"]
end

subgraph group_shared["Shared runtime"]
  node_database_config["Database connection<br/>[database.php]"]
  node_site_nav["Site navigation<br/>[nav.php]"]
  node_site_footer["Site footer<br/>[footer.php]"]
  node_carousel["Article carousel<br/>[lbt.php]"]
end

subgraph group_data["Persistence"]
  node_database[("MySQL data<br/>[tpbs.sql]")]
end

node_visitor(("Visitor"))
node_administrator(("Administrator"))

node_visitor -->|"opens"| node_home
node_visitor -->|"browses"| node_bloglist
node_visitor -->|"opens article"| node_article
node_visitor -->|"reads messages"| node_message_list
node_visitor -->|"submits message"| node_message_submit
node_visitor -->|"views payment options"| node_donation
node_article -->|"posts comment"| node_comment_submit
node_administrator -->|"signs in"| node_admin_login
node_admin_login -->|"loads connection"| node_database_config
node_admin_auth -->|"loads connection"| node_database_config
node_dashboard -->|"includes header"| node_admin_auth
node_dashboard -.->|"counts records"| node_database
node_post_admin -->|"includes header"| node_admin_auth
node_post_edit -->|"includes header"| node_admin_auth
node_comment_admin -->|"includes header"| node_admin_auth
node_message_admin -->|"includes header"| node_admin_auth
node_image_admin -->|"includes header"| node_admin_auth
node_settings -->|"includes header"| node_admin_auth
node_admin_demo -->|"includes header"| node_admin_auth
node_upload_handler -->|"loads connection"| node_database_config
node_home -->|"loads connection"| node_database_config
node_home -->|"includes navigation"| node_site_nav
node_home -->|"includes footer"| node_site_footer
node_home -->|"reads profile"| node_database_config
node_bloglist -->|"includes navigation"| node_site_nav
node_bloglist -->|"includes carousel"| node_carousel
node_bloglist -->|"loads connection"| node_database_config
node_bloglist -->|"includes footer"| node_site_footer
node_article -->|"loads connection"| node_database_config
node_article -->|"includes navigation"| node_site_nav
node_article -->|"includes footer"| node_site_footer
node_message_list -->|"loads connection"| node_database_config
node_message_list -->|"includes navigation"| node_site_nav
node_message_list -->|"includes footer"| node_site_footer
node_message_submit -->|"loads connection"| node_database_config
node_donation -->|"loads connection"| node_database_config
node_donation -->|"includes navigation"| node_site_nav
node_donation -->|"includes footer"| node_site_footer
node_database_config -.->|"connects to"| node_database

click node_home "https://github.com/tsinho/tpbs/blob/main/index.php"
click node_bloglist "https://github.com/tsinho/tpbs/blob/main/page/blog/index.php"
click node_article "https://github.com/tsinho/tpbs/blob/main/page/blog/post.php"
click node_comment_submit "https://github.com/tsinho/tpbs/blob/main/page/blog/submit.php"
click node_message_list "https://github.com/tsinho/tpbs/blob/main/page/message/index.php"
click node_message_submit "https://github.com/tsinho/tpbs/blob/main/page/message/post.php"
click node_donation "https://github.com/tsinho/tpbs/blob/main/page/donate/index.php"
click node_admin_login "https://github.com/tsinho/tpbs/blob/main/admin/login.php"
click node_admin_auth "https://github.com/tsinho/tpbs/blob/main/admin/head.php"
click node_dashboard "https://github.com/tsinho/tpbs/blob/main/admin/index.php"
click node_post_admin "https://github.com/tsinho/tpbs/blob/main/admin/posts.php"
click node_post_edit "https://github.com/tsinho/tpbs/blob/main/admin/post_edit.php"
click node_comment_admin "https://github.com/tsinho/tpbs/blob/main/admin/comments.php"
click node_message_admin "https://github.com/tsinho/tpbs/blob/main/admin/message.php"
click node_image_admin "https://github.com/tsinho/tpbs/blob/main/admin/image.php"
click node_settings "https://github.com/tsinho/tpbs/blob/main/admin/config.php"
click node_admin_demo "https://github.com/tsinho/tpbs/blob/main/admin/demo.php"
click node_upload_handler "https://github.com/tsinho/tpbs/blob/main/admin/upload.php"
click node_database_config "https://github.com/tsinho/tpbs/blob/main/config/database.php"
click node_site_nav "https://github.com/tsinho/tpbs/blob/main/includes/nav.php"
click node_site_footer "https://github.com/tsinho/tpbs/blob/main/includes/footer.php"
click node_carousel "https://github.com/tsinho/tpbs/blob/main/includes/lbt.php"
click node_database "https://github.com/tsinho/tpbs/blob/main/tpbs.sql"

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_home,node_bloglist,node_article,node_comment_submit,node_message_list,node_message_submit,node_donation toneBlue
class node_admin_login,node_admin_auth,node_dashboard,node_post_admin,node_post_edit,node_comment_admin,node_message_admin,node_image_admin,node_settings,node_admin_demo,node_upload_handler toneAmber
class node_database_config,node_site_nav,node_site_footer,node_carousel toneMint
class node_database toneRose
class node_visitor,node_administrator toneIndigo
```

## Components

### Public site

- [Profile home](https://github.com/tsinho/tpbs/blob/main/index.php): `index.php`
- [Article listing](https://github.com/tsinho/tpbs/blob/main/page/blog/index.php): `page/blog/index.php`
- [Article and comments](https://github.com/tsinho/tpbs/blob/main/page/blog/post.php): `page/blog/post.php`
- [Comment submission](https://github.com/tsinho/tpbs/blob/main/page/blog/submit.php): `page/blog/submit.php`
- [Guestbook listing](https://github.com/tsinho/tpbs/blob/main/page/message/index.php): `page/message/index.php`
- [Guestbook submission](https://github.com/tsinho/tpbs/blob/main/page/message/post.php): `page/message/post.php`
- [Donation page](https://github.com/tsinho/tpbs/blob/main/page/donate/index.php): `page/donate/index.php`

### Administration

- [Admin login](https://github.com/tsinho/tpbs/blob/main/admin/login.php): `admin/login.php`
- [Admin session gate](https://github.com/tsinho/tpbs/blob/main/admin/head.php): `admin/head.php`
- [Dashboard](https://github.com/tsinho/tpbs/blob/main/admin/index.php): `admin/index.php`
- [Post management](https://github.com/tsinho/tpbs/blob/main/admin/posts.php): `admin/posts.php`
- [Post editor](https://github.com/tsinho/tpbs/blob/main/admin/post_edit.php): `admin/post_edit.php`
- [Comment moderation](https://github.com/tsinho/tpbs/blob/main/admin/comments.php): `admin/comments.php`
- [Message moderation](https://github.com/tsinho/tpbs/blob/main/admin/message.php): `admin/message.php`
- [Image upload](https://github.com/tsinho/tpbs/blob/main/admin/image.php): `admin/image.php`
- [Site settings](https://github.com/tsinho/tpbs/blob/main/admin/config.php): `admin/config.php`
- [Demo management](https://github.com/tsinho/tpbs/blob/main/admin/demo.php): `admin/demo.php`
- [Upload handler](https://github.com/tsinho/tpbs/blob/main/admin/upload.php): `admin/upload.php`

### Shared runtime

- [Database connection](https://github.com/tsinho/tpbs/blob/main/config/database.php): `config/database.php`
- [Site navigation](https://github.com/tsinho/tpbs/blob/main/includes/nav.php): `includes/nav.php`
- [Site footer](https://github.com/tsinho/tpbs/blob/main/includes/footer.php): `includes/footer.php`
- [Article carousel](https://github.com/tsinho/tpbs/blob/main/includes/lbt.php): `includes/lbt.php`

### Persistence

- [MySQL data](https://github.com/tsinho/tpbs/blob/main/tpbs.sql): `tpbs.sql`

### Other components

- **Visitor**
- **Administrator**

## Connections

- Visitor → Profile home: opens (evidence: `index.php`)
- Visitor → Article listing: browses (evidence: `page/blog/index.php`)
- Visitor → Article and comments: opens article
- Visitor → Guestbook listing: reads messages (evidence: `page/message/index.php`)
- Visitor → Guestbook submission: submits message (evidence: `page/message/post.php`)
- Visitor → Donation page: views payment options (evidence: `page/donate/index.php`)
- Article and comments → Comment submission: posts comment (evidence: `page/blog/post.php`)
- Administrator → Admin login: signs in (evidence: `README.md`)
- Admin login → Database connection: loads connection (evidence: `admin/login.php`)
- Admin session gate → Database connection: loads connection (evidence: `admin/head.php`)
- Dashboard → Admin session gate: includes header (evidence: `admin/index.php`)
- Dashboard → MySQL data: counts records
- Post management → Admin session gate: includes header (evidence: `admin/posts.php`)
- Post editor → Admin session gate: includes header (evidence: `admin/post_edit.php`)
- Comment moderation → Admin session gate: includes header (evidence: `admin/comments.php`)
- Message moderation → Admin session gate: includes header (evidence: `admin/message.php`)
- Image upload → Admin session gate: includes header (evidence: `admin/image.php`)
- Site settings → Admin session gate: includes header (evidence: `admin/config.php`)
- Demo management → Admin session gate: includes header (evidence: `admin/demo.php`)
- Upload handler → Database connection: loads connection (evidence: `admin/upload.php`)
- Profile home → Database connection: loads connection (evidence: `index.php`)
- Profile home → Site navigation: includes navigation (evidence: `index.php`)
- Profile home → Site footer: includes footer (evidence: `index.php`)
- Profile home → Database connection: reads profile (evidence: `index.php`)
- Article listing → Site navigation: includes navigation (evidence: `page/blog/index.php`)
- Article listing → Article carousel: includes carousel (evidence: `page/blog/index.php`)
- Article listing → Database connection: loads connection (evidence: `page/blog/index.php`)
- Article listing → Site footer: includes footer (evidence: `page/blog/index.php`)
- Article and comments → Database connection: loads connection (evidence: `page/blog/post.php`)
- Article and comments → Site navigation: includes navigation (evidence: `page/blog/post.php`)
- Article and comments → Site footer: includes footer (evidence: `page/blog/post.php`)
- Guestbook listing → Database connection: loads connection (evidence: `page/message/index.php`)
- Guestbook listing → Site navigation: includes navigation (evidence: `page/message/index.php`)
- Guestbook listing → Site footer: includes footer (evidence: `page/message/index.php`)
- Guestbook submission → Database connection: loads connection (evidence: `page/message/post.php`)
- Donation page → Database connection: loads connection (evidence: `page/donate/index.php`)
- Donation page → Site navigation: includes navigation (evidence: `page/donate/index.php`)
- Donation page → Site footer: includes footer (evidence: `page/donate/index.php`)
- Database connection → MySQL data: connects to
