IOT - Smart Jar Using ESP8266 , Arduino and Ultrasonic Sensor Publishing Data in Local Server

Hello All ! Thanks For Viewing our Instructable . In this Instructable We will Show you the Steps for Making a prototype Like this . Here we are Creating a Database in Localhost Server . A link is made to communicate the ESP8266 to the DB through PHP Script . And the Details are displayed in another PHP Script . Please download the Images and view it properly ., because we have provided Photos so you can See it offline too . Happy Learning !

Teacher Notes

Teachers! Did you use this instructable in your classroom?
Add a Teacher Note to share how you incorporated it into your lesson.

Step 1: Things Needed for Making a Smart Jar

As explained in the Introduction this Product is a Basic Prototype . It Doesn't Require Costly Elements . The Following are the Things and Software Needed to make this ! Happy DIYing !

Components :

  1. Arduino UNO
  2. Ultrasonic Sensor
  3. A Empty Jar ( Plastic or Transparent is Recommended )
  4. Bread Board
  5. Main Guy : ESP8266 (Wifi Module )
  6. Jumper Wires (15 - 20)
  7. Program loading Cable
  8. Resistors ( 2K ) - 2 Nos

Software :

  1. Arduino IDE
  2. Sublime Text or Notepad ++
  3. Apache Server or Any Hosted Server
  4. Mysql Database

Step 2: ESP 8266 and Ultrasonic Sensor Connection

The Above Image will Clearly explain the Connections For The ESP 8266 and Ultrasonic Sensor with Arduino .

Step 3: Programming Arduino for ESP and Bluetooth

#include <SoftwareSerial.h>

SoftwareSerial esp(2, 3);

long duration ;

int distance;

void setup() {

// put your setup code here, to run once:

Serial.begin(9600);

esp.begin(9600);

esp.println("AT");

response(3000);

esp.println("AT+CIOBAUD=9600");

response(1000);

esp.println("AT+CWMODE=1");

response(2000);

esp.println("AT+CWJAP=\"Wifi Name SSID \",\"Wifi Password\"");

response(10000);

pinMode(9,OUTPUT);

pinMode(10,INPUT);

}

void loop() {

// put your main code here, to run repeatedly:

digitalWrite(9,LOW);

delayMicroseconds(2);

digitalWrite(9,HIGH);

delayMicroseconds(10);

digitalWrite(9,LOW);

duration = pulseIn(10,HIGH);

distance = duration*0.034/2;

esp.println("AT+CIPSTART=\"TCP\",\"Your IP Address\",80");

response(5000);

esp.println("AT+CIPSEND=80");

response(2000);

esp.print("GET Your Link with the IP address You Used ");

esp.print(distance);

esp.println("\r\nabcd1234");

response(5000);

}

void response(int waitTime) {

for (int i = 0 ; i < waitTime; i++)

{ if (esp.available() > 0)

{ char x = esp.read();

Serial.print(x);

}

delay(1);

} }

Step 4: Website Programming - Inserting Data

The Following Code is to Typed in Text Editor . It is the Code for Inserting data into Database .

Step 5: Website Programming - Displaying Data

Please Refer the Image for the Code of Displaying Values .

Step 6: Setting Up the Database - I Have Used PHPMyAdmin Pannel

This is a General GUI . If you have doubts in SQL . Feel free to mail us at santhoshnarendra@gmail.com With Subject Instructable - Smart Jar .

Step 7: Done ! Time to Test

Please make sure you use the correct Baud Rate . If ESP8266 gives error We request you to set the baud rate properly . For any further queries don't hesitate to Mail UsThanks for Following the Steps .

Project Made By

Narendra Santhosh N <santhoshnarendra@gmail.com>

Ajay Karthik K <ajaykarthikkasinaathan14@gmail.com>

Subash C

Be the First to Share

    Recommendations

    • CNC Contest

      CNC Contest
    • Make it Move

      Make it Move
    • Teacher Contest

      Teacher Contest

    6 Discussions

    0
    None
    Bhargav007

    2 years ago

    please can someone help??

    mail id :- bhargavauden1998@gmail.com

    0
    None
    Cancerianb

    2 years ago

    Hi,

    Nice project . I got some errors in it Please help me . Firstly connection error ,and secondly i think webpage is not complete . Please share full code of webpage and connection .Thanks

    1 reply
    0
    None
    Bhargav007Cancerianb

    Reply 2 years ago

    can you help me please

    mail id: bhargavauden1998@gmail.com

    i dont know what to do after connections

    0
    None
    JayaC4

    3 years ago

    Really proud of you.Inspiration for a reason! Keep going :)

    0
    None
    BowrnikaK

    3 years ago

    Hi santy..its adorable!!as you are progressing in betterment of ur career.. Really appreciate you!! Hope ur best is about to reach u... My hearty wishes for ur innovations..keep going!!

    0
    None
    seamster

    3 years ago

    Very nicely done, thank you for sharing :)