Arduino is sending dht11 data to MySQL server(PHPMYADMIN) using python

preview_player
Показать описание
In this project we are going to send dht11 data to phpmyadmin, here we are not using any ethernet shield so we are just getting data from UART to PC and through one python code we are pushing that serial data to phpmyadmin.

You can buy tools from amazon, below are the links:

  1. Embedotronics Technologies
  2. phpmyadmin
  3. mysql server
  4. python
  5. arduino
  6. arduino with dht11
Рекомендации по теме
Temperature and Humidity 0:10:17

Temperature and Humidity Monitor using Arduino IOT Cloud and ESP8266

Modules for Arduino 0:00:23

Modules for Arduino Beginners: DHT11 Temperature and humidity Module #arduino #dht11 #engineering

Arduino IDE + 0:25:57

Arduino IDE + ESP32 + Google Sheets | ESP32 with Google Sheets (Writing Data and Reading Data)

How to Send 0:10:02

How to Send Humidity and Temperature value to ThinkSpeak using ESP8266 DHT11 sensor module Arduino

Arduino IDE + 0:28:03

Arduino IDE + ESP32 + PHP + MySQL Database + XAMPP | ESP32 with MySQL Database (localhost)

Arduino is sending 0:29:04

Arduino is sending dht11 data to MySQL server(PHPMYADMIN) using python

DHT11 Arduino | 0:02:14

DHT11 Arduino | SMS Temperature and Humidity Using DHT Sensor And SIM800L

ESP8266 + Arduino 0:10:31

ESP8266 + Arduino send data DHT11 Humidity and Temp To Web

Arduino Nano logs 0:09:40

Arduino Nano logs temperature and humidity from a DHT11 sensor to an SD card every 1 minutes.

Arduino Bluetooth tutorial 0:06:03

Arduino Bluetooth tutorial (HC-05): Send the room temperature to Android using the DHT11 sensor

Getting data from 0:00:22

Getting data from DHT11 sensor through SIM900 GSM Shield with Arduino #arduino #electronics

How to send 0:15:25

How to send sensor dat to thingspeak server using ESP and Arduino.

04 Easy IoT 0:37:15

04 Easy IoT project w/ Arduino IoT Cloud - ESP32 | DHT11 Humidity & Temperature | Relay & DC...

Arduino DHT11 sensor 0:00:24

Arduino DHT11 sensor projects #shorts

DHT11 & NodeMCU 0:06:01

DHT11 & NodeMCU Tutorial || Humidity & Temperature Monitoring over Thingspeak

How to send 0:14:32

How to send Arduino Sensor values to Phone | Printing Real time temperature on phone using HC05

DHT11 + Arduino 0:00:12

DHT11 + Arduino + PHP + MySQL

DHT11 temperature and 0:04:11

DHT11 temperature and humidity sensor with Arduino [code explained] | Arduino tutorial 15

DHT11 Temperature & 0:05:17

DHT11 Temperature & Humidity sensor with Arduino - Tutorial

Sending Temperature and 0:28:32

Sending Temperature and Humidity Data to MySQL Server(PHPMYADMIN) using Arduino

Sending Data from 0:09:11

Sending Data from an Arduino to Python | Pyserial | DHT11

Arduino WiFi Shield 0:00:39

Arduino WiFi Shield + DHT11 Sensor Data sent to Google Spreadsheet

How to store 0:04:12

How to store Temperature data in Google Spreadsheet

Arduino with ThinkSpeak 0:05:39

Arduino with ThinkSpeak | Monitoring IoT data over ThingSpeak | ThingSpeak with esp8266 | 2024

Комментарии
Автор

I am using python 3.8.3 and XAMPP 1.8.3. It is not allowing me to insert the records in to DB.
getting the below message.
cursor.execute("""INSERT INTO dht11serial (humidity, temperature) VALUES (%s, %s)""", 70.0, 32.0)

It gives the below:

<generator object MySQLCursor._execute_iter at 0x03A62D10>
Please suggest. Thanks!

soumyaranjanmahapatra
Автор

how can you retrieve the data and plot them in matplotlib?

Kennerdoll
Автор

I have downloaded xampp and even started mysql still then when I run my code in python it shows SQL module not found. What should I do?

WowVinnu
Автор

using those data how can we make a graph in our website please show us .

grandmetallic
Автор

Can you please share the python code? Thanks :)

ContinuousInfinity
Автор

hey the video is really very helpful and detailed, i am working on a similar project can you help me! this code is for only one sensor actually i m working with multiple sensors and when i make changes in the code it is failing to receive data from COM port can u help please.

vaishugotmare