Arduino | LoLin NodeMCU V3 ESP8266 with MySQL Database and PHP (LocalHost)

Поделиться
HTML-код
  • Опубликовано: 5 сен 2024
  • Arduino | LoLin NodeMCU V3 ESP8266 with MySQL Database and PHP (LocalHost). In this project video i use LoLin NodeMCU V3 ESP8266,XAMPP v3.2.2 , Notepad++ v7.5.9 and Arduino IDE 1.8.9.
    For LoLin NodeMCU V3 ESP8266 Getting Started (add boards and libraries NodeMCU ESP8266) : • Arduino | LoLin NodeMC...
    Download Code here : drive.google.c...
    For an example of sending multiple data see here : drive.google.c...
    ***********************************************
    Thanks for watching & don't forget to like, comment and Subscribe...
    ***********************************************
    For other video tutorials on this channel, please see this playlist:
    - Basic4Android (B4A) Tutorials : • Basic4Android (B4A) | ...
    - Electronics Tutorials : • 3 LED Flip Flop
    - Arduino Tutorials : • Arduino | Scrolling Te...
    - Great Cow Basic Tutorials : • Great Cow BASIC with A...
    - Bascom Avr Tutorials : • Bascom Avr | How to Se...
    - VB .NET Tutorials : • Visual Basic .NET | ...
    ***********************************************
    Download Arduino IDE : www.arduino.cc...
    ***********************************************
    Download XAMPP : www.apachefrie...
    ***********************************************
    Source of network topology images:
    www.iconfinder...
    ***********************************************
    Music Background :
    Song: Ikson - Do It (Vlog No Copyright Music)
    Music promoted by Vlog No Copyright Music.
    Video Link: • Video
    Song: Nekzlo - Moments (Vlog No Copyright Music)
    Music promoted by Vlog No Copyright Music.
    Video Link: • Nekzlo - Moments (Vlog...
    Far Away by Declan DP / declandp
    Licensing Agreement 2.0 (READ)
    www.declandp.in...
    Music promoted by Audio Library • Far Away - Declan DP (...
    ***********************************************

Комментарии • 285

  • @Marek-zz8ze
    @Marek-zz8ze 3 года назад

    I like your tutorials. Everything is nicely chronologically described and most importantly everything works :)
    I am a beginner in the field of MySQL, your tutorials have opened the door to this area for me. Thank you for your great work.

    • @utehstr
      @utehstr  3 года назад

      You're welcome 👍🙂

  • @alcanceweb
    @alcanceweb 4 года назад

    Finally a tutorial that really works! Thank you very very much!!

    • @utehstr
      @utehstr  4 года назад

      You're welcome :-)

  • @proCode10
    @proCode10 3 года назад

    I have an ESP 8266 (version 01) which therefore includes a GPI0 0 and a GPIO 2 (it seems to me that on this version is only usable the GPIO 2), but my concern is that all my sensors and other components are on the arduino card, so I don't see how to already transmit the data to the arduino card, and how to do with a single output to communicate all this to it, reciprocally from the card to the ESP

  • @ggranger2
    @ggranger2 4 года назад

    Thanks Sir. After a lot of frustated codes, this one works perfect. Very simple in order to send values from arduino to a localhost database via POST. I don´t know why with other codes I can´t do it, only to remotes databases.
    Thanks a lot¡ ¡

    • @utehstr
      @utehstr  4 года назад +1

      You're welcome 🙂

  • @waweyonor6052
    @waweyonor6052 5 лет назад

    What a Great Tutorial! Thank you. I will one of your subscriber 👌

    • @waweyonor6052
      @waweyonor6052 5 лет назад

      Can i ask for help about my project ? Coz your video tutorial is likely same to mine but I'm using mq gas sensor

    • @utehstr
      @utehstr  5 лет назад +1

      Thank you :-)

    • @utehstr
      @utehstr  5 лет назад +1

      @@waweyonor6052 Please send your question to this email channel, see the "about" tab.

    • @waweyonor6052
      @waweyonor6052 5 лет назад

      @@utehstr okay thank you ☺

    • @waweyonor6052
      @waweyonor6052 5 лет назад

      @@utehstr I'm a newby with arduino and esp8266. I'm using Mq gas sensors, the MQ7, MQ4, and MQ131. All i want to do is to separate every data that has been detected by that sensors into the localhost like in your video. Like this
      ID l MQ7 l MQ4 l MQ131 l Date l Time
      . Hope you can help me sir please 🙏

  • @janlowiramos3128
    @janlowiramos3128 4 года назад +2

    Thankyousomuch for this tutorial :)

    • @utehstr
      @utehstr  4 года назад

      You are welcome :-)

  • @jdborjz5122
    @jdborjz5122 5 лет назад +1

    Nice video as usual.
    Do you have a vice versa project? The Nodemcu is the one who receives data from SQL database? Thanks!

    • @utehstr
      @utehstr  5 лет назад +1

      Thank you :-)
      I don't have a project like that.

  • @pratiksalunke3910
    @pratiksalunke3910 4 года назад +1

    Sir how to convert local host to online website

  • @gennapalle7614
    @gennapalle7614 4 года назад

    It works :D Thank you :)

    • @utehstr
      @utehstr  4 года назад

      You are welcome :-)

  • @januarfa
    @januarfa 4 года назад

    Mas tanya, itu kalo datanya udah banyak harus scroll terus kebawah dong? Kalo mau dibuat 1 page cuma 25 data gimana?

  • @shaivalnagarsheth3257
    @shaivalnagarsheth3257 3 года назад

    I don't have UserName and Password when I open PHPadmin.. then what to set in the readDb file? please help

  • @shaivalnagarsheth3257
    @shaivalnagarsheth3257 3 года назад

    I have multiple values to be sent. Please suggest changes to readDb.php files?

  • @lmramirezjr
    @lmramirezjr 3 года назад

    How to solve -1 problem i check my all ip but still got the problem.

  • @maqyuiesolutionspvtltd7221
    @maqyuiesolutionspvtltd7221 Год назад

    Hii Admin. after 3 years of your Video
    now the way of defining code has been changed and now not running. getting error .. can you please provide latest code?? in place of http.begin.

  • @royalyunus7797
    @royalyunus7797 3 года назад

    so is there a way l can combine this with the code to run a servo motor

  • @iqbalalfayyedh9527
    @iqbalalfayyedh9527 4 года назад

    a good tutorial. saya mau nanya, bagaimana cara mengirim beberapa data sensor dari MCU yang berbeda ke dalam satu database? contohnya saya punya 5 MCU yang masing-masing akan membaca data 'penggunaan daya', kemudian data-data tersebut ingin dikirim hanya ke satu database. sehingga di kolom nomor pada database itu menunjukkan nomor MCU nya saja. terimakasih

  • @dretshelanneidong2565
    @dretshelanneidong2565 3 года назад

    hello sir! Can you please help me? i have followed all your steps but i get -1 as a result and there's no data enteres in my localhost/myphpadmin... is there any other fix for this?

    • @panchavarthisujan8578
      @panchavarthisujan8578 3 года назад

      Did you fix your error? Because I am getting the same error as -1.

  • @abdulbaiszargar9629
    @abdulbaiszargar9629 2 года назад

    i got this type of problem please anyboday know help me
    exit status 1
    call to 'HTTPClient::begin' declared with attribute error: obsolete API, use ::begin(WiFiClient, url)

    • @utehstr
      @utehstr  2 года назад

      Use the same version of ESP8266 core or ESP8266 board that I use on board manager on arduino ide, which is version 2.7.4

  • @art_drag9488
    @art_drag9488 3 года назад

    Awesome...👌

    • @utehstr
      @utehstr  3 года назад

      Thank you 🙂

  • @KZura
    @KZura 4 года назад

    i have a project that use this system,
    but some smartphone will connect to Wifi from NodeMCU.
    Then the smartphone will open webserver from NodeMCU, and then input some data
    but i cant save the data to database with this method, or did i need to online to use this method ?

    • @utehstr
      @utehstr  4 года назад

      Sorry I don't understand what you mean, can you explain in more detail.

    • @KZura
      @KZura 4 года назад

      is this project need internet to make it work ?

  • @gokturkcinel2677
    @gokturkcinel2677 3 года назад

    Hello good sir, I am a novice in Arduino and I get -1 printed on the serial monitor after running your code with the appropriate addresses typed in the code, I believe. No data seems to be put into localhost/phpmyadmin. In the "char host" code I put my Mac's IPv4 address and in the http.begin code I type localhost/my username/Nodemcu_db_record_view/InsertDB.php. Can you spot what have I been doing wrong?

    • @gokturkcinel2677
      @gokturkcinel2677 3 года назад

      Also this error code comes up while running the code in the Serial Monitor after a while:
      404
      404 Not Found
      Not Found
      The requested URL was not found on this server.

    • @utehstr
      @utehstr  3 года назад

      @@gokturkcinel2677 Like this the instructions:
      http.begin ("http: //IPv4_address/address_folder_project_in_htdocs/php_file_name.php");

    • @hanyuid7629
      @hanyuid7629 3 года назад

      const char* host =

  • @ayifaan6619
    @ayifaan6619 2 года назад

    Pls make video for node MCU 8266 to ir e18-d80nk sensor to database connection...

  • @AhmadAsmndr
    @AhmadAsmndr 4 года назад

    thank you very much.

    • @utehstr
      @utehstr  4 года назад

      You are welcome :-)

  • @gamenaticstv4007
    @gamenaticstv4007 5 лет назад

    I can't insert data to database.. and serial monitor httpCode prints -1 and the payload prints nothing like blank.....Can you help me fix it..???

    • @utehstr
      @utehstr  5 лет назад

      Are Nodemcu and server computers connected in one network ?

    • @J3zp3rs
      @J3zp3rs 5 лет назад

      @@utehstr I get the same and dont know what to do. Have tried with both mine and the servers ip. But nothing changes

    • @gamenaticstv4007
      @gamenaticstv4007 5 лет назад

      @@utehstr Yes, my nodemcu and computer is connected in one network

    • @utehstr
      @utehstr  5 лет назад

      @@gamenaticstv4007 Are you sure you are using the correct Computer IP (computer database) ?

  • @elberclimacoms7350
    @elberclimacoms7350 3 года назад

    Buen video, Como puedo leer datos desde MySQL con ESP8266 y esto controlar desde una pagina web que está en la nube?

  • @ahmadsalem8935
    @ahmadsalem8935 5 лет назад

    i want to know that data will be saved on computer or esp8266 module?

    • @utehstr
      @utehstr  5 лет назад

      Data is stored on a computer.

  • @Darkrailgun
    @Darkrailgun 4 года назад

    what can i do to fix it.
    Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\Nodemcu_db_record_view
    ead_db.php on line 44

    • @utehstr
      @utehstr  4 года назад

      Check the database name, table name and table field name.

    • @Darkrailgun
      @Darkrailgun 4 года назад

      @@utehstr I've checked all but it doesn't work and have same error.

    • @utehstr
      @utehstr  4 года назад

      @@Darkrailgun As you see in the video that I did not experience an error like that. Honestly, I'm not very good at PHP programming. I suggest you ask this in the PHP forum or try searching on google.

  • @momospadastine2457
    @momospadastine2457 2 года назад

    bisa ajarin gimana mahu buat time/date waktu scan pakai RFID card dgn ardui gk?...yg ada wktu scan in/out

  • @irfanayan2448
    @irfanayan2448 5 лет назад

    the data of ldr value don't save to database......infact in the serial monitor, the httpCode prints -1 and the payload prints nothing like blank.....what should i do???😓😓😓

    • @utehstr
      @utehstr  5 лет назад

      Make sure NodeMCU ESP8266 is on one network with the server computer and make sure you are using the correct IP server.

    • @irfanayan2448
      @irfanayan2448 5 лет назад

      @@utehstr yes....my nodemcu and laptop connected with same network and i provide the correct value of server ip.....

    • @irfanayan2448
      @irfanayan2448 5 лет назад

      @@utehstr bt couldn't send ldr sensor value to database

    • @utehstr
      @utehstr  5 лет назад

      @@irfanayan2448 Make sure XAMPP MySQL and Apache are already running.

    • @irfanayan2448
      @irfanayan2448 5 лет назад

      @@utehstr finally it works.......thank you....the problem was in my laptop id

  • @chanelas292
    @chanelas292 4 года назад

    Is there a pdf that i can download? The step. Cause i can't see Clearly the graphics

    • @utehstr
      @utehstr  4 года назад

      Have you watched 720p resolution? I made this video with 720p resolution to make it clearer.

  • @nursenabasar
    @nursenabasar 5 лет назад

    thank you for tutorial but do i have to use resistor?

    • @utehstr
      @utehstr  5 лет назад

      You are welcome :-)
      What resistor do you mean?

  • @arghasandhy6770
    @arghasandhy6770 4 года назад

    maaf mau tanya klo untuk webhosting yg host diganti alamat hostingnya saja atau "alamathosting/ phpnya" ?

    • @utehstr
      @utehstr  4 года назад +1

      Saya belum pernah mencoba ini di web hosting, tapi dari beberapa sumber yang saya baca seperti ini : "alamathosting/ phpnya" .

    • @arghasandhy6770
      @arghasandhy6770 4 года назад

      ok coba aku cari2 dulu

    • @manusiarakus6899
      @manusiarakus6899 4 года назад

      Mas udah nemu belum jawabannya mas? Saya di kendala yang sama

  • @manusiarakus6899
    @manusiarakus6899 4 года назад

    Mas videonya sangat menarik, saya ingin bertanya jika menggunakan webhosting gimana mas? Apakah ada referensi yang bisa saya kunjungi?

  • @mamankocim8043
    @mamankocim8043 5 лет назад

    kalo ingin mengirim data sensor suhu dan kelembaban, modul dht 22 bagaimana kodingan di "nodemcu"?

    • @utehstr
      @utehstr  5 лет назад

      Akses dht22-nya, kemudian kombinasikan dengan kode yang ada pada video.

  • @pichonpage1444
    @pichonpage1444 4 года назад

    TE AMO

    • @utehstr
      @utehstr  4 года назад +1

      Gracias :-)

  • @claireivyclavillas5538
    @claireivyclavillas5538 4 года назад

    Hello. I would like to send 4 Strings. What would I need to change in the Arduino code and in InsertDB.php ? Thank you in advance. I can only display 1 out of 4 Strings.

    • @utehstr
      @utehstr  4 года назад

      Here's an Example (Using 3 Sensors):
      -Arduino Code:
      HTTPClient http; //Declare object of class HTTPClient
      //-------------------------------------------to send data to the database
      String MQ7Post, MQ4Post, MQ131Post, postData;
      MQ7Post = String(MQ7);
      MQ4Post = String(MQ4);
      MQ131Post = String(MQ131);
      postData = "mq7val=" + MQ7Post + "&mq4val=" + MQ4Post + "&mq131val=" + MQ131Post;
      http.begin("192.168.x.x/nodemcu_post_database/InsertDB.php"); //Specify request destination
      http.addHeader("Content-Type", "application/x-www-form-urlencoded"); //Specify content-type header
      int httpCode = http.POST(postData); //Send the request
      String payload = http.getString(); //Get the response payload
      //-------------------------------------------
      http.end(); //Close connection
      -PHP Code (InsertDB.php):
      //Get current date and time
      date_default_timezone_set('Asia/Jakarta');
      $d = date("Y-m-d");
      $t = date("H:i:s");
      if(!empty($_POST['mq7val']) && !empty($_POST['mq4val']) && !empty($_POST['mq131val']))
      {
      $mq7val = $_POST['mq7val'];
      $mq4val = $_POST['mq4val'];
      $mq131val = $_POST['mq131val'];
      $sql = "INSERT INTO table_nodemcu (mq7, mq4, mq131, date, time)
      VALUES ('".$mq7val."', '".$mq4val."', '".$mq131val."', '".$d."', '".$t."')";
      if ($conn->query($sql) === TRUE) {
      echo "OK";
      } else {
      echo "Error: " . $sql . "" . $conn->error;
      }
      }

    • @rauldachikara5071
      @rauldachikara5071 4 года назад

      @@utehstr gk bisa gan saya pakai 2 input untuk memasukan data ke database

    • @utehstr
      @utehstr  4 года назад

      @@rauldachikara5071 Maksudnya gak bisa ? Cuma masuk 1 atau gk masuk sama sekali ?

    • @rauldachikara5071
      @rauldachikara5071 4 года назад

      @@utehstr mau masuk 2 tapi datanya gk masuk

  • @kaleabwalelign6489
    @kaleabwalelign6489 4 года назад

    what if i have 2 or 3 Arduino | LoLin NodeMCU how to connect them by one wifi access point

    • @utehstr
      @utehstr  4 года назад

      Do you mean in access point mode ?

    • @kaleabwalelign6489
      @kaleabwalelign6489 4 года назад

      @@utehstr ya , but i have many Arduino | LoLin NodeMCU so how can i connect through one wifi point to one database

  • @ralphjonerepolicarpio3107
    @ralphjonerepolicarpio3107 4 года назад

    How to change table into line graph?

  • @rafaelsolis8599
    @rafaelsolis8599 5 лет назад

    sir good tutorial , can you help me in the code for nodemcu with color sensor sending data to php please?

  • @vijaykoparde1275
    @vijaykoparde1275 5 лет назад

    i downloaded the file from google drive and tried to extract files, it says the file is damaged. can you please provide another link. thank you.

    • @vijaykoparde1275
      @vijaykoparde1275 5 лет назад

      It says unsupported format or damaged. i think this is due to old version of Winrar software.

    • @utehstr
      @utehstr  5 лет назад +1

      @@vijaykoparde1275 I make the .rar file using WinRAR v 5.50, to extract it, make sure you have the same or higher version of WinRAR or you can use the .rar extractor online.

    • @vijaykoparde1275
      @vijaykoparde1275 5 лет назад

      @@utehstr thank you , Good work , keep going.

    • @utehstr
      @utehstr  5 лет назад

      @@vijaykoparde1275 You are welcome :-)

  • @marcesfranz
    @marcesfranz 5 лет назад

    Thank you!!!!!!!!!

    • @utehstr
      @utehstr  5 лет назад

      You are welcome :-)

  • @ahmadjauhar2629
    @ahmadjauhar2629 4 года назад

    maaf mau tanya, kenapa kok pas serial print bagian httpcode jadi -1, sama serial bagian paylaoud nggk ada isinya ???

    • @utehstr
      @utehstr  4 года назад

      Pastikan Nodemcu dan Komputer server(database) berada dalam 1 jaringan yang sama dan pastikan menggunakan IP Komputer server yang benar.

    • @ahmadjauhar2629
      @ahmadjauhar2629 4 года назад

      @@utehstr udah gan, pkek ipv4 di cmd, trus xampp (apache sama mysql) udah nyala

    • @utehstr
      @utehstr  4 года назад

      @@ahmadjauhar2629 Dimana kamu simpan/letakkan file phpnya ?

    • @ahmadjauhar2629
      @ahmadjauhar2629 4 года назад

      @@utehstr C:\xampp\htdocs\Nodemcu_db_record_view

  • @kentpaul8269
    @kentpaul8269 4 года назад

    Sir i have a question. Why is their a 200 in your serial monitor output?

    • @utehstr
      @utehstr  4 года назад

      Look here: en.wikipedia.org/wiki/List_of_HTTP_status_codes

    • @kentpaul8269
      @kentpaul8269 4 года назад

      Can you make a tutorial in ds1b20 and max30102? Same as your video

    • @utehstr
      @utehstr  4 года назад

      @@kentpaul8269 At the moment I can't do it because I don't have the modules, maybe later I will make them when I already have them.

    • @kentpaul8269
      @kentpaul8269 4 года назад

      Sir i have ang question, what sensor did you use? And can you give a source code of that sensor? Without the wifi part

    • @utehstr
      @utehstr  4 года назад

      @@kentpaul8269 The sensor used in this project is the LDR light sensor. To download the code, please see the link in the video description.

  • @irfanayan2448
    @irfanayan2448 5 лет назад

    @Uteh Str if I want to send 2 strings, what should I do????

    • @utehstr
      @utehstr  5 лет назад +2

      Here is an example :
      //-------------------------------------------to send data to the database
      String MQ7Post, MQ4Post, MQ131Post, postData;
      MQ7Post = String(MQ7);
      MQ4Post = String(MQ4);
      MQ131Post = String(MQ131);
      postData = "mq7val=" + MQ7Post + "&mq4val=" + MQ4Post + "&mq131val=" + MQ131Post;
      http.begin("server_database_IP/nodemcu_post_database/InsertDB.php"); //Specify request destination
      http.addHeader("Content-Type", "application/x-www-form-urlencoded"); //Specify content-type header
      int httpCode = http.POST(postData); //Send the request
      String payload = http.getString(); //Get the response payload
      //-------------------------------------------

    • @irfanayan2448
      @irfanayan2448 4 года назад

      @@utehstr thank you 🥰

    • @utehstr
      @utehstr  4 года назад

      @@irfanayan2448 You are welcome :-)

  • @sadhanace
    @sadhanace 4 года назад

    Your source code file is showing corrupt. Can you tell me from where I will get the arduino code?

    • @utehstr
      @utehstr  4 года назад

      I created a .rar file using Winrar V5.50, so to extract it, make sure you use the same version of Winrar that I use or the latest version or use the winrar extractor online.

    • @sadhanace
      @sadhanace 4 года назад

      @@utehstr Yes now it is working. Thanks

    • @utehstr
      @utehstr  4 года назад

      @@sadhanace You're welcome :-)

  • @tharanitharanm3494
    @tharanitharanm3494 4 года назад

    ESP8266HTTPClient.h... Header file is not working for me... Can anyone help me with that

    • @utehstr
      @utehstr  4 года назад

      What do you mean by "not working" ?

  • @torstenfernandes
    @torstenfernandes 4 года назад

    will this code work if nodemcu and laptop with php pages are connected to different wifi?????

    • @utehstr
      @utehstr  4 года назад +1

      In this project NodeMCU and Laptop / Computer must be on the same network.

    • @torstenfernandes
      @torstenfernandes 4 года назад

      @UtehStr okay thanks

  • @noelvl3093
    @noelvl3093 4 года назад

    mas, gimana ya kita mau ngecek apakah data udah berhasil masuk ke database?. saya baru mencoba membuat database, program esp, dan insertDB.php mas. programnya gak jalan. apakah ada cara untuk mengecek data didalam databasenya ?. terimakasih

    • @utehstr
      @utehstr  4 года назад

      Cek secara manual saja dari mysql.

    • @noelvl3093
      @noelvl3093 4 года назад

      @@utehstr mau tanya lagi mas, kenapa di program saya payloadnya gak ke print di serial monitor ya ?? sedangkan http codenya sudah ke print 200. Terima kasih sebelumnya.

  • @arriesize
    @arriesize 4 года назад

    Pak saya ingin bertanya, bisakah untuk data yang dimasukkan kedalam tabel dikelompokkan perhari dan setiap sebulan database dihapus ?

    • @utehstr
      @utehstr  4 года назад

      Tentu saja bisa.

    • @arriesize
      @arriesize 4 года назад

      Uteh Str apkah saya bisa mendapatkan rekomendasi atau bapak akan membuatkan videonya pak ?

    • @utehstr
      @utehstr  4 года назад +1

      @@arriesize Kalau untuk videonya mungkin nanti saya akan buat, tapi saya belum tau kapan. Tapi kalok untuk tutorial mengelompokkan database perhari dan auto delete itu sangat banyak di google, coba lah kamu cari.

  • @hadjiassimjumaih2442
    @hadjiassimjumaih2442 2 года назад

    What programming language used in Arduino? Can I use python

    • @utehstr
      @utehstr  2 года назад

      Arduino code is written using the C++ programming language (On the Arduino IDE) and the library is written using C or C++.
      Yes, you can program Arduino Boards with Python code. But I've never used it, maybe these links can be your reference:
      - realpython.com/arduino-python/
      - pythonforundergradengineers.com/python-arduino-LED.html
      - create.arduino.cc/projecthub/smart-tech/programming-arduino-using-python-f3d2c0
      Arduino boards can also be programmed using the BASIC language, here are the tools or IDEs that support programming Arduino boards using the BASIC language:
      - gcbasic.sourceforge.net/Typesetter/index.php/Home
      - www.mcselec.com/index.php?id=14&option=com_content&task=view
      Watch the video here (Arduino with BASIC): ruclips.net/video/2rEWPXrEWgA/видео.html

  • @jokoui7133
    @jokoui7133 4 года назад

    Hi sir. I tried this tutorial.. but ther r no respon ok and http code is -1. What should i do? I have change ip address many times.
    Thanks

    • @utehstr
      @utehstr  4 года назад +1

      Make sure NodeMCU and the server computer are in one network.

    • @jokoui7133
      @jokoui7133 4 года назад

      @@utehstr yes. I connected them in one network. But. Still no respons

    • @utehstr
      @utehstr  4 года назад

      @@jokoui7133 Make sure you use the correct SSID and password and try to turn off the firewall on your PC.

    • @jokoui7133
      @jokoui7133 4 года назад

      @@utehstr i already turn off the fire wall. I start it from zero again and following your directions. The result is payload error insert into node mcu. Http code show 200.. then i wait it for a minute. Unfortunately httpcode show -1 again. What should i do sir?

    • @jokoui7133
      @jokoui7133 4 года назад

      @@utehstr thanks sir. Its work finally

  • @bellmustachecat9794
    @bellmustachecat9794 4 года назад

    Thankyousomuch

    • @utehstr
      @utehstr  4 года назад

      You are welcome :-)

  • @chiboubslimane261
    @chiboubslimane261 5 лет назад

    thank you verry much, in ( const *char=198.168.0.0) is this the local adress (localhost) or this is another @, plz reply

    • @utehstr
      @utehstr  5 лет назад

      See here 8:22

    • @chiboubslimane261
      @chiboubslimane261 5 лет назад

      @@utehstr I did that but it's the same problem :(

    • @utehstr
      @utehstr  5 лет назад

      @@chiboubslimane261 Send your code to this email channel. This email channel is available on the About tab

  • @rahmadk9137
    @rahmadk9137 5 лет назад

    mau nanya bang kalo kita pake esp8266 dengan arduino mega coding espnya bagaimana ya ? mohon pencerahannya

    • @utehstr
      @utehstr  5 лет назад

      Maaf saya gak bisa jawab, saya belum pernah coding esp8266 dengan arduino mega atau uno.

    • @rahmadk9137
      @rahmadk9137 5 лет назад

      @@utehstr oke bang

  • @user-vw3hi1vb1e
    @user-vw3hi1vb1e 4 года назад

    my nodemcu resulit is
    -1
    LDR Value=25
    what is problem?

    • @utehstr
      @utehstr  4 года назад

      Make sure that you have used the correct IP and project address in the arduino code (httt.begin)

    • @dretshelanneidong2565
      @dretshelanneidong2565 3 года назад

      hi! i seem to have the same problem... i always get -1 in my result.... have you solved this problem? can you please help me?

    • @dretshelanneidong2565
      @dretshelanneidong2565 3 года назад

      hi! i seem to have the same problem... i always get -1 in my result.... have you solved this problem? can you please help me?

  • @irfanayan2448
    @irfanayan2448 5 лет назад

    if i want to send the nodemcu ip address to the database also what should i do????? plz can u help me doing this

    • @utehstr
      @utehstr  5 лет назад

      Send this variable WiFi.localIP ()

    • @irfanayan2448
      @irfanayan2448 5 лет назад

      @@utehstr how???? i tried but couldn't do.....can u plz tell me in details????

    • @utehstr
      @utehstr  5 лет назад

      @@irfanayan2448 please contact this email channel.

    • @irfanayan2448
      @irfanayan2448 5 лет назад

      @@utehstr please give me email address.

    • @utehstr
      @utehstr  5 лет назад

      @@irfanayan2448 This email channel can be seen in the About Tab.

  • @nalendro_agung
    @nalendro_agung 3 года назад

    thanks tutorialnya mas, tapi apa anda tidak mau pake Visual studio code utk text editornya hehehe:D

    • @utehstr
      @utehstr  3 года назад

      Sama-sama 🙂
      Saya juga pake Visual studio code. Kalau di video, saya pake Notepad++ untuk text editornya, itu untuk memperingan beban kerja komputer saja pada saat pembuatan dan perekaman video.

    • @nalendro_agung
      @nalendro_agung 3 года назад

      @@utehstr siap mas semangat selalu untuk bikin videonya, oh ya kl maudibikin datanya ke bentuk grafik itu teknik pembuatanya namanya apa ya?

    • @utehstr
      @utehstr  3 года назад

      @@nalendro_agung Jujur saja saya sangat lemah kalau untuk pemograman PHP, jadi kalau mau buat dalam bentuk grafik, coba tanya di forum2 PHP.

    • @nalendro_agung
      @nalendro_agung 3 года назад

      @@utehstr oalah oke gan semangat terus untuk buat vidionya dan terimakasih

    • @utehstr
      @utehstr  3 года назад

      @@nalendro_agung 👍🙂

  • @yehezkielrusli7262
    @yehezkielrusli7262 4 года назад

    mas rar nya damage dan tidak bisa didownload. apakah bisa memberi source download yang baru?

    • @utehstr
      @utehstr  4 года назад

      Saya sudah periksa linknya dan itu bisa didownload.

  • @pamansam9937
    @pamansam9937 Год назад

    Led _onBoard itu fungsi apa kak?

  • @gumelarrukunsadewo3166
    @gumelarrukunsadewo3166 2 года назад

    Pagi mas ,kalau pake sensor HCSR-04 konsep nya sama ga ?

    • @utehstr
      @utehstr  2 года назад

      Malam, Sama.

  • @muhammadnazri1044
    @muhammadnazri1044 3 года назад

    Permisi mas..tumpang nanya..bagaimana nodemcu hendak connect kepada WiFi yang tiada passwood..

    • @utehstr
      @utehstr  3 года назад +1

      Saya belum pernah coba yang seperti itu, coba pada kode arduino-nya, kosongkan saja bagian password-nya.

    • @muhammadnazri1044
      @muhammadnazri1044 3 года назад

      Ooohh..terima kasih mas..

  • @rioindrasiswanto8131
    @rioindrasiswanto8131 2 года назад

    Datanya visa terkirim ke data base apakah hrus konek trus internet ke laptop..?

    • @utehstr
      @utehstr  2 года назад

      NodeMCU harus berada pada jaringan yang sama dengan komputer server (local).

    • @rioindrasiswanto8131
      @rioindrasiswanto8131 2 года назад

      Berarti wifi laptop gak perlu konek ke internet mas..?

  • @andriyantonugroho8414
    @andriyantonugroho8414 5 лет назад

    How to change format field Date yyyy-mm-dd to dd-mm-yyyy in table

    • @utehstr
      @utehstr  5 лет назад

      Use this :
      $d = date ("d-m-Y");

    • @andriyantonugroho8414
      @andriyantonugroho8414 5 лет назад

      @@utehstr this is the only code?

    • @utehstr
      @utehstr  5 лет назад

      @@andriyantonugroho8414 Yes
      To see other formats see here:
      www.php.net/manual/en/function.date.php
      www.php.net/manual/en/datetime.formats.date.php

  • @sdiaiml7863
    @sdiaiml7863 4 года назад

    kalau kirim multiple data dan terima multiple data dari gimana ya mas? terus apakah kalau kirim data banyak kecepatannya jg berukurang?

    • @utehstr
      @utehstr  4 года назад

      Untuk contoh mengirim multiple data dan menerimanya sudah saya tambahkan filenya di deskripsi video, silahkan dilihat.
      Sampai saat in saya baru mencoba mengirimkan 3 data sensor dan kecepatannya masih baik-baik saja. Saya belum mencoba mengirimkan data lebih dari itu, mungkin kamu bisa mencobanya :-)

    • @sdiaiml7863
      @sdiaiml7863 4 года назад

      @@utehstr temakasih banyak mas!

    • @utehstr
      @utehstr  4 года назад

      @@sdiaiml7863 Sama-sama :-)

    • @sdiaiml7863
      @sdiaiml7863 4 года назад

      @@utehstr oiya mas, untuk get data dari mysql adakah caranya?

    • @utehstr
      @utehstr  4 года назад

      @@sdiaiml7863 Maksudnya ?

  • @kissfrancisco
    @kissfrancisco 4 года назад

    The sample code was crashed it can't be opened sir.

    • @utehstr
      @utehstr  4 года назад

      The code file is saved in the .rar file format. I created a .rar file using Winrar V5.50, so to extract it, make sure you use the same version of Winrar that I use or the latest version or use the winrar extractor online.

    • @kissfrancisco
      @kissfrancisco 4 года назад

      Uteh Str why does the ssid of nodemcu doesn’t show?

    • @utehstr
      @utehstr  4 года назад

      @@kissfrancisco I do not understand what you mean, can you explain in more detail.

    • @kissfrancisco
      @kissfrancisco 4 года назад

      @@utehstr can I ask you questions through email sir? hoping for your positive respond. thank you

    • @utehstr
      @utehstr  4 года назад

      @@kissfrancisco This email channel is available on the tab about, look in the details section.

  • @tatangsuhendra4251
    @tatangsuhendra4251 4 года назад

    mas kalau nodemcu nya tidak terkonek ke komputer (menggunakan power supply eksternal) kok web nya tidak jalan ya? mohon pencerahannya hehe

    • @utehstr
      @utehstr  4 года назад

      kamu menghubungkan power supply eksternal melalui usb atau Vin ? Berapa volt power supply eksternal yang kamu hubungkan ?

    • @tatangsuhendra4251
      @tatangsuhendra4251 4 года назад

      Udah mas ternyata ada yg salah pas pengkodingan. Nah pertanyaan selanjutnya, itu kan sensor sama server harus berada dijaringan yg sama. Bisa tidak ya kalau menggunakan jaringan yg berbeda? Karena sensornya ingin diletakkan jauh dari komputer server untuk monitoring jarak jauh. Mohon mas pencerahannya hehe

    • @utehstr
      @utehstr  4 года назад

      @@tatangsuhendra4251 kalau menggunakan jaringan yang berbeda opsinya kamu bisa menggunakan web hosting / online database hosting atau bisa juga komputer server kamu dipasang IP Public.

    • @tatangsuhendra4251
      @tatangsuhendra4251 4 года назад

      @@utehstr apakah ada tutornya mas? :D

    • @utehstr
      @utehstr  4 года назад

      @@tatangsuhendra4251 Untuk saat ini saya belum ada tutorialnya.

  • @TresnaWidiyaman
    @TresnaWidiyaman 5 лет назад

    Thanks tutorialnya mas, saya mendapatkan masalah. Datanya tidak masuk ke database padahal sudah 200 OK

    • @utehstr
      @utehstr  5 лет назад

      Sama-sama :-)
      Apakah kamu yakin sudah mengikuti semua intruksi pada video ?

  • @gumelarrukunsadewo3166
    @gumelarrukunsadewo3166 2 года назад

    Untuk download coding di notepad++ nyaada ga mas ?

    • @utehstr
      @utehstr  2 года назад +1

      Lihat dideskripsi video.

    • @gumelarrukunsadewo3166
      @gumelarrukunsadewo3166 2 года назад

      @@utehstr file nya rusak Mas ga bisa kebuka , udh download di desc video nya

    • @utehstr
      @utehstr  2 года назад

      @@gumelarrukunsadewo3166 filenya bukan rusak, tapi versi winrar kamu yang tidak sesuai. Lihat lagi dideskripsi video, baca dengan teliti, saya sudah jelaskan disana.

    • @gumelarrukunsadewo3166
      @gumelarrukunsadewo3166 2 года назад

      @@utehstr oke udh sya download berhasil thx mas

    • @utehstr
      @utehstr  2 года назад

      @@gumelarrukunsadewo3166 Ok, sama-sama 👍

  • @uncode3773
    @uncode3773 4 года назад +1

    I got -1 plz help

    • @dretshelanneidong2565
      @dretshelanneidong2565 3 года назад

      hi! i seem to have the same problem... i always get -1 in my result.... have you solved this problem? can you please help me? i've already followed the format but i get the same result.

  • @sellamarta1484
    @sellamarta1484 4 года назад

    Kak padahal udah sama kok dia ngak bisa terhubung ya datanya ke web

    • @utehstr
      @utehstr  4 года назад

      Pastikan NodeMCU dan komputer kamu berada dalam jaringan yang sama dan pastikan kamu sudah memasukkan alamat folder dan ip yang benar.

    • @sellamarta1484
      @sellamarta1484 4 года назад

      Ip dilahat pada pc cmd kan kak

    • @utehstr
      @utehstr  4 года назад

      @@sellamarta1484 Iya

  • @nkanyisobuhdidi9234
    @nkanyisobuhdidi9234 3 года назад

    Great project, I'm using ESP32 on my attendance system project the server and website is working fine now want to add MLX90614 to post Temperature Values, Sir can you help me with php code to add on the existing website

  • @ezgieftekin4495
    @ezgieftekin4495 3 года назад

    Hello sir, this is a very informative tutorial. But i get several errors and solve them. There is one problem I couldn't solve:
    403
    403 Forbidden
    Forbidden
    You don't have permission to access this resource.
    Apache/2.4.46 (Win64) PHP/7.3.21 Server at ....... Port 80
    I get this error and I don't know how to solve it. If someone can help I would appreciate it.

    • @utehstr
      @utehstr  3 года назад +1

      In the Arduino code (in the http.begin section) make sure you have entered the correct IP and the correct folder address (IP / Folder address in htdocs). The bottom line is make sure that the URL is correct.

    • @ezgieftekin4495
      @ezgieftekin4495 3 года назад

      @@utehstr I realize that I didn't change the http.begin section. Still, my problem is not solved.
      http.addHeader("Content-Type", "application/x-www-form-urlencoded");
      I couldn't figure what does this code for. I use wamp server by the way so I try to understand everything in the code to apply to my project. Thank you for your time and help.

  • @camilamadureira3147
    @camilamadureira3147 5 лет назад

    Thanks, but the .rar file is dameged.

    • @utehstr
      @utehstr  5 лет назад

      You are welcome :-) I have checked the file and the file is fine. You must download it first to see the contents of the file, because Google Drive does not provide a preview of the .rar file format. Make sure you have the software to extract the .rar file format.

  • @gumelarrukunsadewo3166
    @gumelarrukunsadewo3166 2 года назад

    Coding PHP boleh di share ga mas ?

  • @ShubhamVerma-jt2nf
    @ShubhamVerma-jt2nf 5 лет назад

    rar file is damaged

    • @utehstr
      @utehstr  5 лет назад

      I have checked the file and the file is fine. You must download it first to see the contents of the file, because Google Drive does not provide a preview of the .rar file format. Make sure you have the software to extract the .rar file format.

  • @hendrarfahrezz8378
    @hendrarfahrezz8378 5 лет назад

    Bang kalo input nya sensor digital code nya gimana? TQ

    • @utehstr
      @utehstr  5 лет назад

      Maksudnya ? Bisa lebih detail ?

    • @hendrarfahrezz8378
      @hendrarfahrezz8378 5 лет назад

      Apa ada code arduino untuk sensor yang digital seperti sensor infrared, ultrasonic, dll. Karena di video ini input sensor nya analog. Mohon pencerahannya bang.. :)

    • @utehstr
      @utehstr  5 лет назад

      @@hendrarfahrezz8378 Kamu sudah baca code yang saya bagikan pada video ini ?

    • @hendrarfahrezz8378
      @hendrarfahrezz8378 5 лет назад

      Sudah, saya sudah download codenya dan telah berhasil diimplementasikan. Tapi kalau mau mengganti sensornya yang diubah apanya bang di code nya?

    • @utehstr
      @utehstr  5 лет назад

      @@hendrarfahrezz8378 Pertama coba akses dulu sensornya, jika sudah berhasil tukar LdrValueSend pada code dengan variable sensor yang kamu gunakan.

  • @krasimirkrustev822
    @krasimirkrustev822 4 года назад

    Hello Uteh Str,
    Thank you for the video. The code i download from the link you gave is damaged. It can't be opened. Can you help me please.
    Thanks in advance and good luck.

    • @utehstr
      @utehstr  4 года назад

      The code file is saved in the .rar file format. I created a .rar file using Winrar V5.50, so to extract it, make sure you use the same version of Winrar that I use or the latest version or use the winrar extractor online.

  • @ravikumarbiradar1115
    @ravikumarbiradar1115 4 года назад

    no ok response showing -1

    • @robelreda6674
      @robelreda6674 4 года назад +1

      just turn of your firewall and it will work

    • @AbhishekKumar-jy7tt
      @AbhishekKumar-jy7tt 4 года назад

      Is your code is working after fix -1 problem

  • @NemorahabuzaD1994
    @NemorahabuzaD1994 4 года назад

    lolin