Create a Hospital Management System using PHP and MySQL

The Hospital Management System (HMS) is a robust and efficient solution designed to streamline the processes within a healthcare facility. This project is built using PHP and MySQL, offering a user-friendly interface for managing patient information, appointments, and other essential aspects of hospital administration.

Preview

Approach

The approach involves creating a web-based system that utilizes PHP for server-side scripting and MySQL for the database. PHP handles the backend logic, while MySQL stores and retrieves data efficiently.

Steps to Create & Configure the Project

Step 1: Set Up a Local Development Environment.

• Install a web server (XAMPP, WampServer) to run PHP scripts.
• Set up a MySQL database for storing hospital data.

Step 2: Create Database and Tables

• Design the database schema to store patient information. In MySQL, create a database named hospital_management. Design tables, such as patients, to store relevant data like patient names, ages, and admission dates. Ensure to define appropriate data types, primary keys, and relationships.

CREATE DATABASE hospital_management;
USE hospital_management;
CREATE TABLE patients (
 id INT PRIMARY KEY AUTO_INCREMENT,
 name VARCHAR(255) NOT NULL,
 age INT NOT NULL,
 gender VARCHAR(10) NOT NULL,
 address TEXT,
 admission_date DATE NOT NULL
);

Step 3: Build PHP Scripts

• Develop PHP scripts to handle various functionalities. Create separate PHP files for different features, such as adding patients (add_patient.php) and viewing patient information (view_patients.php). Implement the logic for interacting with the database, processing form submissions, and rendering dynamic content.

• Defines the HTML structure for the home page. Provides links to "add_patient.php" and "view_patients.php." The embedded CSS styles enhance the appearance of the page.

• Contains PHP code to handle form submissions. Retrieves data from the submitted form (name, age, etc.) using the $_POST superglobal. Connects to the MySQL database, constructs an SQL query, and inserts the new patient record. The HTML part includes a form with input fields for patient details.

• Connects to the MySQL database and executes an SQL query to fetch all patient records. Utilizes a while loop to iterate through the result set and dynamically generates an HTML table displaying patient information.

Step 4: Adding Data to the Table

If you want to insert dummy data through mysql, You can us ethe following code:

INSERT INTO patients (name, age, gender, address, admission_date) VALUES
('John Doe', 35, 'Male', '123 Main St, Cityville', '2022-01-15'),
('Jane Smith', 28, 'Female', '456 Oak St, Townsville', '2022-01-16'),
('Bob Johnson', 45, 'Male', '789 Pine St, Villagetown', '2022-01-17'),
('Alice Brown', 32, 'Female', '987 Cedar St, Hamletville', '2022-01-18'),
('Charlie Wilson', 50, 'Male', '654 Birch St, Countryside', '2022-01-19');

Project Structure

👁 fewfe

Steps 5: Run the Application

• Start your local web server and MySQL database.
• Place the project files in the root directory of your web server.
• Access the application through the web browser (e.g., http://localhost/Hospital management/index.php).

Output: