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

Want to learn more?
Go for Premium Subscription

Choose your plan:

  • Monthly
  • Annually
$ 29
Monthly Subscription
  • Access to all courses
    You will be able to access all the courses from any category on the platform.
  • Learning paths access
  • Access Assignments & Projects
  • Access on Mobile, PC and Tablet
  • Pause & Resume Courses Anytime
  • Offline viewing
  • Instructor Support
  • Course Completion Certificates
  • Cancel Anytime
Subscribe Now
$ 299
Annual Subscription
  • One year Unlimited Access
  • Access to all courses
    You will be able to access all the courses from any category on the platform.
  • Learning paths access
  • Access Assignments & Projects
  • Access on Mobile, PC and Tablet
  • Pause & Resume Courses Anytime
  • Offline viewing
  • Instructor Support
  • Course Completion Certificates
  • Cancel Anytime
Subscribe Now
Need Help?

Call +1 855 999 1795

( Toll Free )
  • 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...
crazy-about-arduino-level-1-the-complete-guide-for-beginners

Crazy about Arduino - Level 1 - The...

By : Idan Gabrieli

Lecture 66

crazy-about-arduino-level-2-building-a-cool-end-to-end-arduino-project

Crazy about Arduino - Level 2 - Bui...

By : Idan Gabrieli

Lecture 57

Buy

$15

Enjoy Limitless Learning. Get Access to Unlimited Courses with Premium Subscrption Subscribe Now