Creating your own IoT Cloud from scratch using php, Mysql, ESP12E

Creating your own IoT Cloud from scratch using php, Mysql, ESP12E
Featured

Creating your own IoT Cloud from scratch using php, Mysql, ESP12E

Introduction

In this tutorial series we will be Creating your own IoT Cloud from scratch using php, Mysql, ESP12E (NodeMCU). Creating your own IoT cloud from scratch requires end to end integration. I have divided this tutorial into four chapters. Each chapter will contain a detailed video for the tutorial on integrating php, Mysql, ESP12E (NodeMCU). And every tutorial is provided with complete code and instructions wherever required.

(Note : If you are not familiar with ESP12E NodeMCU then I will suggest you to go through the below tutorials first :

Chapter 1 - Getting Started with ESP12E Node MCU Wifi Development Board
http://iotmonk.com/courses/getting-started-with-esp12e-node-mcu-wifi-development-board/

Chapter 2 - Controlling Esp12E NodeMCU with LED from website (local network)
http://iotmonk.com/courses/controlling-esp12e-nodemcu-with-led-from-website-local-network/

Chapter 3 - Controlling Esp12E NodeMCU with LED from website using thingspeak from anywhere in the world
http://iotmonk.com/courses/controlling-esp12e-nodemcu-led-website-using-thingspeak-anywhere-world/

Chapter 4 - Read temperature and humidity from nodemcu ESP12E with DHT11 and show it on HTML webpage(Local)
http://iotmonk.com/courses/read-temperature-humidity-nodemcu-esp12e-dht11-show-html-webpage/

)

  1. Setting things up

    1. Creating Free account on to host our php api, mysql database and webpages.
    2. Introduction to hosting platform and creating a new Mysql database and getting database username  and password
  2. Creating php api ( php, Mysql, ESP12E (NodeMCU) )

    1. Creating a new table for ‘weather’ channel to insert ‘temperature and humidity’ sensor data in the database.
    2. Then creating a new table for ‘LED’ to control LED of ESP12E or NodeMCU from a webpage
    3. Creating php REST api to insert, delete, read and update data in database.
    4. After that, Testing api from POSTMAN tool.
  3. Programming ESP12E or NodeMCU Module to insert DTH11 data through REST

    1. Creating a program to insert DHT11(Temperature & Humidity) sensor data to our mysql database using  REST api.
    2. Reading the ‘Temperature & Humidity’ data from mysql database using REST api on a webpage using  HTML, CSS, JAVASCRIPT & Jquery
  4. Control LED connected to NodeMCU using php REST api

    1. Creating a program to read ‘LED’ status as ‘on’ or ‘off’ from php api using ESP12E or NodeMCU.
    2. We will be creating a webpage with buttons to change the status of the LED connected to ESP12E or NodeMCU using php api and then hosting it on the server.

We will be making free account on a popular website which we will be using to host our php, Mysql, ESP12E apis and html pages.

Prerequisite

Softwares:

  1. Arduino IDE
  2. You should have cny code editor like Notepad++ or Visual Studio.

Hardware:

  1. ESP12E or NodeMCU - 1
  2. DHT11 Temperature &Humidty Sensor - 1
  3. 10 K resistor - 1
  4. Breadboard - 1
  5. LED - 3 & Wires, wire stripper, nose plier etc.

Good to have:

  1. Basic Knowledge of ESP12E or NodeMCU with Arduino.
  2. Introduction Knowledge of REST api - GET, POST request.
  3. hands on basics of HTML.
  4. Little (Not compulsory) Knowledge of Javascript

If you don't have the components, you can buy it from the below links (Most of the general components like LED and wire, you can easily get from local market. I am just listing out the important and specific components).

For USA

DHT 11 Temperature and Humidity Sensor : DHT11 Digital Temperature and Humidity Sensor NEW
Half Size Breadboard :Solderless Breadboard with 400 Tie-Point (White)
Micro USB Cable : Universal Micro USB Flat Data Cable -Rock Original-Grey
ESP12E Node MCU development Board : ESP12E Node MCU development Board

For India

DHT 11 Temperature and Humidity Sensor : SMAKN DHT11 / DHT-11 Digital Temperature and Humidity Sensor
Half Size Breadboard :Solderless Breadboard with 400 Tie-Point (White)
Micro USB Cable : Universal Micro USB Flat Data Cable -Rock Original-Grey
ESP12E Node MCU development Board : ESP12E Node MCU development Board

Click on any of the below lessons to start.

, , , , , , , , , , , , , , , , , , , , , , , , , ,