Doctor Appointment Booking

SOURCE CODE — Tue, 31 Mar 2026 09:30:15 +0530

✔ Price: ₹79,999

# Doctor Appointment Booking System

A complete multi-role doctor appointment booking system built with Core PHP, MySQL, and Bootstrap 5.

## Features

### 🛠️ Multi-Role System

- **Admin Panel**: Full control over the system

- **Doctor Panel**: Manage appointments and follow-ups

- **Patient Panel**: Self-registration and appointment booking

- **Staff Panel**: Limited access based on permissions

### 📊 Admin Panel Features

- Secure Admin Login

- Doctor Specializations Management (Add/Edit/Delete)

- Doctors Management (Add/Edit/Delete)

- Staff Management with role-based permissions

- Patients Management

- Appointments Management (View/Edit Date, Time, Status)

- Financial Tracking (Payment Pending/Due/Refund)

- Booking Management (Today Booking, Booking Done, Upcoming, Cancelled)

- Follow-up Tracking (Today & Upcoming)

- Scheme-Based Tracking (Ayushman, IPD, CM Fund)

### 👨‍⚕️ Doctor Panel Features

- Secure Doctor Login (ID created by Admin)

- Dashboard with assigned appointments

- Manage Appointments (Change Date, Time, Update Status)

- Follow-up Management

### 👩‍⚕️ Patient Panel Features

- Patient Self Registration

- Secure Login

- Book Appointment with available doctors

- View Appointment History

- Upcoming & Completed Appointments

### 👨‍💼 Staff Panel Features

- Staff Login (Created by Admin)

- Limited Access based on permissions:

- Booking management

- Follow-ups handling

- Payments tracking

### 📊 Special Tracking Modules

- General Dashboard Data

- Scheme-Based Tracking for:

- Ayushman

- IPD

- CM Fund

- Each category tracks: Lead, Today Booking, Upcoming Booking, This Month Completed, Pending, Not Entered, Follow-up, Follow-up Pending

### 🌐 Public Pages (Without Login)

- Doctors Page (Doctor List)

- Services Page

- About Us Page

- Contact Us Page

### 🔒 Security Features

- Session-based Login System

- Password Hashing using `password_hash()` and `password_verify()`

- Role-based Access Control

- PDO Prepared Statements to prevent SQL injection

## Project Structure

```

DPB/

├── index.php # Main login page

├── logout.php # Logout handler

├── test.php # System test page

├── README.md # This file

├── DAPB.sql # Database schema with sample data (consolidated)

├── includes/

│ ├── config.php # Database and site configuration

│ ├── database.php # PDO database connection class

│ ├── functions.php # Common utility functions

│ └── auth.php # Authentication functions

├── admin/

│ ├── header.php # Admin panel header

│ ├── dashboard.php # Admin dashboard

│ ├── doctors.php # Doctors management

│ ├── tracking.php # General tracking modules

│ └── scheme_tracking.php # Scheme-based tracking

├── doctor/

│ ├── header.php # Doctor panel header

│ └── dashboard.php # Doctor dashboard

├── patient/

│ ├── header.php # Patient panel header

│ ├── dashboard.php # Patient dashboard

│ └── book_appointment.php # Appointment booking

├── staff/

│ ├── header.php # Staff panel header

│ └── dashboard.php # Staff dashboard

├── public/

│ ├── header.php # Public site header

│ └── doctors.php # Public doctors listing

├── assets/

│ ├── css/

│ │ └── style.css # Custom CSS styles

│ ├── js/

│ │ └── script.js # Custom JavaScript

│ └── images/ # Image assets

└── uploads/ # File uploads directory

```

## Installation Guide

### Prerequisites

- PHP 7.4 or higher

- MySQL 5.7 or higher

- Web server (Apache, Nginx, or PHP built-in server)

- phpMyAdmin (optional, for database management)

### Step 1: Database Setup

1. Create a MySQL database named `doc_app_db`

2. Import the SQL file:

```sql

mysql -u username -p doc_app_db < DAPB.sql

```

Or use phpMyAdmin to import the file.

### Step 2: Configuration

1. Open `includes/config.php`

2. Update database credentials if needed:

```php

define('DB_HOST', 'localhost');

define('DB_USER', 'root');

define('DB_PASS', '');

define('DB_NAME', 'doc_app_db');

```

3. Update site URL if necessary:

```php

define('SITE_URL', 'http://localhost/DPB/');

```

### Step 3: File Permissions

Ensure the following directories are writable:

- `uploads/` - For file uploads

- `assets/images/` - For profile pictures

### Step 4: Run the Application

1. Start your web server

2. Navigate to the project directory

3. Access the application via browser:

```

http://localhost/DPB/

```

## Default Login Credentials

After importing the database, use these credentials:

### Admin

- **Username**: admin

- **Password**: admin123

- **Role**: Administrator with full access

### Doctor

- **Username**: drsmith

- **Password**: doctor123

- **Role**: Doctor

### Patient

- **Username**: john.doe

- **Password**: patient123

- **Role**: Patient

### Staff

- **Username**: staff1

- **Password**: staff123

- **Role**: Staff

## Database Schema

### Key Tables

1. **users** - User accounts for all roles

2. **specializations** - Doctor specializations

3. **doctors** - Doctor profiles linked to users

4. **patients** - Patient profiles linked to users

5. **staff** - Staff profiles linked to users

6. **appointments** - Appointment bookings

7. **payments** - Payment records

8. **follow_ups** - Follow-up appointments

9. **scheme_tracking** - Scheme-based tracking data

### Relationships

- Each doctor, patient, and staff member has a corresponding user account

- Appointments link patients to doctors

- Payments are associated with appointments

- Follow-ups are linked to appointments

- Scheme tracking is separate for statistical purposes

## Features in Detail

### Appointment Booking System

- Patients can book appointments with available doctors

- Time slot validation to prevent double booking

- Scheme selection (General, Ayushman, IPD, CM Fund)

- Automatic payment calculation based on doctor's consultation fee

### Responsive Design

- Built with Bootstrap 5 for mobile-first responsive design

- Custom CSS for consistent styling across all panels

- JavaScript for interactive elements and form validation

### Security Implementation

- Password hashing using PHP's `password_hash()`

- Session management with role-based access control

- PDO prepared statements to prevent SQL injection

- Input sanitization and validation

### Tracking Modules

- **General Tracking**: Today's bookings, upcoming appointments, payment status

- **Scheme Tracking**: Separate tracking for government healthcare schemes

- **Follow-up Tracking**: Manage patient follow-up appointments

## Customization

### Adding New Pages

1. Create the PHP file in the appropriate directory (admin/, doctor/, etc.)

2. Include the corresponding header.php file

3. Add navigation link to the sidebar menu in header.php

### Changing Colors and Styles

1. Modify CSS variables in `assets/css/style.css`

2. Update color schemes in panel-specific header files

3. Customize Bootstrap theme by overriding CSS classes

### Adding New Features

1. Extend the database schema in `DAPB.sql`

2. Update relevant PHP files to handle new functionality

3. Add appropriate validation and security measures

## Troubleshooting

### Common Issues

1. **Database Connection Error**

- Check database credentials in `includes/config.php`

- Ensure MySQL service is running

- Verify database name matches

2. **Session Issues**

- Check PHP session configuration

- Ensure `session_start()` is called before any output

- Verify directory permissions for session storage

3. **Page Not Found Errors**

- Check web server configuration

- Verify .htaccess rules (if using Apache)

- Ensure file paths are correct

4. **Permission Denied Errors**

- Check file and directory permissions

- Ensure uploads directory is writable

- Verify PHP has necessary permissions

### Testing the System

Use the built-in test page:

```

http://localhost/DPB/test.php

```

This page checks:

- PHP version compatibility

- Database connection

- Required PHP extensions

- File permissions

- Session functionality

## Browser Compatibility

- Chrome 60+

- Firefox 55+

- Safari 12+

- Edge 79+

- Opera 50+

## Technologies Used

- **Backend**: Core PHP 7.4+

- **Database**: MySQL 5.7+

- **Frontend**: HTML5, CSS3, JavaScript

- **UI Framework**: Bootstrap 5.3

- **Icons**: Font Awesome 6.4

- **Data Tables**: DataTables 1.13

- **Security**: PHP password_hash, PDO prepared statements

## License

This project is open-source and available for educational and commercial use.

## Support

For issues or questions:

1. Check the troubleshooting section above

2. Review the code comments for implementation details

3. Test with the provided test.php page

## Future Enhancements

- Email notifications for appointments

- SMS integration for reminders

- Online payment gateway integration

- Prescription management system

- Medical records management

- Analytics and reporting dashboard

- Mobile app interface

---

**Note**: This is a complete working system. For production deployment, ensure to:

1. Change default passwords

2. Configure proper SSL/TLS certificates

3. Set appropriate file permissions

4. Implement additional security measures

5. Regular database backups

6. Monitor server logs for suspicious activity

SourceCode RSS Feeds - Madical Use

Doctor Appointment Booking