Jacob's Webpage!!!!

Database Assignment

• SQL code for creating and inserting values into database
• Link to the initial webpage from the tutorial
• PART 2
• graph.html

Database Assignmet Part 2: Dashboard

• dashboard
• https://jacobjaffe.io/database_assignment/insertdata.php?node_name=node_1&temperature=31&humidity=10 for a query without time
• https://jacobjaffe.io/database_assignment/insertdata.php?node_name=node_1&temperature=31&humidity=10&time_received=2025-10-01 14:01:23 for a query with time (change time so it doesn't conflict in database)
• https://jacobjaffe.io/database_assignment/insertdata.php?bm9kZV9uYW1lPW5vZGVfMSZ0ZW1wZXJhdHVyZT0zMSZodW1pZGl0eT0xMCZ0aW1lX3JlY2VpdmVkPTIwMjUtMTAtMDEgMDE6MDE6MDU= for a base64 encoding

ESP Assignment

• dashboard

ESP Sensor Assignment

• updated this dashboard

ESP API and Remote Control Assignment

• home page

MQTT Assignment

• dashboard

Thingspeak Assignment

• dashboard