ESP8266 + Arduino + database - Control Anything from Anywhere
Vložit
- čas přidán 7. 08. 2024
- $2 for 5PCBs (Any solder mask colour): jlcpcb.com
Make a WIFi connection, uplaod the PHP files and send and get data from an online database and by that control anything from anywhere in the world with WiFi connection. The options are limitless... Just have an idea...
Help my projects on Patreon : / electronoobs
my Q&A page: electronoobs.com/eng_preguntas...
Facebook page: / electronoobs
Canal en Español: / electronoobs en español
LINKS
-------------------------------------
Tutorial website :electronoobs.com/eng_arduino_t...
Schematic: electronoobs.com/images/Arduin...
Project ZIP file: electronoobs.com/images/Arduin...
000Webhost: www.000webhost.com/
🔬PRINTERS FDM
-------------------------------------
Artillery Sidewinderr X1 (364€ Aliexpress): s.click.aliexpress.com/e/_9y9haI
Artillery GENIUS (307€ Aliexpress): s.click.aliexpress.com/e/_A9SvG2
Creality3D Ender 3 Pro (230€ Aliexpress): s.click.aliexpress.com/e/_APcCa2
Anycubic Mega S (206€ Aliexpress): s.click.aliexpress.com/e/_ALcTLs
ELEGOO NEPTUNE 2 (186€ Aliexpress): s.click.aliexpress.com/e/_AM2y7c
Prusa i3 MK3S Clone (393€ Aliexpress): s.click.aliexpress.com/e/_ASNXyi
Creality CR-10 V3 (480€ Aliexpress): s.click.aliexpress.com/e/_AnycCO
🔅PRINTERS RESIN
-------------------------------------
ELEGOO Mars Pro (208€ Aliexpress): s.click.aliexpress.com/e/_A0nVFY
ELEGOO Saturn MSLA (480€ Aliexpress): s.click.aliexpress.com/e/_AKxJim
Anycubic Photon Mono (199€ Aliexpress): s.click.aliexpress.com/e/_9ulv4K
Creality HALOT ONE (275€ Aliexpress): s.click.aliexpress.com/e/_Ak7jBC
Like share and subscribe to motivate me. Thank you
#ESP8266
#Arduino
#IOT - Věda a technologie
Follow me on FACEBOOK for more: facebook.com/Electronoobs
help me on Patreon: www.patreon.com/ELECTRONOOBS
Te olvidas de el canal hispano :")
i have connected everything correctly but it does not work. when i open my serial monitor it keeps spitting out: 17:22:58.002 -> `f⸮⸮f⸮f~⸮⸮⸮⸮⸮f⸮f⸮⸮⸮f⸮⸮timeout 1 17:23:07.026 -> ESP CHECK FAILED 17:23:12.084 -> timeout 1 17:23:12.084 -> ESP RESET FAILED 17:23:17.122 -> timeout 1 17:23:17.122 -> ESP CWMODE SET FAILED 17:23:27.236 -> timeout 1 17:23:27.236 -> ESP SSID SET FAILED 17:23:27.275 -> CHECKING FOR AN IP ADDRESS 17:23:37.353 -> timeout 1 17:23:37.353 -> IP ADDRESS FAILtimeout 1 17:23:42.396 -> ESP CIPMUX SET FAILED 17:23:42.429 -> CONNECTING 17:23:47.517 -> timeout 1 17:23:47.517 -> FAILED TO CONNECT 17:23:52.560 -> timeout 1
i don't know how to fix this
please help.
@@skyevanderheijden5382 me too the same my error
I also had same error please help me to fix it
@@skyevanderheijden5382 Have you fixed this issue? I have the same issue but i think you need to make some changes in the code or something. I think you need to put some text in the serial monitor but I havent figured it out yet.
Thank you for properly explaining things from start to end.. Most CZcamsrs assume people already know about PHP or making a web site, but I do not as I am sure others. So again, thank you for taking the time and doing it properly.
Now I don't know if anyone has spotted this. There is a ***MISTAKE*** in the schematic at 8:11 in the video. The voltage divider is wrongly connected to the Rx pin of the 8266 and pin 11 of the Arduino MEGA. One must disconnect: 1) upper terminal of the 1k resistor from pin 4 of the 8266 and 2) cyan wire from pin 11 of the MEGA and switch them over i.e. the cyan wire goes to the 8266 pin 4 and the upper terminal of the 1k resistor goes to pin 11 of the MEGA. If you leave it as is, no voltage dividing is accomplished and the full 5V level is applied to the Rx pin of the 8266; this can stress the ic to unknown results. Having said that, CONGRATS for one more great video and project!
great video, was able to create the website and uploaded and edited the files and had it working in about a half hour. Your instructions were perfect, thanks. Now I have to do the Arduino stuff.
One of the best channels I’ve ever found. Very grateful for your videos. Greetings from USA.
Seriously your videos really amazed me and I always waiting for your videos...God bless YOU...love from India
Thanks for sharing! This project really opens a wide range of possibilities.
Hai.. do u have the sample code for this project.???? Can u help me please???
@@trashk1483 The link to the tutorial is in the description. The tutorial webpage has a zip file which contains all the .ino files mentioned in the video.
If I had some money I will support you in Patreon man!
Keep the good work!
Great work. Very precise and informative tutorial guides. Lots of thanks
Informative video. Definitely helpful with an IoT project. Time to brush up on AMP in the LAMP.
After that I feel like adding a video on how to host a website on a server and how to make the server in less than ten minutes. But I'd also have to address the firewall and poet forwarding so it was world wide enabled.
Good bit of work there!!!
Hello Sir, I have been learning arduino lately and I've been lead in my search to this video to try next. I have experience in front and back end web dev (including PHP), so I'm excited to put that knowledge together with Arduino to make something really interesting.
This is a very cool and informative tutorial that is easy to understand and super helpful especially the files in the description. Keep up the good work!
this is the needle in the heystack i been searching for! perfect vid!!
Subscribed because finally somebody provided a banana for scale
Hi, Thanks for sharing, the video has great quality both information and visuals, GREAT
I really enjoy watching your video's and the stuff you make is really awesome.
thanks for the shout out!
Thanks a ton !
I don't find enough words to thank you. Your's is the first video Ihave ever seen on this topic that is all - descriptive enough yet in simple but precise language ! Keep up the work.
Do you have any similar tutorial for Arduino Uno as well ? What will be the differences, at list ?
Thank you for your knowledge.
It provided a solution to my problem
Some almost 13 minutes that are very worth it! Thank you so much 🙂
mine doesnt work. Can you maybe send me your code. then i try if your code does work on mine
@@thijsschrooten9843 I haven't done it yet, I meant the video is worth the time. But I'll work on it this week and update you.
@@a332pilot lmao its been 2 years bro u good?
Hey, really nice work man.
Can you tell me how we can upload multiple Arduino code to a single Arduino?
Will the previous uploaded code get deleted?
Very helpful tutorial 😊. Thank you ❤️
“Easy but difficult project”
Me: (wipes spat coffee off screen)
xD
Really interesting!!! 😃
Thanks!
Thank you so much! I am going to make best friends lamp for distance relationships. Your tutorial is the best one I saw on CZcams! I appreciate your work. Good luck with your channel. Subscribed
thats also why im here, did it work for you?
@@fridolineckerd6135 i decided not to do this😂
Very nice and detailed explanation and example. Thank you
Excellent, works like a charm now I’ll code it for nodemcu and just a couple sensors and home automations is in the bag! Thanks
Hi sir, tell me if you understood about the topic, send me your email address
Hello, were you able to code it for nodeMCU?
wow, that was really helpful. Thank You.
hi, sorry im using sp01 but still not working "ESP CHECK FAILED
" I cant set up the ESP01 trought the arduino mega.i have the USB programer for the sp01.
hello so the way esp(client) recieves data orders from the server is by checking the database .
doesn't that consume a lot of network ressource since it needs to check periodicly!
and isn't there any way to make our servers send data via http to esp ?
Yes, you can. You have to use mqtt(in place of http requests), that would work in publish subscribe model, so your esp can subscribe to a topic and will get notified when your app will publish on that topic.
Thank you so much! You're the best!
Thank you, great job, but why webpage, we are in time of mobile apps, what about nodemcu it has a wi fi adapter
Have you tried socket programming (using IPv6)? I presume that would be much faster than using a web app for this task. There's a lot of overhead involved in the management of web requests, right!
Hello, sorry for the basic question, but how can i uplooad multiple files to the arduino ? I will try to alter your project a bit , to use a server i rent over the internet, from linux, which im configuring, do you think that i will have much complication ? I will try to make the arduino insert the info on my db , and control it on another webpage that i made. This is because i have a college project to make im trying to guide myself by your project in order to do something similar .
You are my hero, never forget!
dang.. the next level IoT tutorials.. it's sophisticated !!
You are such a great electronics engineer
Love you 😘❤️😘😘
sir, have you made arduino for control motor 1 phase like fan from internet?
this is so cool, thank you for the explanation
El video esta en español ? evisto algunos tuyos y se que hablas español tambien y quisiera saber si esta en español ya que me interesa mucho tu programacion en PHP y otras cositas
Great video, thanks for all the information..
I placed order for one emmediatly I sow this. Thank you.
You worked a lot on it. Thanks for share
Can we now use ethernet port instead ..
Very good project 👍
You saved my day.
Thank you so much
Im an embedded systems engineer and i know how much work goes into something like this ......... It would take weeks to do .......thank you for your work
"Full version" of code will also work on arduino UNO or NANO (ATmega328P) if you store all string in program memory (flash) via "F( )" macro.
e.g.: Serial.println(F("READY TO SEND")); ( or lcd.print(F(...)); )
Like this I reduce the used RAM to 70% (595 bytes left).
Obviously I didn´t test it yet (because I don´t have an ESP Wi-Fi module).
And if it will still cause stability problems you can store other variables (because 45% of program memory are still unused) (e.g.: const char SSID_ESP[] = "..."; const char SSID_KEY[] = "..."; ...) via PROGMEM macro.
e.g.: PROGMEM const char SSID_ESP[] = "...";
but you will need to write a little bit of code e.g.: for(i=0; i
YO THANK you bro i been looking for something like this. Ima try it out. But would I have to make these changes by looking through EVERY LINE of code? or is there a faster to make these changes
huge help!
i don't have Arduino mega i have Arduino uno so is it possible to give me simple example about how to turn 4 leds on and off also get the leds status if its on or off.i tried your example on arduino uno but i got error message "Not enough memory"
why it dont work? I did all the things. but it shows me a page and this "You see this page because your website doesn't have "index.php" or "index.html" file in public_html folder."
what should i do now
I want to send bme280 and gp2y1010au0f sensor data. Do i need to create variables for these values to send it ?
Wow dude, that's amazing
So is this constantly polling or is there some "push" element?
Hello Sir, This is amazing, I have a question, consider this is what I used for Room #1, what should I do for multiple rooms with the same.?
Beautifully done!
did u tried it?
Thanks for the info, very helpful.
Excellent explanation and video, many THANKS. Hope you make video about STM32 projects with Arduino IDE.
But how safe is it?
Sir can i use only the Text input and send ID number to database for may IOT attendance syem using only Nodemcu Esp8266 and a router
Excellent. Nicely done
Hello Electronoobs! First of all....great work and THANK YOU SO MUCH for all your videos. I'm having trouble with the PHP files and OOOwebhost....apparently the "code" or something is not working anymore. I would appreciate an update on this topic, maybe? It's worth it. Thanks in advance for all your help!
Very cool video!
Question; Is there a way for my phone to receive a push alert when something is triggered on the arduino?
Email tends to be a little slow, sometimes over 15 minutes. I would like to have it alert me immediately.
I want to use this to keep an eye on my fishtank.
Great viddeo, thanks you. Quick question thouhg: I have an Arduino UNO, is there a way I can make it run more effectively on the UNO (eg. code I can snip) as I don't have an Arduino MEGA?
I can't find uno codes too.
Thanks a lot for such great information but I want to ask why banana was kept at the table ?
If I only want the boolean variables, can I use an arduino uno?
Thanks !!
It help me a lot!!
Great appreciation for you sir--
You are awsome thanks for the whole process
Make more videos on this topic
Nice work man
Thanks for this beneficial content :)
will the project work on a NodeMCU alone or does need the Arduino I have a few extra Nodes but not arduinos
Great project. I would love use this project with my ESP8266 NODEMCU instead. But there are too many changes to the code needed and I'm a hobbyist with no idea how to start. Would also like to have a non-latching push button operation. Any help would be greatly appreciated.
hello, i'm currently trying to do the same thing have you ever figured it out?
Hello sir can you please tell me what is the app should be downloaded to control the system. I mean that you are using some app on your mobile to control light that is what Iam asking sir
is it possible to scan data from a QR code to make a device work with respect to the read data?
if so how?
Great Video .. Since the NodeMCU gives both the Connection to the Wifi and has I/O would be nice if you could possibly show how to convert your current project onto NodeMCU.. Just a suggestion :)
Same here
did any of you guys figure that out?
Can work if u use arduino uno??? Secondly can control that system on pc???
Hi! Thnks so much! This is a very very very good tutorial for this kind of purpose, I have a question, maybe another user (if there is such a good soul out there jeje) could answer me. Well, there is my question: Is it functional to use a sensor just connecting in a direct way? I mean For example, the DHT11 just connecting VCC GND and DATA or it is better if I use a wheatstone bridge?
Hello, waht if i only need the switching of light bulbs?? what do i need to edit in the php file? and can arduino uno handle it??
Amazing!!! Thanks for sharing!
Hello my friends,
we need to discuss basic website security
please remember that allowing anyone that can see the website access to change it can result in....unexpected consequences
this becomes even more important when you are controlling mechanical items through the website
a basic password will stop the curious, for the determined, more drastic measures are needed
do not rely on obscurity, that is useless for security
that is all.
I'm a little conflicted; I can host the site locally and just go in via VPN tunnel for best security,
BUT at that point ill have a server in the house already, so why not skip the arduino and use a raspberry Pi.
I wonder if there is a way of making this self contained on the arduino.
It can throw up a basic no frills HTML page and read data directly from its own EEPROM, so it might be possible?
Agree, so much easier and more secure to use an authenticated MQTT broker like cloudMQTT, instead of a public http page.
@@ktaragorn Thats exactly the route I ended up taking. ;)
Can you just create 2 websites :
1) for just the user controls, and
2) another for responding to the user controls? And this is pw protected and responds to user commands?
This way, the user only gets access to #1. Not the meat of the innards which controls safety etc?
(I'm a noob at internet. Just trying to learn....)
@@Official_Baba_yagathanks insane workaround. But u could change your ip and "crack" this method .
thank you for sharing, nice and useful
I like this very much however this is how I would do it.
Arduino, ESP8266 and a Omega2 or Raspberry Pi as the host. Install LAMP on the Pi or LNMP on the Omega2 since it will be the host. Sign up with a DynamicDNS and setup vLan on the router with some port forwarding and you'll have your own IoT server.
Wonder if anyone has made a Arduino to Python Crosscompiler / emulator yet. This way you can just use the Pi or Omega2. Toss in a ZWave Controller and then you could really do some awesome Home Automation with it.
Hello Leland, I have done a project with the method you recommend. The advantage is that response time is much less. However somehow router stopped forwarding to assigned ports. To avoid router problems, one of the outputs is recycling router daily. So currently with DDNS service set on camera dvr, I get the ip address daily. But as port forwarding doesn’t work, I cannot access ardunio. Well, currently I’m 1000 km a way from router and cannot set back the port forwarding. So only way to fix this problem is replacing router with a remote control feature or to have a pc running teamviewer or logmein on it. Both options are costly. So as a result, I will have to update my ardunio that will run over a server database on internet. So if you are able to be near the router, your method is fine as you could fix issue on the place. But if you are a way and have a chance to set router settings once a year, Best to have a control over server database.
Do you have a sloution with an App for android instead of a homepage? The two-way-communication is necessary for my project. I want to send commands and receive data with the app.
awesome proyect!!! I think you could make the script using Python! that is way too easy compare with Php ☺️- a lot of libraries for this job! hello from 🇦🇺👋🏼
so gooooooood
Would I be able to send a web link to select a certain function to run within my Arduino code? I have a led strip with some preset modes and would like to be able to change them via a web link on my phone?
I am intending to work on esp8266 and my question is about how can someone learn it and programming it.But it seems like using ready made programs and libraries looks the only solution to handle with it.The AVR microcontrollers are familiar to me since i write both in C and assembly using the avr studio,but the esp8266 looks somehow like a "black box" unaccessible to a deeper learning.
Sir you are great ❤❤❤
Sir please make arduino based attendance system with database.
hi thanks for the video. i have a question. i feel a little unconfortable putting the password of my db on a file. what if someone access the database_connect page and just clicks on show source?
I have the same setup in my home, which includes lights fans ,water tank level monitor and control drinking water tap, all controlled through a website, now I am trying to backdoor and control some devices like fridge and washing machine which comes with wifi
but that built in antenna will seriously limit the range, how far do you get? and is there the same thing but with a antenna socket or solder point to install a higher gain antenna?
Love the effort 👍
in tx.php i get the error (Undefined variable: update_number in /storage/ssd3/262/13007262/public_html/TX.php on line 70)
can any body help me!!!
Thank you for the awesome video
Can you use just an esp8266 node lua board? Also is there a way to log the database to get graphs On the website? I want to track environmental temp, humidity and pool temperature over time.. but access from anywhere
Blynk
Hello friend, excellent project with a lot of potential, something that must be taken into account when using public servers (Free), is privacy and data loss.
Thank.
What firmware should be uploaded into esp8266 for connecting to arduino??
how can I do the same project but only with reading the analog value of the sensors on my website without the other things shown in the video ?
hi
Is it without arduino can connect to the madule anywhere ? is can without arduino and use the sim data ?
How can I read some temperature by ntc (5k Ohm) sensor and see it from my phone from anywhere?