In this tutorial, we will be Creating your own IoT Cloud from scratch using php, Mysql, ESP12E. This is part 2 of tutorial series. If you are seeing this tutorial directly then I will recommend you to read the Introduction of this tutorial first.
Part 2 of " Creating your own IoT Cloud from scratch using php, Mysql, ESP12E ", We will be creating two tables named 'weather' and 'led' respectively. We will use weather table to store the temperature and humidity coming from a DHT11 sensor using nodemcu. The table led will be used to control the three LED connected to our ESP12E. Then we will insert some dummy data into database.
We will finally create php api to insert, delete, update, read data into our mysql database. In the first part we already created the database and acquired database username, database password, database name and host. This is going to be useful for our database configuration file.
(Important : For those who have already gone through first part of this tutorial. To avoid confusion, I am giving the index of this chapter with information for this chapter.
- Chapter 2 - Detailed introduction, instructions and full video of the tutorial.
- Chapter 2.1 - Source Code of weather updating php api.
- Chapter 2.2 - Source code of led controlling php api.
Also we will be making the code for the api. The code will be made in php. I have given separate files, which you can copy and paste and use it for your own research or project.
Please watch the below video. I have explained step by step process to create database and create php apis along with detailed explanation of each and every api.
You can find the codes mentioned in the video in the following links:
Support me by by subscribing to my YouTube channel by hitting the below button.