Easemed — Web-Based Healthcare Appointment & Registration System

Easemed is a secure and user-friendly web platform designed to simplify hospital–patient interaction. It enables online registration, hospital management, and appointment scheduling, improving healthcare efficiency and accessibility.

---

🚀 Why Easemed?

• Secure online patient registration
• Fast and simple appointment booking
• Hospitals can manage details and view appointments
• Boosts workflow efficiency by 30%
• Increases patient engagement by 70%

---

📌 Features

Patient

• Create an account & log in securely
• Browse all registered hospitals
• View hospital details, images & ratings
• Book appointments with preferred time slot
• View appointment history

Hospital

• Sign up & register hospital details
• Add extra content (blogs, images, highlights)
• Log in with unique credentials
• Access all patient appointments in one dashboard

System-Level

• Session-based authentication
• MySQL relational database
• Dynamic UI with EJS templates
• Clean and modular Express routing

---

🛠 Tech Stack

Frontend: HTML, CSS, JavaScript, EJS Backend: Node.js, Express.js, express-session, body-parser Database: MySQL

---

📁 Project Structure

Easemed/
│── public/                 # Static CSS, JS, images
│── views/                  # EJS templates
│── screenshots/            # Project screenshots including homepage.png
│── node_modules/           # Installed Node modules
│── app.js                  # Main backend server
│── package.json
│── package-lock.json
└── README.md

---

⚙️ Installation & Setup

1. Clone Repository

git clone https://github.com/your-username/easemed.git
cd easemed

2. Install Node.js and npm

Check Node.js and npm versions:

node -v
npm -v

Install Node.js from Node.js official website if not present.

---

3. Install Required Node Modules

npm install express
npm install body-parser
npm install express-session
npm install mysql
npm install ejs

Or simply run:

npm install

---

4. Set Up MySQL Database

1. Install MySQL server if not installed.
2. Create database:

CREATE DATABASE easmed;

3. Create tables:

-- userdetails table
CREATE TABLE userdetails (
    id INT AUTO_INCREMENT PRIMARY KEY,
    fullName VARCHAR(25) NOT NULL,
    email VARCHAR(50) UNIQUE NOT NULL,
    password VARCHAR(25) NOT NULL
);

-- hospital_information table
CREATE TABLE hospital_information (
    id INT AUTO_INCREMENT PRIMARY KEY,
    hospitalName VARCHAR(50) NOT NULL,
    state VARCHAR(25) NOT NULL,
    city VARCHAR(25) NOT NULL,
    rating INT NOT NULL,
    email VARCHAR(50) UNIQUE NOT NULL,
    image_url VARCHAR(300),
    password VARCHAR(25) NOT NULL,
    address VARCHAR(300) NOT NULL
);

-- hospital_other_information table
CREATE TABLE hospital_other_information (
    id INT,
    image_url VARCHAR(300),
    image_url_2 VARCHAR(300),
    blog_content_1 VARCHAR(500),
    title VARCHAR(50),
    image_url_3 VARCHAR(300),
    blog_content_2 VARCHAR(500)
);

-- patientappointment table
CREATE TABLE patientappointment (
    Patient_id INT NOT NULL,
    hospital_id INT NOT NULL,
    hospital_name VARCHAR(50) NOT NULL,
    specialty VARCHAR(50) NOT NULL,
    appointment_date DATE NOT NULL,
    appointment_slot VARCHAR(50) NOT NULL,
    patient_name VARCHAR(50) NOT NULL,
    gender VARCHAR(10) NOT NULL,
    age INT NOT NULL,
    phone_number VARCHAR(10) NOT NULL,
    email VARCHAR(50) NOT NULL
);

3. Create tables (userdetails, hospital_information, hospital_other_information, patientappointment) — see schema below.
4. Update database connection in app.js:

const connection = mysql.createConnection({
    user: "your_mysql_user",
    host: "localhost",
    password: "your_mysql_password",
    database: "easmed"
});

---

5. Start the Server

node app.js

Open your browser and visit:

http://localhost:5000

---

🔐 Security Notes

• Replace default session secret in app.js:

const mySecretKey = 'YourStrongSecretKeyHere';

• Move database credentials to .env file for production.
• Use bcrypt for password hashing in future.

---

🌱 Future Enhancements

• Email OTP verification
• JWT authentication
• Doctor-wise slot booking
• Admin panel
• Docker deployment
• Automatic email notifications

---

🤝 Contributing

Pull requests and issues are welcome! For major changes, please discuss first.

---

📄 License

MIT License

---

👨‍💻 Author

Sumanth Gunji Full-Stack Developer Passionate about building real-world healthcare solutions