How dec-olgen/website works
employeedb is a PHP employee and department management application. Users enter through the dashboard and sidebar, then view/search records or follow separate insert, update, and delete flows; successful mutations return to a confirmation page. Reporting pages present aggregate and relationship queries, while the query runner exposes a numbered SQL exercise registry whose mutations affect the live database. The sampled pages connect directly to a shared PDO setup. The README provides no capability details, and some chooser and report implementations were not sampled, so their internal wiring is shown only where supported by the tree and navigation.
Main entry points: db.php PDO connection · sidebar.php Sidebar navigation · select_update.php Find update record · success.php Mutation status
Components 19
Navigation
- Dashboard
index.php - Sidebar navigation
includes/sidebar.php
Record management
- Choose insert type
pages/choose_insert.php - Insert records
pages/insert.php - Choose update type
pages/choose_update.php - Find update record
pages/select_update.php - Update employee
pages/update.php - Update department
pages/update_department.php - Choose delete type
pages/choose_delete.php - Find delete record
pages/select_delete.php - Confirm and delete
pages/delete.php - View and search
pages/view.php - Mutation status
pages/success.php
Reports and queries
- Reports
pages/reports.php - Query runner
pages/queries.php - Query registry
includes/query_functions.php
Persistence
- PDO connection
includes/db.php - MySQL database
Other components
- User
Connections 32
- User → Dashboard: opens
- Dashboard → Sidebar navigation: includes
- User → Sidebar navigation: navigates
- Sidebar navigation → Choose insert type: links
- Sidebar navigation → Choose update type: links
- Sidebar navigation → Choose delete type: links
- Sidebar navigation → View and search: links
- Sidebar navigation → Reports: links
- Sidebar navigation → Query runner: links
- Choose insert type → Insert records: routes
- Choose update type → Find update record: routes
- Find update record → Update employee: selects employee
- Find update record → Update department: selects department
- Choose delete type → Find delete record: routes
- Find delete record → Confirm and delete: selects record
- Insert records → PDO connection: uses
- Update employee → PDO connection: uses
- Update department → PDO connection: uses
- Find update record → PDO connection: queries
- Find delete record → PDO connection: queries
- Confirm and delete → PDO connection: uses
- View and search → PDO connection: queries
- Reports → PDO connection: queries
- Query runner → Query registry: dispatches
- Query runner → PDO connection: provides connection
- Query registry → PDO connection: runs SQL
- Dashboard → PDO connection: counts records
- PDO connection → MySQL database: reads and writes
- Insert records → Mutation status: redirects after save
- Update employee → Mutation status: redirects after save
- Update department → Mutation status: redirects after save
- Confirm and delete → Mutation status: redirects after delete