Crazy about Arduino - Level 3 - Building a Web-based Data-Logger

Building a Complete Internet of Things solution with MySQL and a Web Server

Instructed by Idan Gabrieli

  • Build a End-to-End Internet of Things (IoT) Data logger
  • Collect data using multiple sensors: DHT11, LDR and Ultrasonic
  • Setup a personal Web and Database Server(MySQL)
  • Connect the Arduino to the Internet using Ethernet module
  • Design and use a Web API to send sensors data from the Arduino to the Web Server
  • Analyze the Data logger data

LEVEL 3

  • Do you like building “things” by yourself?

  • Are you looking for ways to easily combine software code and some hardware components?

  • Did you ever wonder how electronic devices are really working?

  • Do you have some creative ideas and you just looking for ways to easily prototype them?

If the answer is “YES” for some of the questions above then you just landed in the right place!. Arduino is an amazing development and prototyping platform with endless possibilities for Do-It-Yourself Makers looking for ways to express their creative mind and technical capabilities. 

This course is LEVEL 3 as part of a larger comprehensive training program divided to levels that are all about Arduino and the eco-system around it. Each course covers a specific group of subjects to let you develop and grow your skills in a step-by-step pace while enjoying the long journey.

Are you Ready to start being “Crazy” about Arduino....?  ;-)

  • Basic electronics background (The Theory Behind Electronics - A Beginners Guide)
  • Basic knowledge about Arduino (Crazy about Arduino Level 1 and Level 2)
  • Anyone that is willing to get CRAZY about Arduino
  • Technology Innovators
  • Electronics Makers
View More...

Section 1 : Getting Started

  • Lecture 1 :
  • Lecture 2 :
  • Before we start...

Section 2 : Step 1 - Setting the Sensors - Let's Measure Something....

  • Lecture 1 :
  • Introduction
  • Lecture 2 :
  • What is a Sensor ?
  • Lecture 3 :
  • Sensors are Everywhere
  • Lecture 4 :
  • Measuring Temperature and Humidity
  • Lecture 5 :
  • Measuring Light Changes
  • Lecture 6 :
  • Measuring Distance
  • Lecture 7 :
  • Wiring All Sensors to the Arduino
  • Lecture 8 :
  • Hardware Setup - All Sensors
  • Lecture 9 :
  • Project Demo
  • Lecture 10 :
  • Code Review

Section 3 : Step 2 - Ethernet Shield - Get Connected !

  • Lecture 1 :
  • Introduction
  • Lecture 2 :
  • IP Address
  • Lecture 3 :
  • MAC Address
  • Lecture 4 :
  • Client-Server Communication
  • Lecture 5 :
  • TCP/UDP Ports
  • Lecture 6 :
  • Network Socket
  • Lecture 7 :
  • TCP Session
  • Lecture 8 :
  • HTTP and HTML
  • Lecture 9 :
  • The Ethernet Shield W5100
  • Lecture 10 :
  • The Ethernet Library
  • Lecture 11 :
  • Hardware Setup - Ethernet Shield W5100
  • Lecture 12 :
  • Project Demo - connecting to remote server
  • Lecture 13 :
  • Code Review

Section 4 : Step 3 - WampServer - Hosting your own Web Server !

  • Lecture 1 :
  • Introduction
  • Lecture 2 :
  • Apache, PHP and MySQL
  • Lecture 3 :
  • Download & Install
  • Lecture 4 :
  • Getting started with WampServer
  • Lecture 5 :
  • Basic Server Configuration

Section 5 : Step 4 - MySQL Database - Storing Data Somewhere…

  • Lecture 1 :
  • Introduction
  • Lecture 2 :
  • What is a Database ?
  • Lecture 3 :
  • MySQL Tools
  • Lecture 4 :
  • Using phpMyAdmin Console
  • Lecture 5 :
  • SQL Statements
  • Lecture 6 :
  • Testing our Project Database

Section 6 : Step 5 - PHP - Running Scripts at the Server

  • Lecture 1 :
  • Introduction
  • Lecture 2 :
  • What is PHP ?
  • Lecture 3 :
  • Basic PHP Syntax
  • Lecture 4 :
  • PHP Extension to MySQL - Introduction
  • Lecture 5 :
  • mysqli - Establish Database Connection
  • Lecture 6 :
  • Insert Data
  • Lecture 7 :
  • Insert Data - PHP Scripts Testing
  • Lecture 8 :
  • Query Data
  • Lecture 9 :
  • Query Data - PHP Scripts Testing
  • Lecture 10 :
  • MySQL Error Handling
  • Lecture 11 :
  • MySQL Errors Simulation

Section 7 : Step 6 - Final Project - Web-based Datalogger

  • Lecture 1 :
  • Introduction
  • Lecture 2 :
  • Connecting the Arduino to the Web Server
  • Lecture 3 :
  • Final Project - Checklist and Demo

Section 8 : Course Summary

  • Lecture 1 :
  • What Did We Covered ?
  • Lecture 2 :
  • What Next ? Level 4...

Ethical Hacking and Penetration Tes...

By : Darshil Modi

Lecture 21

$21

Implementing & Configuring Cisco Ro...

By : Dariusz Lipski

Lecture 10

$25

Learn NxtGen Hacking with Technolog...

By : Gopikrishna C

Lecture 80

$14

Google TensorFlow Hands on with Pyt...

By : UNP United Network of Professionals

Lecture 51

$21

CISSP- Certification Introduction

By : MUKESH SINGH

Lecture 18

$14

Complete Ethical Hacking & Penetrat...

By : Abhilash Nelson

Lecture 29

$14

Need any help with the platform? Contact us at: support@learnfly.com