How faceincase/social-security-platform works
Social Input Platform is a PHP/SQLite community-issue reporting app with an admin oversight dashboard and a community blog. Residents submit categorized reports, optionally with images; administrators review and moderate reports, with JSON export and map/network visualizations. Users can register and log in, then publish blog updates. The sampled pages show direct page-to-SQLite access rather than a separate service layer. Some feature details and wiring are documented only in the README; unsampled implementation links are omitted unless documented.
Main entry points: reports.sqlite SQLite database · report.php Report submission · issues.php Report dashboard · debug.php Admin metrics
Components 14
Entry and accounts
- Landing page
index.php - Registration and login
login.php - Admin verification
login_admin.php - JS verification helper
verify.php
Issue reporting
- Report submission
report.php - Postcode lookup
- Report images
REPORT_IMAGES
Admin oversight
- Report dashboard
issues.php - Admin metrics
debug.php
Community blog
- Post creation
new_post.php - Community feed
blog.php
Other components
- Community user
- Administrator
- SQLite database
DATABASE/reports.sqlite
Connections 15
- Community user → Landing page: opens
README.md - Community user → Report submission: submits report
README.md - Report submission → SQLite database: stores report
report.php - Report submission → Postcode lookup: validates postcode
README.md - Report submission → Report images: saves image
report.php - Community user → Registration and login: registers or logs in
README.md - Administrator → Admin verification: verifies account
README.md - Community user → Post creation: creates post
README.md - Post creation → SQLite database: stores post
README.md - Community user → Community feed: reads updates
README.md - Community feed → SQLite database: loads and deletes posts
blog.php - Administrator → Report dashboard: reviews reports
README.md - Report dashboard → SQLite database: reads and moderates
issues.php - Administrator → Admin metrics: views metrics
debug.php - Admin metrics → SQLite database: reads account data
debug.php