ESP32 Data to SQL Database STEP by STEP || Python Made IT EASY

Поделиться
HTML-код
  • Опубликовано: 23 дек 2024

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

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

    Unique projects that we can make for you:
    Cyber security
    >ddos attack detection and prediction
    >intrusion attack detection
    >encryption of medical data
    >stegnography >> hide data in pics
    >deep fake for videos and images
    >deep fake audio detection
    ML/DL/AI
    >Smallest path predictor for spraying in agricultural drones, google colab
    >conveyer belt waste segregation project >> textile university, raspi
    >virtual dressing room webapp/flutter app with fashion recommender,3d model, real time testing
    >Blind vision mobile app Skin/Lungs/eye/blood cancer detection
    >Smart CCTV camera for anomaly detection and video recording, alert, make portion of video where anomly detected, gun detection
    >ML Verfied Marketplace, improved olx version using ML, detect bike or phone in pic otherwise reject picture, audio search, black and white theam
    >text to sign and sign to text converter using python and Machine learning
    >Twitter sentiment analysis using ML
    >Audio classification for people with hearing problems, their name detection, car horn detection
    >LLM and openai/chatgpt chatbot
    >Land classification (barren and fertile land, water) or urban population expension prediction system
    >Load forecasting and managment of an industry
    >AI soccer team selection
    >Marquee recomendation system
    >Bone fracture detection
    Image processing
    >person following cart in shoping malls
    >Driver drosiness detection
    >Face attendence system, ip camera, auto attendence
    >Smart parking system and number plate recognization system
    >Solar cleaner using image processing
    > Medical perscription reader app using image processing , to reduce risk of wrong medicine to patient
    IOT
    > Water quality monitoring system using IOT, ph sensor, temp, water level
    > Pet/Plant monitoring system
    > Automatic door lock using finger print and rfid card
    > Smart baby craddle >> amplifier and speaker for tune playing, motor for swing, temp, moisture, is baby present in craddle, blynk app message to mother/father or guardian
    > Garbage collector Robot for Rivers and Lakes
    > Health(Current, volts and temp) moniting of induction motor/transformer
    > 3 phase motor health monitoring using iot
    > Smart socket for home appliances
    > Fire fighting Robot
    > Smart Traffic light system with mobile app control for amublance
    > Smart verticle parking system for smart cities >> congested areas, rfid card
    > LiFi system for communication of data in near field
    > BMS system for electrical vehicles
    > Solar Tracker system
    > Weight scale (Digital kanda) for trucks
    > smart mirror
    Web apps
    >Beauty Parlour managment system
    >pdf to audio converter for easy reading
    >Credit card fruad detection system
    >kisaan sahulat app
    >diabetes detection using ML and django
    >uber like ride sharing app for community service
    >Block chain based voting system using django
    >voice based chatbot
    >LMS system
    Reach us for these projects
    +92-305-7736599, asif iqbal

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

    Sir u used nodemcu as controller and use its application installation , can I use this application for esp32 wroom

  • @pedrosantos2609
    @pedrosantos2609 Год назад +1

    Hi. I'm trying to adapt the project to a board that do not support httpclient library (Wio LTE). The following code result in the same message do post in the SQL server? Thanks
    SerialUSB.println("### Sending POST request...");
    char httpRequestData[256];
    sprintf(httpRequestData, "POST /post-esp-data-pos.php HTTP/1.1
    "
    "Host: %s
    "
    "Content-Type: application/x-www-form-urlencoded
    "
    "Content-Length: %d
    " // Include the content length header
    "
    " // End of headers
    "api_key=%s&sensor=%s&ambiente=%.2f&interior=%.2f&voltagem=%.2f&corrente=%.2f&potencia=%.2f",
    serverName, strlen(httpRequestData), apiKeyValue.c_str(), sensor.c_str(),
    temp_ambiente, temp_interior, voltage, current, power);

  • @muhammadshan1151
    @muhammadshan1151 3 месяца назад +1

    Sir I subscribed channel but still i can not download the files.

    • @aisoft1891
      @aisoft1891  Месяц назад

      oh why? please reach me at my whatsapp

  • @HaiDuong-zd2jd
    @HaiDuong-zd2jd 2 года назад +1

    can it use for sql server authentication?

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

      yes.

    • @HaiDuong-zd2jd
      @HaiDuong-zd2jd 2 года назад +1

      @@aisoft1891 the program cant connect to host sever sql :.(

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

      @@HaiDuong-zd2jd Please Reach me at my whatsapp. Lets fix it

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

    This is video which i was looking for.... Thanku

  • @vanhaunguyen292
    @vanhaunguyen292 Год назад +1

    Can you help me with this?
    "Error faced while connecting to Database."

  • @raphaelcatapang4655
    @raphaelcatapang4655 Год назад +1

    Is there a way to edit certain cells in the table via code?

  • @muhammadshan1151
    @muhammadshan1151 3 месяца назад

    There is no file on that link, can you please share?

  • @junhaokhor3777
    @junhaokhor3777 Год назад +1

    can connect to django server api using this?

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

      No it is hardcoded. Need to change in code for django compatibility

  • @deejae_music
    @deejae_music 10 месяцев назад +1

    does this apply to esp32?

    • @aisoft1891
      @aisoft1891  10 месяцев назад

      yes, it works for esp32, arduino, nodemcu

  • @aripjamaludinrumi
    @aripjamaludinrumi 6 месяцев назад +1

    Amazing sir,
    Can I only Update the SQL data with esp8266 ?
    I dont need to make a new data I only need to make change from zero value to actual integer value as detected by esp8266 sensor.
    So Where was the SQL Query wrote ? In pyhton app, indeed ?

    • @aisoft1891
      @aisoft1891  6 месяцев назад +1

      yes sql query is in python app. Please reach me at my whatsapp if you need any new update in software. +923057736599

    • @aripjamaludinrumi
      @aripjamaludinrumi 6 месяцев назад

      @@aisoft1891 owh thank you so much sir 🙏

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

    Can we give commands to our ESP32 from SQL Server tables by using this installer??

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

      Nope. Data can only travel from esp to installer

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

      @@aisoft1891 PHP file works for this in case of MySQL... Can we do it with PHP files in Microsoft SQL Serever?

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

      Or simply guide me how to command our ESP32 from localhost server?
      Mr. Asif thanks in advance, i m looking for your response

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

      @@anasarif4926 yes esp32 can be accepts commands from local host but we need a different python code.

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

      @@anasarif4926 reach me at my whatsapp +92-305-7736599

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

    what if i want to get a specific column in the database

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

      how can i get pay load to print one column from databased

  • @quaninhphamhong7130
    @quaninhphamhong7130 10 месяцев назад +1

    it's inconvinience that only 4 values can be saved

    • @aisoft1891
      @aisoft1891  10 месяцев назад

      you can reach me on my whatsapp, i will make new one for you. but you have to pay a few charges.

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

    The link is damaged?

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

      i dont think so. please try again and read instructions in video description.

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

      If i want to connect esp32 to xampp database not sql server management..does this way work?

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

      @@bassantmohammed7555 i have not tested it with xampp. Dont think it will work.

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

    loved your video and really amazed with that logger exe can make video on that or post the code or tutorial so as to refer it

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

      The exe is made using python. And code is also done in python.

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

      Can you share that code it would be very helpful

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

      It would be very helpful if you can share the code file or the procedure how to make this logger software

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

      @@karansanghavi5308 sure. Comment down your mail. I send you code.

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

      Sir can you please share the code with me I have send comments mentioning my mail id but they got hidden can you share some other way to connect

  • @jonathan11x
    @jonathan11x Год назад +1

    Hi mate, can you provide to me the source code? I want to make some features :)

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

      Sure. I can give you source code in only 50usd. Please reach me at my whatsapp +923057736599

  • @loiang2345
    @loiang2345 Год назад +1

    i have subscribed the channel,pls help me download all files

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

      Please download from the link in description