Creating a Health Monitoring Wearable Project involves several components, including a MySQL database schema, file structure, layout design using Bootstrap 5, and complete PHP scripts for user authentication and management. Below is a comprehensive guide to help you set up your system.

Project Introduction

The Health Monitoring Wearable System is a web application designed to help users track and manage their health and fitness data through wearable devices. This platform allows users to connect their devices, monitor vital health metrics, set health goals, and receive notifications to stay on track with their fitness journey. With features for user profiles, health data logging, and report generation, the system aims to empower users to take control of their health and wellness.

Project Objectives

  • To develop a secure and user-friendly platform for managing health data from wearable devices.
  • To implement a comprehensive database schema that supports user management, device pairing, and health data tracking.
  • To provide functionalities for setting and monitoring health goals to encourage users to achieve their fitness objectives.
  • To facilitate notifications for important health reminders and updates based on user preferences.
  • To create a responsive design that enhances user experience across various devices.
  • To generate reports that provide insights into health metrics and progress over time.

Project Modules

  1. User Management: Handles user registration, authentication, and profile management.
  2. User Profiles: Manages user-specific health information, including age, gender, height, weight, and preferences.
  3. Device Management: Allows users to add and manage their wearable devices, including battery levels and pairing status.
  4. Health Data Management: Logs health metrics such as heart rate, steps, calories burned, and sleep duration recorded from devices.
  5. Health Goals Management: Enables users to set and track health goals related to steps, weight loss, and exercise time.
  6. Notification System: Sends alerts and reminders to users regarding their health goals and important updates.
  7. Report Generation: Creates reports summarizing health data and progress towards goals for user review.

1. MySQL Database Schema


CREATE DATABASE health_monitoring_wearable;
USE health_monitoring_wearable;
-- Table for users
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    email VARCHAR(100) NOT NULL UNIQUE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- Table for user profiles
CREATE TABLE user_profiles (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    age INT,
    gender ENUM('male', 'female', 'other'),
    height DECIMAL(5, 2), -- in cm
    weight DECIMAL(5, 2), -- in kg
    preferences TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for devices
CREATE TABLE devices (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    device_name VARCHAR(100) NOT NULL,
    device_type ENUM('smartwatch', 'fitness_band') NOT NULL,
    paired BOOLEAN DEFAULT FALSE,
    battery_level INT DEFAULT 100, -- percentage
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for health data
CREATE TABLE health_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    device_id INT NOT NULL,
    heart_rate INT,
    steps INT,
    calories_burned INT,
    sleep_duration INT, -- in minutes
    recorded_at DATETIME NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
    FOREIGN KEY (device_id) REFERENCES devices(id) ON DELETE CASCADE
);
-- Table for health goals
CREATE TABLE health_goals (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    goal_type ENUM('steps', 'weight_loss', 'exercise_time') NOT NULL,
    target_value DECIMAL(10, 2) NOT NULL,
    current_value DECIMAL(10, 2) DEFAULT 0,
    due_date DATE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for notifications
CREATE TABLE notifications (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    message TEXT NOT NULL,
    is_read BOOLEAN DEFAULT FALSE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- Table for reports
CREATE TABLE reports (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    report_date DATE NOT NULL,
    summary TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);

2. File and Folder Structure


health_monitoring_wearable/
│
├── config/
│   └── db.php
│
├── public/
│   ├── index.php
│   ├── login.php
│   ├── register.php
│   ├── dashboard.php
│   ├── devices.php
│   ├── health_data.php
│   ├── goals.php
│   ├── notifications.php
│   ├── reports.php
│   └── admin_dashboard.php
│
├── includes/
│   ├── header.php
│   ├── footer.php
│   └── functions.php
│
├── assets/
│   ├── css/
│   │   └── styles.css
│   ├── js/
│   │   └── scripts.js
│   └── images/
│
└── vendor/
    └── (Bootstrap and other libraries)

3. Layout Based Design with Bootstrap 5

Header (includes/header.php)


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="assets/css/styles.css">
    <title>Health Monitoring Wearable</title>
</head>
<body>
    <div class="container">
        <header class="my-4">
            <h1>Health Monitoring Wearable</h1>
        </header>
        <nav class="navbar navbar-expand-lg navbar-light bg-light">
            <div class="container-fluid">
                <a class="navbar-brand" href="index.php">Home</a>
                <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                    <span class="navbar-toggler-icon"></span>
                </button>
                <div class="collapse navbar-collapse" id="navbarNav">
                    <ul class="navbar-nav">
                        <li class="nav-item">
                            <a class="nav-link" href="devices.php">Devices</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="health_data.php">Health Data</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="goals.php">Health Goals</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="notifications.php">Notifications</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="reports.php">Reports</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="login.php">Login</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="register.php">Register</a>
                        </li>
                    </ul>
                </div>
            </div>
        </nav>
        <main class="my-4">

Footer (includes/footer.php)


        </main>
        <footer class="text-center my-4">
            <p>© 2023 Health Monitoring Wearable. All rights reserved.</p>
        </footer>
    </div>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>

4. PHP Code for User Authentication

Registration (public/register.php)


<?php
require '../config/db.php';
require '../includes/header.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $username = $_POST['username'];
    $email = $_POST['email'];
    $password = password_hash($_POST['password'], PASSWORD_DEFAULT);
    $stmt = $conn->prepare("INSERT INTO users (username, email, password) VALUES (?, ?, ?)");
    $stmt->bind_param("sss", $username, $email, $password);
    $stmt->execute();
    $stmt->close();
    header("Location: login.php");
}
?>
<form method="POST" action="">
    <div class="mb-3">
        <label for="username" class="form-label">Username</label>
        <input type="text" class="form-control" id="username" name="username" required>
    </div>
    <div class="mb-3">
        <label for="email" class="form-label">Email</label>
        <input type="email" class="form-control" id="email" name="email" required>
    </div>
    <div class="mb-3">
        <label for="password" class="form-label">Password</label>
        <input type="password" class="form-control" id="password" name="password" required>
    </div>
    <button type="submit" class="btn btn-primary">Register</button>
</form>
<?php require '../includes/footer.php'; ?>

Login (public/login.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $username = $_POST['username'];
    $password = $_POST['password'];
    $stmt = $conn->prepare("SELECT * FROM users WHERE username = ?");
    $stmt->bind_param("s", $username);
    $stmt->execute();
    $result = $stmt->get_result();
    $user = $result->fetch_assoc();
    if ($user && password_verify($password, $user['password'])) {
        $_SESSION['user_id'] = $user['id'];
        header("Location: dashboard.php");
    } else {
        echo "Invalid credentials.";
    }
}
?>
<form method="POST" action="">
    <div class="mb-3">
        <label for="username" class="form-label">Username</label>
        <input type="text" class="form-control" id="username" name="username" required>
    </div>
    <div class="mb-3">
        <label for="password" class="form-label">Password</label>
        <input type="password" class="form-control" id="password" name="password" required>
    </div>
    <button type="submit" class="btn btn-primary">Login</button>
</form>
<?php require '../includes/footer.php'; ?>

5. Additional PHP Scripts

Dashboard (public/dashboard.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
$user_id = $_SESSION['user_id'];
$stmt = $conn->prepare("SELECT * FROM users WHERE id = ?");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
?>
<h2>Welcome, <?php echo $user['username']; ?></h2>
<p>Your role: <?php echo ucfirst($user['role']); ?></p>
<?php require '../includes/footer.php'; ?>

Device Management (public/devices.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $device_name = $_POST['device_name'];
    $device_type = $_POST['device_type'];
    $paired = $_POST['paired'] ? 1 : 0;
    $stmt = $conn->prepare("INSERT INTO devices (user_id, device_name, device_type, paired) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("issi", $_SESSION['user_id'], $device_name, $device_type, $paired);
    $stmt->execute();
    $stmt->close();
    header("Location: devices.php");
}
?>
<h2>Manage Devices</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="device_name" class="form-label">Device Name</label>
        <input type="text" class="form-control" id="device_name" name="device_name" required>
    </div>
    <div class="mb-3">
        <label for="device_type" class="form-label">Device Type</label>
        <select class="form-select" id="device_type" name="device_type" required>
            <option value="smartwatch">Smartwatch</option>
            <option value="fitness_band">Fitness Band</option>
        </select>
    </div>
    <div class="mb-3">
        <label for="paired" class="form-label">Paired</label>
        <input type="checkbox" id="paired" name="paired" value="1">
    </div>
    <button type="submit" class="btn btn-primary">Add Device</button>
</form>
<h3>Existing Devices</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Device Name</th>
            <th>Device Type</th>
            <th>Paired</th>
            <th>Added At</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT * FROM devices WHERE user_id = ?");
        $stmt->bind_param("i", $_SESSION['user_id']);
        $stmt->execute();
        $result = $stmt->get_result();
        while ($device = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $device['id']; ?></td>
            <td><?php echo $device['device_name']; ?></td>
            <td><?php echo $device['device_type']; ?></td>
            <td><?php echo $device['paired'] ? 'Yes' : 'No'; ?></td>
            <td><?php echo $device['created_at']; ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

Health Data Management (public/health_data.php)


<?php
session_start();
require '../config/db.php';
require '../includes/header.php';
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $device_id = $_POST['device_id'];
    $heart_rate = $_POST['heart_rate'];
    $steps = $_POST['steps'];
    $calories_burned = $_POST['calories_burned'];
    $sleep_duration = $_POST['sleep_duration'];
    $stmt = $conn->prepare("INSERT INTO health_data (user_id, device_id, heart_rate, steps, calories_burned, sleep_duration, recorded_at) VALUES (?, ?, ?, ?, ?, ?, NOW())");
    $stmt->bind_param("iiiii", $_SESSION['user_id'], $device_id, $heart_rate, $steps, $calories_burned, $sleep_duration);
    $stmt->execute();
    $stmt->close();
    header("Location: health_data.php");
}
// Fetch devices for the form
$stmt = $conn->prepare("SELECT * FROM devices WHERE user_id = ?");
$stmt->bind_param("i", $_SESSION['user_id']);
$stmt->execute();
$result = $stmt->get_result();
$devices = $result->fetch_all(MYSQLI_ASSOC);
?>
<h2>Manage Health Data</h2>
<form method="POST" action="">
    <div class="mb-3">
        <label for="device_id" class="form-label">Select Device</label>
        <select class="form-select" id="device_id" name="device_id" required>
            <?php foreach ($devices as $device): ?>
            <option value="<?php echo $device['id']; ?>"><?php echo $device['device_name']; ?></option>
            <?php endforeach; ?>
        </select>
    </div>
    <div class="mb-3">
        <label for="heart_rate" class="form-label">Heart Rate</label>
        <input type="number" class="form-control" id="heart_rate" name="heart_rate" required>
    </div>
    <div class="mb-3">
        <label for="steps" class="form-label">Steps</label>
        <input type="number" class="form-control" id="steps" name="steps" required>
    </div>
    <div class="mb-3">
        <label for="calories_burned" class="form-label">Calories Burned</label>
        <input type="number" class="form-control" id="calories_burned" name="calories_burned" required>
    </div>
    <div class="mb-3">
        <label for="sleep_duration" class="form-label">Sleep Duration (minutes)</label>
        <input type="number" class="form-control" id="sleep_duration" name="sleep_duration" required>
    </div>
    <button type="submit" class="btn btn-primary">Add Health Data</button>
</form>
<h3>Existing Health Data</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>Device ID</th>
            <th>Heart Rate</th>
            <th>Steps</th>
            <th>Calories Burned</th>
            <th>Sleep Duration</th>
            <th>Recorded At</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $stmt = $conn->prepare("SELECT * FROM health_data WHERE user_id = ?");
        $stmt->bind_param("i", $_SESSION['user_id']);
        $stmt->execute();
        $result = $stmt->get_result();
        while ($data = $result->fetch_assoc()): ?>
        <tr>
            <td><?php echo $data['id']; ?></td>
            <td><?php echo $data['device_id']; ?></td>
            <td><?php echo $data['heart_rate']; ?></td>
            <td><?php echo $data['steps']; ?></td>
            <td><?php echo $data['calories_burned']; ?></td>
            <td><?php echo $data['sleep_duration']; ?></td>
            <td><?php echo $data['recorded_at']; ?></td>
        </tr>
        <?php endwhile; ?>
    </tbody>
</table>
<?php require '../includes/footer.php'; ?>

6. Additional Features to Consider

User Profiles: Allow users to edit their profiles and manage their settings.

Advanced Reporting: Implement more sophisticated reporting features for better insights.

Mobile Responsiveness: Ensure the application is fully responsive for mobile users.

7. Security Measures

Input Validation: Ensure all user inputs are validated to prevent SQL injection and XSS attacks.

Password Security: Use strong hashing algorithms for storing passwords.

Session Security: Implement secure session management practices to protect user sessions.

8. Testing and Deployment

Unit Testing: Conduct unit tests for individual components to ensure they function correctly.

Integration Testing: Test the integration of different modules to ensure they work together seamlessly.

Deployment: Choose a reliable hosting provider and deploy the application, ensuring all configurations are optimized for performance.

9. Documentation

User Documentation: Create a user manual to guide users through the platform's features and functionalities.

Developer Documentation: Document the codebase and architecture for future reference and maintenance.

10. Future Enhancements

AI-Powered Insights: Implement machine learning algorithms to provide insights into health trends and recommendations.

Mobile Application: Develop a mobile application for users to access the platform on the go.

Integration with Other Systems: Consider integrating with existing health services or applications for a more comprehensive solution.

This structured approach will help you build a comprehensive Health Monitoring Wearable Project that meets user needs and adapts to future requirements.