Back to Portfolio
IoT Coursework | ESP Firmware | PHP/MySQL Dashboard

IoT Sensor Dashboard and Networked Control

A collection of EE470 Internet-of-Things projects combining embedded firmware, web interfaces, sensor data logging, PHP/MySQL backend scripts, and remote device control.

The work demonstrates how embedded devices can send data to web applications, store sensor records in a database, and respond to web-based control commands.

View GitHub System Layers Project Areas
ESP Embedded IoT firmware
PHP Server-side web scripts
MySQL Sensor data storage
Chart.js Dashboard visualization

Project Overview

Purpose

This repository presents cleaned and reorganized EE470 coursework as a portfolio project. The projects show how embedded devices can communicate with web services, store data, and support remote control workflows.

Engineering Focus

The focus was on connecting firmware, web backends, databases, and dashboards into practical IoT workflows. The work includes sensor logging, registered-node validation, LED/RGB control, dashboard display, and networked communication.

Dashboard Screenshot

IoT dashboard and networked control webpage

IoT dashboard/control webpage used as part of the EE470 projects. The portfolio version organizes the firmware, web scripts, and database files into separate layers.

Project Areas

Sensor Database and Dashboard

PHP MySQL Chart.js Sensor Data

Stores registered sensor nodes and temperature/humidity readings in a MySQL database. The dashboard displays sensor records, registered nodes, average readings, and a temperature graph.

  • SQL database schema
  • Sensor registration table
  • Sensor data table
  • PHP data insertion script
  • PHP overview dashboard
  • Chart.js visualization

RGB / LED Web Control

ESP Firmware Web Control PHP

Demonstrates web-based control of LED and RGB outputs. Embedded firmware communicates with PHP scripts and text-based state files to retrieve or update output states.

  • LED on/off control
  • RGB output control
  • Web control pages
  • State-file based communication
  • ESP firmware integration

Lux Monitor

Sensor Input Embedded Logic Thresholds

Measures light levels and provides threshold-based feedback using embedded firmware. This project highlights basic sensor input processing and device response logic.

  • Light-level sensing
  • Threshold comparison
  • Embedded response behavior
  • Firmware-based sensor processing

HQTT / Networked Communication

HTTP ESP Firmware PHP Backend

Demonstrates networked communication between embedded firmware and a PHP backend. The project shows how an embedded device can interact with a web-hosted script.

  • ESP-to-web communication
  • PHP server-side handling
  • HTTP-style query behavior
  • Web-connected device workflow

System Layers

Firmware Layer

ESP-based firmware collects sensor input, controls outputs, and communicates with web-hosted scripts using network requests.

Web Backend Layer

PHP scripts receive data, validate query parameters, update state files, insert records, and retrieve information from the database.

Database Layer

MySQL tables store registered sensor nodes, sensor readings, and combined views used for dashboard display and analysis.

Dashboard Layer

Web pages display sensor tables, averages, charts, and controls for interacting with IoT devices.

Repository Organization

The portfolio version is organized by system layer instead of raw assignment order. 

database/
  sensor_database_setup.sql

firmware/
  hqtt/
  lux-monitor/
  rgb-led-control/

web/
  hqtt/
  sensor-dashboard/
  rgb-led-control/

Security and Cleanup

Public Portfolio Version

Before publishing, this repository was reviewed so that WiFi passwords, database credentials, webhook URLs, API keys, and deployment-specific secrets were not exposed.

Sensitive values were replaced with placeholder values such as: 

YOUR_WIFI_SSID
YOUR_WIFI_PASSWORD
YOUR_DATABASE_HOST
YOUR_DATABASE_USERNAME
YOUR_DATABASE_PASSWORD
YOUR_DATABASE_NAME
YOUR_IFTTT_WEBHOOK_URL

Technologies and Skills Demonstrated

Technologies

ESP Firmware C/C++ PHP MySQL HTML/CSS Chart.js HTTP Queries Hostinger

Skills

IoT Systems Embedded Firmware Database Design Backend Development Dashboard Development Sensor Data Validation Web-Based Control Code Sanitization

Project Outcome

These EE470 projects demonstrated practical IoT development across firmware, server-side scripting, database storage, and web dashboard visualization. The cleaned portfolio version shows the projects as a connected set of IoT workflows rather than separate assignments.

This work strengthened my experience with embedded network communication, PHP/MySQL data handling, dashboard design, and organizing code into clean public repositories.

View GitHub Back to Portfolio