After setting up all these, go to the URL “ PROJECT_FOLDER_NAME ]/“.
Click on the “Import” tab and choose the database file (.sql) which is provided under the folder naming “DATABASE FILE”.Create a Database with a name that is provided inside the “01 LOGIN DETAILS & PROJECT INFO.txt”.Open your favorite browser we recommend using Google Chrome or Mozilla Firefox.Inside the “htdocs” folder, paste the project folder (not the.There you’ll find a folder naming “htdocs”.After you finish downloading the project, unzip the project file and head over to your XAMPP directory.As a matter of Privacy Policy we don’t save ‘password’ directly but instead, store the HashCode corresponding to it.There are some functionalities like creating a new administrator, logging out, and password change.We have created a simple login and user registration system using authentication from Admin User Table.To display year-wise appointment detailsĥ) Managing Staff, Rooms, and Medicines related to Information:.To display patient-wise appointment details.To get the trend of appointments for each weekday.To get the information about the most famous doctor/s among the patientsģ) Managing Appointment Related Information:.And generates the total amount to be paid. At last, we have generated a bill for a visit of a patient, which includes a patient’s visit charge, doctor charge, medicine charge, etc.However, we do not have a table that shows the details of outdoor patients. In our database, we have a table for all the patients in the hospital, and then a separate table for indoor patients.To get the information about the patients who took an appointment during the current month.To display the patients who took appointments on the weekends.To get the details of the patient who has the maximum number of appointments in this hospital.To get an overview related to the blood groups of all the patients present in the database.For deriving the age of a patient, given the DOB, we have created a function followed by a procedure.We can implement it in modern browsers like IE7+, Firefox, Safari, Google Chrome, and Opera that support CSS and HTML frameworks. We deployed our web server on localhost using Apache(built-in server) using MAMP/WAMP (MacOS/Windows Apache MySQL PHP. The web browser is Chrome with PhpMyAdmin as Front-end and Back-end Integration. The operating system was Windows 10 / macOS Catalina. We have used Netbeans IDE 8.2 software to configure PHP/HTML/CSS scripts on our localhost webserver.
0 kommentar(er)
