40e3f73aaf
- contact.php now inserts submissions into MySQL via PDO prepared statements; raw values stored (htmlspecialchars moved to output only) - www/includes/db.php: shared PDO helper with auto-migration that adds the is_read column to existing deployments without a full DB reset - docker/mysql/init.sql: added is_read TINYINT column to contacts table for fresh deploys - www/pages/admin-inbox.php: self-contained staff inbox at /staff-portal with session-based password login, per-message mark-as-read, and mark-all-read; unread count shown in browser tab title - index.php: routes /staff-portal before public header/footer so the admin page is fully standalone - docker-compose.yml: ADMIN_PASS env var wired to web container Set ADMIN_PASS in .env (gitignored) before deploying. If the DB volume already exists, the auto-migration in db.php will add the is_read column automatically on first request. https://claude.ai/code/session_015wpwmheufcxkBuXivrSHhd
66 lines
1.3 KiB
YAML
66 lines
1.3 KiB
YAML
version: '3.9'
|
|
|
|
services:
|
|
web:
|
|
build:
|
|
context: .
|
|
dockerfile: Dockerfile
|
|
container_name: alwisp_web
|
|
ports:
|
|
- "80:80"
|
|
- "443:443"
|
|
volumes:
|
|
- ./www:/var/www/html
|
|
- ./docker/apache/000-default.conf:/etc/apache2/sites-available/000-default.conf
|
|
- ./docker/apache/ssl:/etc/apache2/ssl
|
|
environment:
|
|
- DB_HOST=db
|
|
- DB_NAME=${DB_NAME}
|
|
- DB_USER=${DB_USER}
|
|
- DB_PASS=${DB_PASS}
|
|
- ADMIN_PASS=${ADMIN_PASS}
|
|
depends_on:
|
|
- db
|
|
networks:
|
|
- alwisp_net
|
|
restart: unless-stopped
|
|
|
|
db:
|
|
image: mysql:8.0
|
|
container_name: alwisp_db
|
|
environment:
|
|
MYSQL_ROOT_PASSWORD: ${DB_ROOT_PASS}
|
|
MYSQL_DATABASE: ${DB_NAME}
|
|
MYSQL_USER: ${DB_USER}
|
|
MYSQL_PASSWORD: ${DB_PASS}
|
|
volumes:
|
|
- db_data:/var/lib/mysql
|
|
- ./docker/mysql/init.sql:/docker-entrypoint-initdb.d/init.sql
|
|
networks:
|
|
- alwisp_net
|
|
restart: unless-stopped
|
|
|
|
phpmyadmin:
|
|
image: phpmyadmin:latest
|
|
container_name: alwisp_pma
|
|
ports:
|
|
- "8080:80"
|
|
environment:
|
|
PMA_HOST: db
|
|
PMA_USER: ${DB_USER}
|
|
PMA_PASSWORD: ${DB_PASS}
|
|
depends_on:
|
|
- db
|
|
networks:
|
|
- alwisp_net
|
|
restart: unless-stopped
|
|
profiles:
|
|
- tools
|
|
|
|
volumes:
|
|
db_data:
|
|
|
|
networks:
|
|
alwisp_net:
|
|
driver: bridge
|