Online Doctor Appointment Using PHP and MySql Source Code ( Final Year)

Admin Features

• Here are the detailed Admin features for the Online Doctor Appointment System project:

• 1. Admin Dashboard

• The admin dashboard provides a consolidated view of system data, including the total number of doctors, patients, and appointments.
• The dashboard also provides quick access to other management features, helping the admin navigate the system efficiently.

• 2. Manage Doctors

• The admin has the ability to add new doctors to the system. This includes entering detailed information about each doctor, such as their name, specialty, contact details, and credentials.
• Admins can also edit or update existing doctor profiles when necessary, ensuring that all information remains accurate and up-to-date.
• If a doctor is no longer available or relevant, the admin can delete doctor profiles from the system.

• 3. Schedule and Manage Doctor Sessions

• The admin can schedule sessions for each doctor, specifying the available dates and times when doctors are available to take appointments.
• They can also remove or reschedule sessions based on the doctor's availability or any necessary changes.
• This allows for efficient management of doctors' time and ensures that patients can only book appointments during available slots.

• 4. View Patient Details

• Admins can view detailed information about all patients registered in the system. This includes their personal information, medical history (if applicable), and any other details provided during registration.
• The admin can use this information to monitor patient activity and ensure the system is running smoothly.

• 5. Manage Patient Bookings

• The admin has the ability to view and manage all patient bookings. This includes seeing which patients have booked appointments, which doctor they have booked with, and the time and date of each appointment.
• Admins can modify or delete bookings if necessary, ensuring that scheduling conflicts are avoided and the system remains organized.

• 6. Appointment Overview

• The admin can view a complete overview of all appointments made within the system. This includes both past and upcoming appointments, providing insight into system activity and doctor-patient interactions.

• 7. Security and User Management

• The admin has access to control and manage the security aspects of the system. This includes setting permissions for doctors and patients, managing user accounts, and ensuring data privacy.
• The admin can also assist users (doctors or patients) by resetting passwords, editing personal details, or disabling accounts if required.

User Features

• Here are the detailed Patient features for the Online Doctor Appointment System project:

• 1. Online Appointment Booking

• Patients can conveniently book appointments online with doctors through the system. They can browse the available doctors and select a specialist that fits their medical needs. This saves patients time and effort by eliminating the need to physically visit a clinic or hospital to schedule an appointment.

• 2. Account Creation and Management

• Patients can create their own accounts on the system by providing basic personal details. After registration, they can log in using their credentials to access all the features of the platform.
• Once registered, patients can edit their account settings, such as updating personal information, contact details, and changing passwords for secure access.

• 3. Browse Doctor's Specialties

• The platform allows patients to search and filter doctors based on their specialties (e.g., cardiology, dermatology). This makes it easier for patients to find the right doctor for their specific health concerns.
• Patients can also view detailed information about each doctor, including their credentials, experience, and consultation availability.

• 4. View Doctor's Weekly Schedule

• Patients can view the doctor’s weekly schedule to check the available days and times for appointments. This feature helps patients pick a suitable time slot based on their availability and the doctor's schedule, making the booking process more flexible and patient-friendly.

• 5. View Appointment History

• Patients can view their past appointments and booking history. This feature is useful for tracking previous consultations, revisiting doctor notes or prescriptions, and ensuring continuity of care.

• 6. Manage Appointments

• After booking an appointment, patients can view the status of their appointment request (e.g., confirmed, pending). They can also modify or cancel appointments if needed, ensuring they have full control over their scheduling.

• 7. Delete Account

• If a patient no longer wishes to use the platform, they have the option to delete their account. This feature ensures patient data is managed according to their preferences and gives them control over their information.

• 8. User-Friendly Dashboard

• Patients have access to their personalized dashboard, where they can view all relevant information such as upcoming appointments, doctor details, and appointment history. The dashboard makes it easy for patients to navigate and manage their medical appointments in one place.

Other Features

• Here are the detailed doctor features for the Online Doctor Appointment System project:

• 1. View Appointments

• Doctors can log in to the system and view all the appointments made by patients.
• They can see the details of each appointment request, including the patient’s name, the selected time slot, and the reason for the appointment.
• This allows doctors to manage their daily schedule efficiently and prepare for upcoming consultations.

• 2. View Scheduled Sessions

• The system allows doctors to view their entire schedule of sessions as set by the admin.
• Doctors can check their availability for appointments on specific days and time slots.
• They can also see which time slots are already booked by patients and which are still open.

• 3. View Patient Details

• Doctors can view the personal details of patients who have booked appointments with them.
• This feature includes viewing patient medical history, appointment reasons, and other relevant details, allowing doctors to review the case before the consultation.

• 4. Edit Account Settings

• Doctors can update their account information, such as name, email, and password, through the account settings page.
• This feature ensures that doctors can manage their profile details and keep their account information up to date.

• 5. Delete Account

• If a doctor decides to leave the system, they can delete their account from the platform.
• This feature gives doctors full control over their presence on the platform, ensuring that their data is removed if they no longer wish to use the system.

How to run Online Doctor Appointment Using PHP and MySql

• To run the Online Doctor Appointment System project locally on your machine, follow these detailed instructions:

• 1. System Requirements

• Before you begin, ensure that you have the following installed on your system:
• XAMPP (or any other Apache server with PHP and MySQL).
• A web browser like Google Chrome or Mozilla Firefox.

• 2. Download and Extract the Project

• First, download the project files from the FileMakr.
• Once downloaded, unzip the source code folder to extract the files.

• 3. Set Up XAMPP (or Alternative Server)

• Open your XAMPP Control Panel.
• Start both the Apache and MySQL services by clicking the 'Start' buttons next to each module.

• 4. Move Project Files to htdocs

• Navigate to the folder where you installed XAMPP (usually C:\xampp on Windows).
• Open the htdocs directory (C:\xampp\htdocs).
• Copy the extracted project folder and paste it inside the htdocs directory. (Make sure to copy the extracted folder, not the .zip file).

• 5. Set Up the MySQL Database

• Open your web browser and go to PHPMyAdmin by typing the following URL into the address bar:
• http://localhost/phpmyadmin/
• Inside PHPMyAdmin, create a new database:
• Click on the "Databases" tab.
• In the "Create database" field, enter the name of the database as edoc.
• Click the "Create" button.
• Once the database is created, import the SQL file:
• Click on the edoc database from the left-hand sidebar.
• Click on the Import tab at the top.
• Click on the "Choose File" button, navigate to the project's root folder, and select the file named SQL_Database_edoc.sql.
• Click the "Go" button to import the database structure and data.

• 6. Configure Database Connection

• Locate the connection.php file in the project folder.
• Open the file in any text editor (such as Notepad or VS Code).
• Ensure the MySQL connection details match the settings in your XAMPP server:
• $servername = "localhost";
• $username = "root";  // Default username for XAMPP
• $password = "";      // Default password is blank for XAMPP
• $dbname = "edoc";    // The name of the database you created in PHPMyAdmin

• 7. Access the Application

• Open your web browser and go to the following URL to access the project:
• http://localhost/[YOUR_PROJECT_FOLDER_NAME]/

Credentials

License

Online Doctor Appointment Using PHP and MySql Source Code Tags