Online Patients Appointment Platform

Abstract

Over the years we see that our dependence on the internet has played a major role in all areas of development. We can say that the internet is a common thing among us. This project is a web-app to use for the project appointment scheduling. Along with the patient, there is also a doctor and a super user known as admin. The only administrators have to control all the activities of the project functions. The main motivation of this project is nowadays we are seeing people are facing various problems in booking slots of doctor’s available in hospitals for the purpose of medical checkups and surgery etc. For booking the slots of the available doctors. People need to visit hospitals by taking various means of transportation and wasting their time traveling. So, we try to avoid transportation and reduce the time in taking an appointment. By using our platform people will easily be able to book their appointment as available to the doctor slots. In this project Online Patient’s Appointment Platform in hospital is necessary for a competent administration when handling patients, the flow of business is determined by the information of the patient, unfortunately the current record management system leads to the misplacement of patient details, the doctor\'s record of reports, and a lack of security for the records. This research project seeks to automate the whole process of keeping records about Patients, Hospitals, and Doctors. To accomplish this, a comprehensive System Analysis and Investigation was conducted using data collected from existing documents and data flow charts. The concept of report production has been automated, therefore, there is no more delay in receiving reports from the Hospital, Patient, or Doctor. Errors on handheld calculators have been completely eliminated. The method used to develop the system includes an iterative waterfall model. approach, dataflow, logical and entities relationship diagram were used to design the system and use CSS, SQL server, html and PHP languages.

Introduction

I. INTRODUCTION

The main objective of this project is to achieve paperless environment with quick process of appointment with doctor and maintain past records of patients and doctors. create doctor patient handling and also Admin handling management system that will help doctors in their work and will also help patients to book doctor appointments and view medical progress.

The system allows doctors to manage their reserving slots online. Patients are allowed to book empty slots online and those slots are reserved for their name respectively. The system manages the appointment data for many doctors of different dates and times. Each time a user visits a doctor his medical entry is stored in the by doctor. Next time a user logs in he may view his whole medical history as and when needed. At the same time a doctor may be able to view a patient's previous medical check-ups history while the patient visits him. The system also consists of a Blood donor module. This module allows for blood donation registrations as well as the blood group search. The module is designed to help extremely important Blood needed things through easy and instant searches. PHP Design and Implementation of a Patient Appointment and Scheduling System has been billed as using PHP with MySQL database at server side and at the client-side we use Ajax jQuery and other jQuery plugins.

The main goal for developing this project is to solve the purpose for disallowing the problems, which are not in the current system. This project is assumed to remove the hardships, which will be available in the current appointment system. But by using electronics equipment like computers and by using this device we can store valuable information which we can store under this appointment system. This project is evaluated as the fast, error free and secured platform with the fast data management. With the help of this project show the good for use of resources and stored records in the central location of the database. This project using PHP and MySQL is developed to manage the list of data by the admin, in other word super user for doctors, patients, appointment bookings, doctor available schedule information etc. This PHP Project is a web based or online application which will resolve the problem of booking of Appointment according to the choice of the patient's requirement. Under this project, there is one feature that is a very effective solution which is offered with different available doctor availability on suitable dates and times. Therefore, patients can make doctor appointments according to their needs or preferences, and they can also cancel doctor appointments, which are also available under this project. This project can also be known as Online Patient Appointment Scheduling or also called Online Appointment booking platform and it has optimized the phase of different types of medical services to increase patient body parts care experiences in the hospitals. This project has been built by motivating to see the increasing popularity of online appointment booking platforms and the main aim of developing this project is online appointment booking system.

We have added a doctor scheduling model also, which has taken into account when a patient would like to see this feature. Nowadays it is rational to establish the issue that very few hospitals have provided online appointment booking platforms. So, to solve this problem we have built this project. This Online Doctor Appointment Booking System in PHP is an easy project developed using PHP script, MySQL database, Ajax jQuery. Under this project there are three sides. There is one at the admin end, one at the doctor end, and one at the patient end. A doctor appointment system administrator will be able to manage all system data, including doctor data, patient data, doctor schedule data, and appointment data. At the Doctor side, doctors can schedule their available time details under this system, Doctor can view appointment data. And at the patient side, they can view doctor availability data and based on that data they can book appointments under this system This system has three users. Administrator, Patients and Doctor. So, all features have been divided between these three users.

A. Administration or Super User

Super user can view all doctors and patient data and Add, Edit, Delete and view Doctor. Data. It can Schedule any Doctor Availability data and manage that data like edit or delete data. view all doctor appointment data and he or she can also process appointments. Able to edit profile details and login into this system.

B. Doctor

Doctors can Add, Edit, delete their availability data under this platform. It views only his or her appointments data, they cannot see another doctor appointment data. Doctor can see appointment patient's details and write suggestions on patient appointment. Doctors can edit profile details and login into this platform.

C. Patients

Patients will able to view doctor availability on web app and register into this system and also login into this system. Book appointment and they will also be able to cancel their appointment. Patients can update their profile details.

II. BACKGROUND

This project is useful for medical and various hospital requirements for facilitating modern technologies to increase the speed and save the time of both doctors and patients. According to us we find that today population and less availability of doctor's large number of patients unable to reach ones to doctor that we developed this project. The front-end design is simple and user-friendly. Once the platform or web page is started the patient will register himself and then he will be able to log in the browser by just using their credential details. The patient will make an appointment by just selecting the preferred doctor, date and time as the slot. The appointments are managed by the administrator through their website. The administrator also registers a doctor. Administrators are able to view patient’s, view doctor's records and view feedback also. The design of the back-end includes a server which acts as a centralized database. All the data of the registered doctors, patients and the data regarding to the appointments are placed on the server. The background of this project is used as a final year project in b.tech and we use php, sql server and check the development status of the project using localhost. We can use it at the hospital level to add some more storage capacity to the database.

III. METHODOLOGY

We have made this project by mini waterfall development model. In the midst of any kind of increase, we have tried to make it better. We have developed the project with time by separating many parts. We use php that is embedded in HTML. It has also been used to manage dynamic content like Database, CSS, Session Tracking. Php integrates with a number of popular databases including MySQL which is used in this project, Oracle, PostgreSQL, Sybase, Informix, and Microsoft SQL Server. In client-side scripting we use these technologies to provide effective and interactive sites for the patients and also for doctors. Bootstrap, jQuery, CSS Ajax.

A. Project Planning

First we planned the project and pointed out the following points.

1. Estimation of time, cost and staff, as we know we are only four members in this project so we tried to increase the project time to meet the staff requirement.
2. Also design GUI parts for each user like patient, doctor and administrator.
3. Design Database for each interface of the project.

B. Project Scheduling

The development planning of the project starts in October and is completed in the first week of April. During this project we face some issue with database connectivity and some issue error with php server files. In the process of integration and testing we face some new problem and solved with the help of technology documentation and consultant sir.We are glad that we completed this project well keeping in view the time limit, and we got to learn something new from this project

IV. RESULTS

Establishment of a paperless environment. improve this to make easy appointments for patients to save the time of doctor and patient both. The appointment can be booked only for a particular time slot on a specific date. New patients can fill up an online registration form giving all the information in the details. Taking an appointment becomes easy.

Manually taking an appointment is time consuming, and patients can save time by using this technology. Due to this Web site, a lot of activities are avoided that take place in the current situation. This project is just an idea of the future technologies which will be great with the use of artificial intelligence and machine learning to achieve almost 100% of the goal of this project. We never overlook the upcoming technologies, which will provide the best solution to the problem that the patients are face with different levels of disease in their life. We try to propose a better solution for this type of problem arising in the society/country. We believe that our project is best solution in today's situation.

V. ACKNOWLEDGEMENT

It gives us a great sense of pleasure to present the report of B.Tech project undertaken during B. Tech., Final Year. We express our sincere gratitude to our respected supervisor, Dr. Ramveer Singh(Assistant Professor, Department of Information Technology, Greater Noida Institute of Technology, Greater Noida) for his invaluable inspiring guidance and constant encouragement during the period of project work. We owe special debt of gratitude to Dr. Ramveer Singh(Assistant Professor, Department of Information Technology, Greater Noida Institute of Technology, Greater Noida) for his constant support and guidance throughout the course of our work. His sincerity, thoroughness and perseverance have been a constant source of inspiration for us. It is only his cognizant efforts that our endeavours have seen light of the day. We also take the opportunity to acknowledge the contribution of Prof. Vikas Singhal, (Head, Department of Information Technology, Greater Noida Institute of Technology, Greater Noida) for his full support and assistance during the development of the project. We also like to acknowledge the contribution of all faculty members of the department for their kind assistance during the development of our project. Last but not the least, we acknowledge our friends for their contribution in the completion of this project.

Conclusion

This project seems to be incomplete as we have not done the work of making it portable. If we try to improve this project, we can do it well for Android and iPhone users as well. But this time other factors make this a good project. It\'s like an achievement for us. We can add various facilities in the future. It will be a more advanced software for the Doctor Appointment System including more facilities. When we host the platform on online servers to make it accessible worldwide. Create the master and slave database structure to decrease the overload of the database queries. Implement the backup mechanism for taking backup of codebase and database on a regular basis on different servers.

References

[1] Google Search [2] Stack Overflow for programming event problems. [3] https://docs.oracle.com/ [4] http://www.wampserver.com/en/ [5] http://www.tutorialspoint.com/mysql/ [6] httpd.apache.org/docs/2.0/misc/tutorials.html [7] https://www.php.net/manual/en/langref.php [8] https://docs.php.earth/php/ref/

Copyright

Copyright © 2022 Sunil Kumar Yadav, Shubham Prajapati , Shivakant Yadav , Vinay Kumar Yadav . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.