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

Creating your own IoT cloud from scratch using php, Mysql, ESP12E – Part 2.2

Introduction

This is Part 2.2 of  "Creating your own IoT cloud from scratch using php, Mysql, ESP12E ".  If you are seeing this tutorial directly then I will recommend you to read the Introduction of this tutorial first.

So in the previous chapter, you already have seen the video and the code of weather api. In this chapter, you will get the source code. Simply follow the instructions step by step in the video and the instructions in the below code.

(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.

  1. Chapter 2 - Detailed introduction, instructions and full video of the tutorial.
  2. Chapter 2.1 - Source Code of weather updating php api.
  3. Chapter 2.2 - Source code of led controlling php api.

)

Code

Below php api is for 'weather' table.

1. Create new folder inside 'api' folder and name it as 'led'.

2. Inside the LED folder, copy and paste the below code in any code editor, and save it as 'dbconfig.php'. Don't forget to replace your database credentials in the below code.

3. Then copy and paste the below code and save it as 'db_connect.php'.

4. Save the below file as 'update.php'.

5. After that copy and paste the below code and save it as 'read_all.php'.

 

Support me by by subscribing to my YouTube channel by hitting the below button.

youtube-iotmonk-subscribe

 

Please login to get access to the quiz
Creating your own IoT cloud from scratch using php, Mysql, ESP12E – Part 2.1 (Prev Lesson)
(Next Lesson) Creating your own IoT Cloud from scratch using php, Mysql, ESP12E – Part 3
Back to Creating your own IoT Cloud from scratch using php, Mysql, ESP12E

Comments ( 2 )

  • Alex

    very nice your tutorial. but you can continue it … it would be nice to save the temperature and humidity from minute to minute to make a chart with date, time and sensor values.

    • Thank for appreciation alex. This tutorial is high level designed specifically for beginners. Right now, I am not planning to extend it but thanks for the suggestion. If I get more requests to continue this tutorial, I certainly will. As if now, I am focused on making tutorials on integrating IoT with machine learning. If people request me the same in comment section of my youtube channel, I will certainly think about it. Here is my channel link : https://www.youtube.com/user/vikkey321/videos?view_as=subscriber

Post a Reply