OpenPsychologist

A modern, responsive psychology appointment management system built with pure PHP and SQLite3. This application enables psychologists to manage their appointment schedules while allowing patients to book appointments seamlessly.

🌟 Features

For Administrators

• Time Slot Management: Create, view, and manage available appointment slots
• Appointment Oversight: Review, approve, or cancel appointment requests
• User Management: Monitor registered users and their appointment history
• Dashboard Analytics: Quick overview of pending requests and system statistics

For Users/Patients

• Easy Registration: Simple account creation process
• Appointment Booking: Browse available time slots and book appointments instantly
• Appointment Tracking: View appointment status (pending, approved, cancelled)
• Profile Management: Update personal information and account settings

Technical Features

• Responsive Design: Modern Bootstrap 5 interface that works on all devices
• Role-Based Access: Secure admin and user role separation
• Session Management: Secure authentication and session handling
• SQLite Database: Lightweight, file-based database with automatic setup
• Docker Ready: Containerized development and deployment

🚀 Quick Start

Prerequisites

• Docker and Docker Compose v2
• Git

Installation

1. Clone the repository

   git clone <repository-url>
   cd OpenPsychologist

2. Start the application

   ./start.sh

   Or manually:

   docker compose up --build

3. Access the application

   • Open your browser and navigate to: http://localhost:8080
   • The application will be ready to use immediately

Default Admin Credentials

• Email: admin@psychologist.com
• Password: admin123

⚠️ Important: Change the default admin password after first login in a production environment.

🛠️ Technology Stack

• Backend: Pure PHP 8.2+ (no frameworks)
• Database: SQLite3 with automatic schema creation
• Frontend: Bootstrap 5.3.0 with custom CSS
• Containerization: Docker with PHP built-in server
• Development: Hot-reload capable with volume mounting

📁 Project Structure

OpenPsychologist/
├── public/                 # Web root directory
│   ├── index.php          # Application entry point
│   ├── css/               # Custom stylesheets
│   └── js/                # JavaScript files
├── src/                   # Application source code
│   ├── config/            # Configuration classes
│   │   ├── Database.php   # Database connection & schema
│   │   ├── Router.php     # URL routing system
│   │   └── Session.php    # Session management
│   ├── controllers/       # Request handlers
│   │   ├── AuthController.php
│   │   ├── AdminController.php
│   │   ├── UserController.php
│   │   └── BookingController.php
│   ├── models/            # Data models
│   │   └── User.php
│   └── views/             # HTML templates
│       ├── layout.php     # Main layout template
│       ├── admin/         # Admin-specific views
│       ├── auth/          # Authentication views
│       └── user/          # User-specific views
├── data/                  # SQLite database files
├── docker-compose.yml     # Docker configuration
├── Dockerfile            # Container definition
└── start.sh              # Quick start script

🎯 Usage Guide

For Administrators

1. Login with admin credentials
2. Manage Time Slots:
   • Navigate to Admin → Time Slots
   • Create new available appointment slots
   • Set date, time, and optional descriptions
3. Review Appointments:
   • Go to Admin → Appointments
   • Approve or cancel pending requests
   • View appointment history
4. Monitor Users:
   • Access Admin → Users
   • View registered users and their activity

For Users/Patients

1. Register a new account or Login
2. Book Appointment:
   • Click "Book Appointment" from dashboard
   • Select from available time slots
   • Submit booking request
3. Track Status:
   • View "My Appointments" for status updates
   • Check if appointments are pending, approved, or cancelled
4. Manage Profile:
   • Update personal information
   • Change contact details

🔧 Configuration

Environment Variables

You can customize the application using environment variables in docker-compose.yml:

environment:
  - PHP_ENV=development    # development|production
  - APP_PORT=8080         # Application port

Port Configuration

To run on a different port:

PORT=3000 docker compose up

Database Location

The SQLite database is stored in the data/ directory and is automatically created on first run.

🐳 Docker Commands

# Start the application
docker compose up

# Start in background
docker compose up -d

# Rebuild containers
docker compose up --build

# Stop the application
docker compose down

# View logs
docker compose logs -f

🔒 Security Features

• Password Hashing: Secure bcrypt password hashing
• Session Security: Secure session management with regeneration
• SQL Injection Protection: Prepared statements throughout
• Role-Based Access: Admin and user role separation
• Input Validation: Server-side validation for all forms

📱 Responsive Design

The application is fully responsive and works seamlessly on:

• Desktop (1200px+)
• Tablet (768px - 1199px)
• Mobile (< 768px)

All admin and user interfaces adapt to screen size for optimal user experience.

🚀 Deployment

Production Deployment

1. Clone the repository on your server
2. Update default credentials in src/config/Database.php
3. Set environment to production:

   environment:
     - PHP_ENV=production

4. Configure reverse proxy (Nginx/Apache) if needed
5. Set up SSL certificate for HTTPS
6. Run the application:

   docker compose up -d

Database Backup

# Create backup
cp data/psychologist.db backup/psychologist_$(date +%Y%m%d).db

# Restore backup
cp backup/psychologist_YYYYMMDD.db data/psychologist.db

🤝 Contributing

1. Fork the repository
2. Create your feature branch: git checkout -b feature/AmazingFeature
3. Commit your changes: git commit -m 'Add some AmazingFeature'
4. Push to the branch: git push origin feature/AmazingFeature
5. Open a Pull Request

📝 License

This project is licensed under the MIT License - see the LICENSE file for details.

🐛 Troubleshooting

Common Issues

Port already in use

# Check what's using the port
lsof -i :8080
# Use different port
PORT=3000 docker compose up

Database permission errors

# Fix permissions
chmod 755 data/
chmod 666 data/psychologist.db

Container build issues

# Clean rebuild
docker compose down
docker system prune
docker compose up --build

📞 Support

For support, please open an issue on GitHub or contact the development team.

🎉 Acknowledgments

• Bootstrap team for the excellent CSS framework
• PHP community for maintaining great documentation
• Docker for containerization simplicity

---

Made with ❤️ for healthcare professionals and their patients.