Welcome to the Infirmary Management System project! This system is designed to manage the inventory of medical products, book appointments with doctors, and maintain patient records. It is built using Python and Streamlit for the frontend interface, and MySQL for the backend database.

• Features
• Installation
• Usage
• Project Structure
• Contributing
• License

• Buy Medicine
• Book Appointment
• Display All Products

• View Appointments
• View Patient Details

• Update Stock
• Display All Products

• Python 3.x
• MySQL
• Streamlit

1. Clone the repository:

   git clone https://github.com/yourusername/infirmary-management-system.git
   cd infirmary-management-system

2. Install the required Python packages:

   pip install -r requirements.txt

3. Set up the MySQL database:

   • Create a database named infirmary.
   • Create tables using the SQL commands in the project.

4. Configure the database connection:

   • Update the database connection details in maintry2working.py:

   self.db_connection = mysql.connector.connect(
       host="localhost",
       user="root",
       password="yourpassword",
       database="infirmary"
   )

1. Start the Streamlit server:

   streamlit run app.py

2. Open the app in your browser:

   • Navigate to the URL provided by Streamlit, usually http://localhost:8501.

• Patient:
  • Choose "Patient" from the sidebar.
  • Select an action: Buy Medicine, Book Appointment, or Display All Products.
• Doctor:
  • Choose "Doctor" from the sidebar.
  • Select an action: View My Appointments or View Patient Details.
• Manager:
  • Choose "Manager" from the sidebar.
  • Enter the manager password to access management features like updating stock.

infirmary-management-system/
│
├── app.py                     # Streamlit frontend interface
├── maintry2working.py         # Backend logic for the system
├── requirements.txt           # List of required Python packages
└── README.md                  # Project README file

Contributions are welcome! Please follow these steps:

1. Fork the repository
2. Create a new branch:

   git checkout -b feature/your-feature

3. Make your changes and commit:

   git commit -m 'Add some feature'

4. Push to the branch:

   git push origin feature/your-feature

5. Create a pull request

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