# dhruvgiri2110-boop/php-mysql-crud architecture

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

- Interactive diagram: https://gitdiagram.com/dhruvgiri2110-boop/php-mysql-crud
- Repository: https://github.com/dhruvgiri2110-boop/php-mysql-crud

## Overview

This is a small PHP/MySQL client-management app. Users view a client list, open a form to add or edit a client, or delete a client; successful changes return to the list. The PHP pages handle both presentation and database queries directly, with MySQL as the persistent store. The README also identifies Bootstrap and a client database schema. The schema file is present but its contents were not sampled, so its relationship to the store is not verified.

Main entry points: [`index.php`](https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/index.php) (Client list), [`create.php`](https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/create.php) (Add client), [`edit.php`](https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/edit.php) (Edit client), [`delete.php`](https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/delete.php) (Delete client)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_pages["Client pages"]
  node_list["Client list<br/>[index.php]"]
  node_create["Add client<br/>[create.php]"]
  node_edit["Edit client<br/>[edit.php]"]
  node_delete["Delete client<br/>[delete.php]"]
end

subgraph group_data["Client data"]
  node_schema["Client schema<br/>[myshop.sql]"]
  node_mysql[("MySQL store")]
end

node_user(("User"))
node_bootstrap["Bootstrap CDN"]

node_user -->|"opens"| node_list
node_list -->|"links to"| node_create
node_list -->|"links to"| node_edit
node_list -->|"links to"| node_delete
node_list -->|"reads clients"| node_mysql
node_list -->|"resets ID"| node_mysql
node_create -->|"inserts client"| node_mysql
node_create -->|"redirects to"| node_list
node_edit -->|"reads and updates"| node_mysql
node_edit -->|"redirects to"| node_list
node_delete -->|"deletes client"| node_mysql
node_delete -->|"redirects to"| node_list
node_schema -.->|"defines clients"| node_mysql
node_list -->|"loads styles"| node_bootstrap
node_create -->|"loads assets"| node_bootstrap
node_edit -->|"loads assets"| node_bootstrap

click node_list "https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/index.php"
click node_create "https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/create.php"
click node_edit "https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/edit.php"
click node_delete "https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/delete.php"
click node_schema "https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/myshop.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_list,node_create,node_edit,node_delete,node_user toneBlue
class node_schema,node_mysql toneAmber
class node_bootstrap toneIndigo
```

## Components

### Client pages

- [Client list](https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/index.php): `index.php`
- [Add client](https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/create.php): `create.php`
- [Edit client](https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/edit.php): `edit.php`
- [Delete client](https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/delete.php): `delete.php`

### Client data

- [Client schema](https://github.com/dhruvgiri2110-boop/php-mysql-crud/blob/main/myshop.sql): `myshop.sql`
- **MySQL store**

### Other components

- **User**
- **Bootstrap CDN**

## Connections

- User → Client list: opens (evidence: `README.md`)
- Client list → Add client: links to (evidence: `index.php`)
- Client list → Edit client: links to (evidence: `index.php`)
- Client list → Delete client: links to (evidence: `index.php`)
- Client list → MySQL store: reads clients (evidence: `index.php`)
- Client list → MySQL store: resets ID (evidence: `index.php`)
- Add client → MySQL store: inserts client (evidence: `create.php`)
- Add client → Client list: redirects to (evidence: `create.php`)
- Edit client → MySQL store: reads and updates (evidence: `edit.php`)
- Edit client → Client list: redirects to (evidence: `edit.php`)
- Delete client → MySQL store: deletes client (evidence: `delete.php`)
- Delete client → Client list: redirects to (evidence: `delete.php`)
- Client schema → MySQL store: defines clients
- Client list → Bootstrap CDN: loads styles (evidence: `index.php`)
- Add client → Bootstrap CDN: loads assets (evidence: `create.php`)
- Edit client → Bootstrap CDN: loads assets (evidence: `edit.php`)
