How hasina-mlbb/test_db-master works
test_db is a sample employee database and a small PHP browser for department and employee records, search, and a department-change demonstration. The main workflow browses departments into employee lists and employee details; search results use session-backed pagination. The database install, alternate PostgreSQL schema, and integrity checks are documented product capabilities. PHP excerpts show the MySQL-backed UI; database SQL contents and unsampled components are not inspected, so their detailed wiring is omitted.
Main entry points: employees.sql Employees database · function.php Database query helpers · index.php Department overview · employe.php Department employees
Components 18
Employee browser
- Department overview
index.php - Department employees
employe.php - Employee profile
fiche.php - Search criteria
formulaire.php - Search results
recherche.php - Next results
prochain.php - Department change form
formulaire_changement.php - Change preview
traitement_changement.php - Database query helpers
function.php
Sample database
- Employees database
employees.sql - Partitioned variant
employees_partitioned.sql - PostgreSQL schema
postgresql/employees.sql - PostgreSQL loader
postgresql/load_employees_db.sh
Integrity checks
- SHA-256 integrity test
test_employees_sha2.sql - PostgreSQL integrity test
postgresql/test_employees_sha2.sql
Other components
- Visitor
- MySQL-compatible server
- PostgreSQL server
Connections 24
- Visitor → Department overview: opens
index.php - Department overview → Database query helpers: loads departments
index.php - Department overview → Department employees: opens department
index.php - Department employees → Employee profile: opens profile
employe.php - Department employees → Employees database: queries records
employe.php - Employee profile → Employees database: queries profile
fiche.php - Visitor → Search criteria: enters criteria
formulaire.php - Search criteria → Search results: submits criteria
formulaire.php - Search results → Database query helpers: searches employees
recherche.php - Search results → Next results: opens next page
recherche.php - Next results → Database query helpers: loads next batch
prochain.php - Employee profile → Department change form: opens change form
fiche.php - Department change form → Database query helpers: lists departments
formulaire_changement.php - Department change form → Change preview: submits change
formulaire_changement.php - Change preview → Employees database: reads employee
traitement_changement.php - Database query helpers → Employees database: queries records
function.php - MySQL-compatible server → Employees database: hosts schema
README.md - Visitor → Employees database: installs via SQL
README.md - Visitor → Partitioned variant: installs variant
README.md - Visitor → PostgreSQL loader: runs loader
README.md - PostgreSQL loader → PostgreSQL schema: loads schema
README.md - PostgreSQL server → PostgreSQL schema: hosts schema
README.md - Visitor → SHA-256 integrity test: runs checksum test
README.md - Visitor → PostgreSQL integrity test: runs checksum test
README.md