• Skip to main content
  • Skip to primary sidebar

RNTLab.com

The Ultimate Shortcut to Learn Electronics and Programming with Open Source Hardware and Software

  • Courses
  • Forum
    • Forum
    • Ask Question
  • Shop
  • Account
  • Blog
  • Login

ESP32/ESP8266 Insert Data into MySQL Database using PHP and Arduino IDE , does not update my database

Q&A Forum › Category: ESP32 › ESP32/ESP8266 Insert Data into MySQL Database using PHP and Arduino IDE , does not update my database
0 Vote Up Vote Down
Sabatino asked 3 years ago

Hello everyone, after creating the database on AlterVista, following the instructions, no errors are reported to me, however the sensor data is not saved in the table of my database.
ets Jun 8 2016 00:22:57
rst:0x1 (POWERON_RESET),boot:0x13 (SPI_FAST_FLASH_BOOT)
configsip: 0, SPIWP:0xee
clk_drv:0x00,q_drv:0x00,d_drv:0x00,cs0_drv:0x00,hd_drv:0x00,wp_drv:0x00
mode:DIO, clock div:1
load:0x3fff0018,len:4
load:0x3fff001c,len:1044
load:0x40078000,len:10124
load:0x40080400,len:5856
entry 0x400806a8
Connecting
…..
Connected to WiFi network with IP Address: 192.168.1.66
httpRequestData: api_key=tPmAT5Ab3j7F9&sensor=BME280&location=Office&value1=20.84&value2=54.65&value3=1008.06
HTTP Response code: 200
httpRequestData: api_key=tPmAT5Ab3j7F9&sensor=BME280&location=Office&value1=20.89&value2=54.50&value3=1008.07
HTTP Response code: 200
 
IDSensorLocationValue 1Value 2Value 3Timestamp
 

5 Answers
0 Vote Up Vote Down
Chris answered 3 years ago

Same problem as above. Using Bluehost. 

0 Vote Up Vote Down
Steve Mercer answered 3 years ago

Can you post your code in something like gist and and post the link.
 
Make sure the $servername, $username, $password, $dbname variables are set correctly.

0 Vote Up Vote Down
Rui Santos Staff answered 3 years ago

Hello Sabatino and Chris, can you please post your URLs? from your website that is receiving the requests.
Is it also correct in your code? The full URL?

0 Vote Up Vote Down
Chris answered 3 years ago

I have been able to fix the problem now. Once again fooled by the font style. So once I corrected the user names and passwords, it started to work as expected. I do like your courses and tutorials. They are really well written and presented.

Thanks

Chris

0 Vote Up Vote Down
Sara Santos Staff answered 3 years ago

That’s great.
Thanks.
I’ll mark this issue as resolved. If you need further help, you just need to open a new question in our forum.
Regards,
Sara

Primary Sidebar

Login to Ask or Answer Questions

This Forum is private and it’s only available for members enrolled in our Courses.

Login »

Latest Course Updates

  • [New Edition] Build ESP32-CAM Projects eBook – 2nd Edition April 16, 2025
  • [eBook Updated] Learn ESP32 with Arduino IDE eBook – Version 3.2 April 16, 2025

You must be logged in to view this content.

Contact Support - Refunds - Privacy - Terms - MakerAdvisor.com - Member Login

Copyright © 2013-2025 · RandomNerdTutorials.com · All Rights Reserved

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.