Send Temperature & Humidity Data from Arduino(Ethernet Shield) to Public MySQL by ngrok & PlatformIO

Welcome to our tutorial on sending temperature and humidity data from an Arduino with an Ethernet shield to a MySQL server(phpmyadmin) using PlatformIO and ngrok! In this video, we'll guide you step-by-step through the process of setting up your Arduino, configuring the necessary software, and making your local server accessible from anywhere using ngrok.

What You'll Learn:
Setting Up the Arduino with Ethernet Shield:
Install the DHT sensor library.
Connect the DHT sensor and Ethernet shield to the Arduino.
Write and upload the code to read temperature and humidity data and send it over Ethernet.
Using PlatformIO in VS Code:

Install and configure PlatformIO IDE in Visual Studio Code.
Manage libraries and dependencies with PlatformIO.
Configuring MySQL and PHP:

Set up a MySQL database and create a table for storing sensor data.
Write a PHP script to insert data into the MySQL database(phpmyadmin).
Host your PHP script on a local server using XAMPP.
Making Your Localhost Public with ngrok:

Install and configure ngrok.
Securely expose your local server to the internet.
Update your Arduino code to send data to the public URL provided by ngrok.
Requirements:
Arduino board (e.g., Uno, Nano) with Ethernet shield
DHT11 or DHT22 sensor
Ethernet cable
Computer with Visual Studio Code installed
PlatformIO IDE extension
XAMPP local server environment
ngrok account (free tier available)
Code and Resources:

Additional Resources:

Timestamps:
0:00 - Introduction
1:20 - Setting Up XAMPP
3:00 - Hardware Setup
6:50 - Understanding the XAMPP Control Panel
10:00 - Creating a Database in phpMyAdmin
13:55 - PHP Script Explanation
18:05 - Manually Inserting Sensor Data
19:30 - Writing Code in PlatformIO (VS Code Editor)
24:00 - Compilation
25:26 - Code Explanation
31:10 - Uploading the Code
33:25 - Using ngrok to Make Local IP Publicly Accessible

If you find this video helpful, please give it a thumbs up, subscribe to our channel, and hit the bell icon to get notified about our latest tutorials. Feel free to leave any questions or feedback in the comments below.

Follow Us:

Thank you for watching!

Tags

- Arduino
- MySQL
- PlatformIO
- VS Code
- VS Code Editor
- ngrok
- DHT sensor
- Temperature and humidity sensor
- Arduino tutorial
- IoT
- Internet of Things
- Data logging
- PHP MySQL
- Localhost server
- XAMPP
- Remote server access
- Arduino project
- Coding tutorial
- DIY electronics
- Sensor data
- Arduino IDE
- PlatformIO tutorial
- Web development
- Database
- Public server access
- Arduino data logger
- Arduino and MySQL
- Arduino sensors
- Real-time data logging
- Arduino coding
- Arduino with PHP
- Arduino with ngrok
- Arduino beginner project
- Environmental monitoring
- Arduino data transmission
- Ethernet shield
- Arduino Ethernet shield
- Networking with Arduino

Hashtags

#ArduinoMySQL
#ArduinoEthernetShield
#PlatformIOIDE
#VSCodeEditor
#ngrokIntegration
#TempHumiditySensor
#IoTProject
#DIYIoT
#SensorDataLogging
#MySQLDatabase
#ArduinoTutorial
#EthernetConnectivity
#RemoteServerAccess
#ArduinoDataTransmission
#PlatformIOTutorial
#ArduinoDHTSensor

[khant-nyar]

i want to learn Arduino and node(nest prefer) js without physical component (because our country have ministry coup since 2021)
it can be ?