Using Ethernet Shield to Send ARDUINO Sensors Data to a MySQL Database and Display It on a Website With PHP, HTML & CSS

For this, you will need to have basic knowledge on Arduino Programming, MySQL, PHP, HTML & CSS (optional)...

Step 1: Things You Will Need

Arduino Development Board (Arduino Mega 2560 Recommended)

Arduino Ethernet Shield

A Wireless Router with Internet Connection

Cat 5 RJ 45 Connector Network Cable (any other can work) (check the images and pick one)

3 Male - Female Jumper Wires and some Male To Male Jumper Wires

A Web Hosting Account (get a fee one at 000webhost.com or 0fees.us, i used 000webhost.com)

DHT 11 / 22 Temperature Sensor

LCD 16X2 LCD Display

A Breadboard

MySQL Connector Library (Download from github Thanks to ChuckBell)

I got the hardware from amazon and I am sure they still have some more... :-)

Step 2: Connecting Things Together

The Ethernet Shield

Stack The Ethernet Shield over the Arduino Mega Board. (make sure all the pins are in their respective holes)

The DHT 22 Sensor

Connect the +pin (left most) to the +line(red Line) at the edge of the breadboard

Connect the -pin / Ground pin(right most) to the -line (Blue line) at the edge of the breadboard

Connect the out pin to digital pin 2 of the Arduino

The LCD

Connect as follows

Pin 1 (VSS) -> Pin 16(K) To the ground of the breadboard

Pin 2(VDD) -> Pin 15(A) To the +line of the breadboard

pin 3(VO) Through a 1kohm resistor to the ground

Pin 4 (ES) To the Arduino 32

Pin 5 (RW) To the Ground

Pin 6 (E) to the Arduino 30

Pin 11 (D4) to the Arduino 28

Pin 12 (D5) To the Arduino 26

Pin 13 (D6) To the Arduino 24

Pin 14 (D7) To the Arduino 22

The Breadboard

Connect the Red Line of the breadboard to the 5V of the Arduino

The Blue Line to the Ground

Step 3: Deploying

Download the zip file and extract it

copy the ev folder into the htdocs directory of your web server

goto the browser and type in localhost/ev/setup.php

the script will setup the sql database and tables

goto the codes folder and

open the ev.ino file in arduino and upload to the arduino mega board

set the baud rate to 115200

when it is done uploading and everything is connected properly

you

Step 4: The Working

If you like this project please vote me up and hit the like button...

Comments

[VitruviusB]

The INSERT QUERY was not included in the source code, how did you implement it?

[mkhannn]

Hello
please make video all this process
i am confuse i don't know where i pack MySQL library and php files and i also use windows 10
please give me tips what to do

[AzizS25]

Thank you Sir,

Could you please send the complete code to this e-mail : [e-mail]

If I want to send the data to a website using ASP.net what is the possible change could be made?

[EdrisaT1]

It's possible... But please inbox me

[jisaac6]

Please I am a novice on Arduino still practicing. I want help to write a code to monitor a battery bank of 24V (A0 probably), an AC 230V (A1 probably), an auxillary ac volt 230V AC (A2 probably), temperature and humidity probably A3/A4. Also would want them accesible on the web remotely and possible in graphical and block form.

Please how do i start or how can i achieve this please. my email: [e-mail]

[EdrisaT1]

Please inbox me

[JorgeG239]

Little help here, im using ubuntu 18.04, with arduino IDE 9.0 beta, i have a "Connection failed..." problem, im using MariaDB since all the lamp tutorials i saw use mariadb instead of mysql, as far as im concerned they are almost the same, back to the point im trying to comunicate arduino with php, a simple led control interface from php to arduino and arduino sending data to php, via serial port or ethernet shield pref.

Your example is amazing and its just what i need, i suspect my problem is probably at database, please any tips, help its gratefully acepted.

[e-mail]

[EdrisaT1]

Inbox me

[zeesh1979]

your arduino code is incomplete. one file has just output. other file is not using ethernet functionality. you are just displaying data on LCD. attach correct file please...i am waiting

[EdrisaT1]

what file do you want please

[Celamon]

the ev.ino file is not a sketch, it is just a data post

[emmanuel.ani]

Hi Edrisa, can you pls send me all your code including the main arduino code you used to complete this particular project.

kindly send it to this email [e-mail]

Thanks

[dobro7]

Is there any way I could get a copy of the main.ino file? I am new to this and would like to see how to implement the INSERT function from the Arduino to the web server.